Heh, I guess so. In that case, you're spot on - buy another product. I remember evaluating a product to perform exactly what we get in SSIS (data...

Not sure if this will solve your problem, but you could try adding a few columns to your dim table holding the sq footage. By adding a delta and...

Not sure I understand how you'd consider this a Microsoft monopoly.... ODP.Net is provided by Oracle.

OPD.net isn't an option? http://www.oracle.com/technology/tech/windows/odpnet/index.html

Sorry, missed the last bit before.

Isn't there an option to save sensitive with password? Saving with user key will fail unless you're creating the package as your SQLAgent user....

Does the DSN exist on both servers (assuming your BIDS machine isn't your deployed server)? And is it a System DSN on both machines (ie if User DSN it...

Yep, you're right, my bad. I guess security could be used but the implementation would be cludgy (ie passing the context on the connection).

Sounds like, from the additional...

forgot to mention, there are (or at least were) tools around that would help you build local cubes, usually with subsets of the primary cubes data. If you...

Keep in mind that this will produce "the" cube with the selected data filters, not "a" cube - if you get two users running this, one after the other, your...

--Off topic-- the way (Cognos) Transformer handled the inclusion/creation of special time categories *really* kicks *** over the manual approach for SSAS :S

Guess I was hoping that Mosha's approach for SSAS2K would hold but not so sure. Looks like you're on a good path. Be aware of caching issues (see...

Realize I must be getting old and the eyes wearing out..... what is the difference between the two xml fragments you've supplied? If it's purely formatting, that's extraneous...

Sorry, no code of my own but there's definitely code out there on MSDN (more piecemeal than whole parts) but googling definitely returns other code samples/examples.

Generally, yes, having aggregation tables in a EDW can be used to assist query performance. This assistance could be through explicit usage in queries, or via technology (for e.g....

Not saying the approach is good/correct, but to answer the question asked.... Why not include a hidden dimension that has only 1 Attribute Hierarchy, and within that, only a...