|
Home > Archive > MS SQL Server OLAP > November 2005 > All members of a level, except for local calculated members
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 |
All members of a level, except for local calculated members
|
|
|
| Hi,
Is there a way to retrieve all members of a level, including calculated
members defined on the cube but excluding calculated members defined only in
the query's scope? Level.Members excludes all calculated members.
Level.Members includes ALL calculated member, including those defined in the
WITH clause.
Thanks!
| |
|
| One more thing - I do not know in advance what local calculations will be in
the query. The WITH clause may contain anything.
"Jimmy" <NoSpam> wrote in message
news:%23AeA8LB9FHA.1292@tk2msftngp13.phx.gbl...
> Hi,
>
> Is there a way to retrieve all members of a level, including calculated
> members defined on the cube but excluding calculated members defined only
> in the query's scope? Level.Members excludes all calculated members.
> Level.Members includes ALL calculated member, including those defined in
> the WITH clause.
>
> Thanks!
>
| |
| Darren Gosbell 2005-11-28, 8:25 pm |
| I don't think there is a way to do this.
Have you thought about setting up your calculations using customer
rollup formulas or calculated cells. This would make them appear as
"real" members, but still let you calculate the values.
Of course it depends how many of these calculations you have and how
complex they are, but this might be a work around.
HTH
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <OefZ1RB9FHA.1484@tk2msftngp13.phx.gbl>, "Jimmy" <NoSpam>
says...
> One more thing - I do not know in advance what local calculations will be in
> the query. The WITH clause may contain anything.
>
> "Jimmy" <NoSpam> wrote in message
> news:%23AeA8LB9FHA.1292@tk2msftngp13.phx.gbl...
>
>
>
|
|
|
|
|