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 |