MS SQL Server OLAP - Hide Automatic Grouping from the lowest level

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Hide Automatic Grouping from the lowest level

Troy Jerkins

2006-01-30, 1:24 pm

I'm running AS 2000 SP4. Have a dimension of Account names (around 340000)
My Dimension is setup as follows

[Account Grouping]
[Account Name]
The customer wants the grouping hidden but the problem I'm having, is when I
attempt to hide the grouping level, the processing fails because there
member names at the [Account Name] level that are not unique.

I have allow Duplicate Names = True at the Dimension Level

Is there a way around this or does every single Account name have to be
unique for this to work?

Regards,

-Troy

Sponsored Links