passing values from parent to child report

3018071

I have a parent report that contains

   

Month	Brand	Header 3
Jan Feb Mar Apr May Jun	lee spyker wragler zara veromoda mango	282 478 246 267 309 264

Here 282 is the count(item_no) .

In the child report i want all the item wise detail. If the user clicks on 282 ,it should display all the 282 item details in the child report.

Item no	item name	item purchase date	item mfg date	size
10003211	jeans	01-01-2017	31-01-2016	30
10003212	jeans	01-01-2017	31-01-2016	32

All i need is, i need to pass all the item numbers from parent report to child report. Can it be possible.

I am unable to achieve it please help me in this regard.

Reagrds,

Bishnu

Gianni Ceresa

Hi,

3018071 wrote:All i need is, i need to pass all the item numbers from parent report to child report.

This is actually the wrong question and wrong approach...

In your summarized table the item numbers doesn't exist, it's an aggregated view, so you do not pass the item numbers to the child report but you pass the information of the aggregation.

In your case for 282 what you need in the child report is "month=Jan" and "brand=lee", that's all you need.

Filtering your child report based on these 2 values you will then get all your details out.

On the child report you don't need to display the information of Month and Brand but they will definitely be helpful for the use to remember what he is seeing (in case of an export or print).

3018071

Ok i got your point.

But in my case the parent report columns and the child report columns are from completely different tables.

The only link between parent and child report is item_id.

so in that case what should be my approach as i cant pass the dimensions to the child report from the parent.

Gianni Ceresa

But you don't have item_id in the parent report, or if you have it it's excluded (which is a bad practice).

Your model is a bit strange (not complete or wrong): as there is a link connecting these datasets, that link can be modelled in the RPD so you can really use the OBIEE functionality of navigation and drill to analyze your data.

Do you really have the item_id column in the first (parent) analysis?

3018071

No I don't have. If I have the item_id in the parent report then the count(item_id ) will be wrong as it will group by the item_id too.

Any how i can add item_id child report.

But along with dimension columns do i need to pass the count column too o the child report.

Joel

What you are trying to do is standard OBIEE OOTB functionality so I'd strongly suggest that you take a look at some of the OBIEE tutorials especially this one:

https://apexapps.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:12164,1 

Thomas Dodds

Sounds like your model isn't ... you need related data and specified logical relationships.   Sounds like your RPD is configured to run like a query tool and not a business logic layer.

Model correctly and the Master-Detail functionality of OBIEE solves your issue.