Report 10.1.2 - OLAP-to-Relational Drill-Through

[gosoccer]

OK. this should be simple but I'm stuck!!
::)
First Report is an OLAP Report. The Definition is the first attachment,
"Only when required parameter value is missing" In this case, it is not.

The second report (Target) has a parameter specified as a part of the report's Query,
Detailed Filter = [BUSINESS_VIEW].[RYY_QUERY].[ORG_ID] = ?param?

After selecting the drill-down, instead of displaying the TARGET based on the parameter A.
it keep displaying a prompt page asking for the ORG_ID while param is being passed from the
Source to the Target in this case.

Any help will be greatly appreciate it.  :)

[gosoccer]

Here is the Drill Through Definition.

[Lynn]

It looks like you are passing the MUN from your OLAP report which your relational report surely won't know what to do with. Does the business key or caption contain the ORG_ID?

[gosoccer]

It seems like the Member Caption does. I'm sorry but how could you tell in the Source
if the Business Key is there or member Caption?

[MFGF]

It seems like the Member Caption does. I'm sorry but how could you tell in the Source
if the Business Key is there or member Caption?

Right-click on a member in the package tree and choose "Properties". The business key is the last part of the Member Unique Name.

MF.

[gosoccer]

Yes, it is there!
cube-xxxx-pilot].[ORG_ID].[ORG_ID].[ORG_ID]->:[PC].[@MEMBER].[ORG_ID]

[gosoccer]

I changed the Query-Filter on the Target Report to Optional and Put the following in the header of the report ParamDisplayValue('param'), but nothing is displayed.

A new Drill Through Definition is attached.
RPT_ORG_ID is same as ORG_ID in this forum.

Thx

[gosoccer]

OK, I made it a lot simper. I have one report just with one Text Item (W/ Drill Through Defivition) and in the Query, I have the member as N (Dim. Hierarchy ORG_ID and member as N with the mun value.) I defined a Drill Through using the  following parameter,

Name:ORG_ID  Type: String       Method: Pass Data Item   Value  Value N          Property to Pass: Member Caption.

It works great and the target report is displayed showing only records related to N. 

Here is what's strange. After adding one more member as A to the same Query and created a second Drill Through in the same way, I get the blank for the passed parameter and the GO TO shows nothing is getting past.

I'm curious as to why after adding a second member to this Query that has the Dim. and Hierarchy, the Drill Though is chocking....

Thank you in advance for your time. Please let me know if you have any suggestions.
:) :)

[gosoccer]

The value I was going to use from the Query wasn't listed as a apart of the Crosstab. Once I have the value listed, the Drill-Thru works just fine using the below parameter for Business_Key or Member Caption.

Name:ORG_ID  Type: String       Method: Pass Data Item   Value  Value N          Property to Pass: Member Caption.

Thanks everyone for your recommendations :) :)

[bi4u2]

gosoccer - don't forget you can use the RoleValue function to determine things like Business Key, Caption, MUN, etc for your members