Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report 10.1.2 Drill Through Problem from Report Author (OLAP) to Report Author (Relational)

Status
Not open for further replies.

goice

Programmer
Aug 19, 2014
1
0
0
US
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
Type: String Method: Pass Data Item Value Value ORG_ID Property to Pass: Default

If anyone can help, I'll greatly appreciate it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top