I did a "New Database Query" to bring in a cube and I'm trying to figure out
if there is a way to only hide certain levels of the cube. For instance, the
cube has a dimension call "Fiscal Year", which contains the year, quarter,
month, and week number. Is it possible to only show year and week. I've
been able to hide all but week and all but year, but I have not found a way
to hide just the quarter and/or month levels. Any help you could give me
would be much appreciated. Thanks!

Hi,

Since each level is a subset of the level above it, I don't believe you can
hide an intermediate level and leave the outer levels exposed. I believe
this is inherent in the OLAP concept. However, you may be able to work
around this limitation by manually group the lower levels. I don't have a
complex enough cube file to test this idea.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

Hope this help

"Jordan" wrote:

I did a "New Database Query" to bring in a cube and I'm trying to figure out
if there is a way to only hide certain levels of the cube. For instance, the
cube has a dimension call "Fiscal Year", which contains the year, quarter,
month, and week number. Is it possible to only show year and week. I've
been able to hide all but week and all but year, but I have not found a way
to hide just the quarter and/or month levels. Any help you could give me
would be much appreciated. Thanks!

That was kind of what I was afraid of. I know that one way around it is to
build a separate time dimension, in my cube, that only incorporates the
levels I'm interested in for specific things, but then that can make things
kind of messy.

"Shane Devenshire" wrote:

Hi,

Since each level is a subset of the level above it, I don't believe you can
hide an intermediate level and leave the outer levels exposed. I believe
this is inherent in the OLAP concept. However, you may be able to work
around this limitation by manually group the lower levels. I don't have a
complex enough cube file to test this idea.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

Hope this help

"Jordan" wrote:

I did a "New Database Query" to bring in a cube and I'm trying to figure out
if there is a way to only hide certain levels of the cube. For instance, the
cube has a dimension call "Fiscal Year", which contains the year, quarter,
month, and week number. Is it possible to only show year and week. I've
been able to hide all but week and all but year, but I have not found a way
to hide just the quarter and/or month levels. Any help you could give me
would be much appreciated. Thanks!