im working with as/rs 2005 and need help in creating a report.
my cube has a parent child hierarchy in "category".
structur is as follows:
Aa1
2b
B Cf
g10
1112
I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...)
there is a function called children, but i am not able to obtain my desired result. (in fact, i dont get any result with this fuction)
every little bit that shows me the right direction is highly appreciated ...
sincerely,
Rhapsody
If I understand you correctly, this should do the trick:
with
member [Measures].[UNMChildren]
as 'GENERATE(EXCEPT(descendants([Category].currentmember,10,SELF_BEFORE_AFTER),[Category].currentmember),
[Category].currentmember.uniquename, ","
)'
select {[Measures].[UNMChildren]}
on columns,
{[Category].members} on rows
from CubeName
Hope this helps,
Santi
|||thank you santi, but that was not it ... or i didnt apply it the right way ...i will provide you with some more details ... maybe you can help me than...
im using the adventure works dw.
measures: fact finance
dimension: dim organization (esp. parent child hierarchy: parent organization key)
i have a query parameter "DimOrganizationParentOrganizationKey", which is a multivalue parameter and user can choose IDs (from different levels) he/she wants to see.
the structure of the IDs looks as follows:
1|||
I'm sorry, but I can't help you with Reporting Services.
As far as I know, the mdx should be able to return the uniquenames of a dimension member's descendants separated by commas.
Maybe if you have a secondary datasource in Reporting Services which returns the Unique Names of the members passed by parameter, you could be able to use that to make visible/invisible the appropriate members. Not sure though...
sql