MS SQL Server OLAP - Named Set Alias

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

Named Set Alias

Paul

2005-09-23, 9:23 am

Hi,

I have a basic named set in a cube, consisting of 5 non-leaf members of a
single dimension that do not share the same parent, but are of the same level.

This works fine.

However, Rather than seeing all 5 members, I would like them to appear under
their own 'parent'. what I need is to 'alias' them under a name like 'Basic
Wages' and then under this will be the members of the named set.

The only 'Alias' I have found is one to refernce them in MDX, not quite what
I want, but close!

Ta
Paul

Sponsored Links