MS SQL Server OLAP - Ragged Hierarchies AS2005

Author

Ragged Hierarchies AS2005

Aiwa

2005-11-30, 11:24 am

Hi,

I'm currently having some problem defining a radded hierarchy, for some
reason if I set the HideMemberIf property to NoName it does not hide the
level from the dimension even if the level name is blank.

Here is what I have currently:
Company A
Department A
Employee 1
Employee 2
Company B
<Blank>
Employee 1
Employee 2

Here is what I want:

Company A
Department A
Employee 1
Employee 2
Company B
Employee 1
Employee 2

How can I acheive that ? Looks like the HideMemberIf property is not enough...

Thanks,
Eric

Martin Kratky [INTALIGN]

2006-01-30, 7:24 am

Hi Aiwa,

I had a similar problem... It depends on the connection string that your
client application is using. Interestingly hidememberif only works when you
use the property: "MDX compatibility=2" in the connection string to the MS AS
2005 db.
Unfortunately in the integrated cube browser in the BI studio I haven't
found a way to specify that but if you use a client application where you can
edit the connection string it works fine.

Don't ask me, though, why this isn't used by default...

--
Greetings from down under!

Martin

"Aiwa" wrote:

> Hi,
>
> I'm currently having some problem defining a radded hierarchy, for some
> reason if I set the HideMemberIf property to NoName it does not hide the
> level from the dimension even if the level name is blank.
>
> Here is what I have currently:
> Company A
> Department A
> Employee 1
> Employee 2
> Company B
> <Blank>
> Employee 1
> Employee 2
>
> Here is what I want:
>
> Company A
> Department A
> Employee 1
> Employee 2
> Company B
> Employee 1
> Employee 2
>
> How can I acheive that ? Looks like the HideMemberIf property is not enough...
>
> Thanks,
> Eric
>
>

Sponsored Links