Virtual Cube Question

[katams2]

I have a report which includes store level information and order level information, and have to display everything together.

Is it a good solution to produce two cubes at each level and make a vitual cube to see all info from both, or is it better to make a new fact table to roll up everything to the store level?

When is the best time to use virtual cubes?

Thanks in advance for any help!

 

[aalmeida]

You can find a Good Explanation with examples at "BOL" on the Article called "Working with Virtual Cubes" I think it would say more to you that I can write in here. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Welshbird]

I would say that you should use a virtual cube only if you know that you need to see the two individual cubes as well. Does the data easily sit in one fact table? Let me know more detail and I'll help if I can. Fi.