Hi, experts,
Can we drill down to details for calculated members of a cube? Or we can only drill through to details for measures residing in a specific measure group in a cube?
Hope it is clear for your help.
I am looking forward to hearing from you shortly and thanks a lot in advance.
With kind regards,
Yours sincerely,
Drilldown (navigating in a hirarchy tree) is possible through all members - even calculated once
I guess what you ask is drillthrough (http://technet.microsoft.com/en-us/library/ms145964.aspx) and this works only on base measures as far as I know. (SQL Server 2005)
HANNES
|||Hi, Hannes,
Thanks a lot for your help.
Sorry for the mistyping, yes, I was asking for 'drill through' capability for calculated members.
Thanks again.
With kindest regards,
Yours sincerely,.
|||Hello you two,
Today I searched a solution for this problem too.
And I came to the same result as you are.
Then my result is right … I hope so =)
Have a nice day
Alex
|||Hello experts,
I’ve got an idea but I don’t know how to continue ….
I thought if you can’t make a drillthrough on a calculated member I can program one.
On the website Microsoft technet I found the code snippet:
DRILLTHROUGH [MAXROWS Unsigned_Integer] <MDX SELECT statement> [RETURN Set_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]
But where is the point to take it in?
Best regards
Alex
|||Hi,
if your question is- with which programm could you execute an drillthrough statement?
SQL Server Management Studio - its a regular MDX Statement.
Best regards, HANNES
|||Hello Hannes,
Thanks for the response. I know that, but I searched for a possibility to upgrade the cube through programming some parts.
Best regards, Alex
