Hi there

I currently have two cubes - Basically a summary and detail. The detail have
more information in terms of measures and dimensions, however also has the
same dimensions as the summary. Basically on drill down on the lowest Item
level I require this detail information to be displayed.

Not sure how I would approach this but I need to be able to have a link
between the two cubes. Reading the currently selected information on the
summary and then opening the detail.

Any advise / ideas would be greatly appreciated.

Thanks in advance

Garron Mosley

That's exactly what Virtual cubes are for. Create a virtual cube, and run
the wizard, you'll get it.

Tore
"Garron" <Garron (AT) discussions (DOT) microsoft.com> escreveu na mensagem
news:4171C0C0-1E15-4A4D-8056-D4EEA9599663 (AT) microsoft (DOT) com...

What does the summary cube provide that the detail does not - after all,
summary info is derived from detail? Are you just trying to improve
performance at the summary level - in which case good aggregation design
may help?


- Deepak

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