Hi there

Is it possible to return calculated members in a set, rather than just using
the AllMembers function on a dimension or level?

For example, if my hierarchy looked like this

parent
child member1
some more grandchildren
child member2
some more grahndchildren
child member3
calculated member4

and I wanted to use DRILLDOWNMEMBER on parent to return child Member 1 - 3
plus the calculated member (but not the grandchildren) how would I do it?

TIA

Look into the function AddCalculatedMembers() in BOL.

"Graham Lloyd" <gilly1409_NOT (AT) hotmail (DOT) com> wrote

If you're using AS 2005, keep in mind that AddCalculatedMembers() seems
to have a bug - which may be fixed in SP1:

http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!525.entry
...
Basically there's a bug in the AddCalculatedMembers function which means
that it brings back calculated members which it shouldn't actually bring
back. Since AddCalculatedMembers isn't the most widely used function
you'd think it wouldn't have much impact, but one area that it might
cause a problem is when client tools issue MDX queries to get metadata
for display purposes - a fairly widely used technique.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Never use Microsoft products before Service Pack 2.


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

any dates due for SP1 of SSAS? We are currently using 2000 but upgrading in
the near future and this but of functionality is key to our client app?

Any chance of a hotfix in the meantime?

Cheers for the responses




"Elad" <elad&&&7690@hot&&&mail.com> wrote