| FurmanGG 2006-03-29, 8:27 pm |
| I'm a little disappointed with how parent-child dimensions are rendered in
Report Builder and I'm looking for suggestions. (Of course, I'm talking about
using a model which is generated on top of an SSAS cube.) If I'm looking at a
standard dimension, each level in the hierarchy will be a separate attribute
(such as Region and City), so it's easy to just drop Region and City onto a
Report Builder report and get the nice nesting I want. However, with
parent-child dimensions, each level isn't a separate attribute... and since
Report Builder doesn't render any hierarchies in a dimension, I can't figure
out a way to build a Report Builder report which would have a Region column
and a City column if both Region and City are part of the parent child
dimension. Any suggestions would be appreciated.
The reason we had to make it a parent-child dimension is because one measure
group can have facts at several levels... so the only way we could do this is
with a parent-child hierarchy as standard dimensions can only have data at
one grain per measure group. (Correct me if I'm wrong.)
Thanks gurus.
|