team;

I have a table with budget information, and a table with actual expenses.

I currently have these in 2 cubes; but I need to bring these back into 1
cube.

My alternatives are to:

1) write a view
2) a virtual cube on top
3) make each cube into 1 partition of a single cube

Can you guys let me know that the view is the best route; and also-- if i
wanted to go the virtual cube route; what would I need to do to do that?

My gumption just tells me that since these cubes are different shape, that
doing a virtual cube might be difficult... And I think that having multiple
partitions would only complicate this (but the nice thing about multiple
partitions is that I would only need to process budget information once a
month for example, right??)


Thanks

Aaron Kempf
Safeco

If the budget and actuals tables have different grains (and this is
reflected in the respective cubes), it may be better to create a virtual
cube, because then you can retain the grain in each. Shared dimensions
will need appropriate levels at which to join to each fact table.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!