dbTalk Databases Forums  

Drill Through functionality for calc members

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Drill Through functionality for calc members in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Audrey
 
Posts: n/a

Default Drill Through functionality for calc members - 01-12-2004 , 12:36 PM






I am writing in reference to a newsgroup article from April last year
in which a useful Drill Through statement was provided for Actions in
Analysis Manager. (http://groups.google.com/groups?hl=e...TNGP12.phx.gbl)

I reviewing Actions and in specifically the use of Drill Through via
Actions to retrieve transactional detail from an underlying Oracle
warehouse, but from a calculated member. The calculated member has a
series of IIF statements and what is retrieved will depend upon the
Data Type (Order, Ship, Revenue) and Time Period the user is currently
reporting on.

I have the sample statement working for a metric available in the
warehouse, but stuck as to how this can be adapted for a calc member.


Regards,
Audrey Lloyd

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.