Hi,
I'm trying to establish a Drill Through from an OLAP to a Relational Report. No matter what I do, it is not passing the
parameter correctly.
Nothing shows as a part of the Target Report (Relational). If I keep the Filter Required, the Prompt is displayed.
If I turn Filter to Optional, blank is displayed for the ORG_ID.
TARGET
I have ParamDisplayValue('ORG_ID') on top of the page to show the parameter passed.
The Query has this parameter in the Target as [BUSINESS_VIEW].[RTS_QUERY].[ORG_ID] = ?ORG_ID?
Source,
I have a member called ORG_ID as a part of the Query. The drill through definition is as following,
Name:ORG_ID
If anyone can help, I'll greatly appreciate it.
I'm trying to establish a Drill Through from an OLAP to a Relational Report. No matter what I do, it is not passing the
parameter correctly.
Nothing shows as a part of the Target Report (Relational). If I keep the Filter Required, the Prompt is displayed.
If I turn Filter to Optional, blank is displayed for the ORG_ID.
TARGET
I have ParamDisplayValue('ORG_ID') on top of the page to show the parameter passed.
The Query has this parameter in the Target as [BUSINESS_VIEW].[RTS_QUERY].[ORG_ID] = ?ORG_ID?
Source,
I have a member called ORG_ID as a part of the Query. The drill through definition is as following,
Name:ORG_ID
Type: String Method: Pass Data Item Value Value ORG_ID Property to Pass: DefaultIf anyone can help, I'll greatly appreciate it.