Hi,
I've created a virtual cube called "Sales", based on my main cube, "KPI"
What i want is to filter out the dimension members used in the KPI cube, which don't relate to sales.
E.g. My "Indicator" Dimension consists of the following members:
"1 - Client"
"2 - Patient"
"3 - Visit-Service"
"9 - Appoitments"
"99 - Corporate Financial"
What i want to happen is to only allow decendants of the "99 - Corporate Financial" member to be available when viewing this virtual cube.
Is this possible and does anyone have any suggestions as t how i might go about it?
Thanks in advance.
Cheers,
Leigh
"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his partner by spending all his spare time fishing!
I've created a virtual cube called "Sales", based on my main cube, "KPI"
What i want is to filter out the dimension members used in the KPI cube, which don't relate to sales.
E.g. My "Indicator" Dimension consists of the following members:
"1 - Client"
"2 - Patient"
"3 - Visit-Service"
"9 - Appoitments"
"99 - Corporate Financial"
What i want to happen is to only allow decendants of the "99 - Corporate Financial" member to be available when viewing this virtual cube.
Is this possible and does anyone have any suggestions as t how i might go about it?
Thanks in advance.
Cheers,
Leigh
"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his partner by spending all his spare time fishing!