I have "converted" my OLAP db from AS2000 to AS2005. Hierarchical dimension
are giving me fits! I am having an issue with my MSAS 2000 dimension
hierarchy that suppressed attributes with blank spaces, my AS2005 dimension
is not. Here is an example of what I mean:

If I have a hierarchy that consists of

Col 1
Col 2
Col 3
Name

If Col 3 is space filled, I want it to go straight to the Name col and
suppress the blank Col 3 (for instance when you browse the data). How do I
do this in AS2005? So it should look like:

Col_1_data
Col_2_data
Name_data

--
Thanks,

Jason

We do the same thing, and it should be the same as 2000. You set
HideMemberIf to NoName on each level of the hierarchy, and then I think you
have to specify MDX Compatibility=2 in your connection string


"JasonDWilson" <JasonDWilson (AT) discussions (DOT) microsoft.com> wrote

I did the same thing, but if I am just browsing the dimensions in the SQL
Server Business Intelligence Studio, I cannot get it to be have like this,
but it behaves correctly in AS2000 Cube designer when I browse the dimension
there. Is there any way to make this behave correctly in SQL Server Business
Intelligence Studio AS2005?
--
Jason


"Mike Washburn" wrote: