Union with presentation variable values not passing into Drill through page???

2964744

Hi All,

Issue Summary:

Obiee union report column formula (case condition with presentation variable) values not passing into drill through/detailed page.

Environment:

Tested in latest Obiee 11.1.1.7.160119  and also tested in Obiee 12.2.1.0.0 (Build BIPS-20151008013645 64-bit)

Issue Detailed : Formula with presentation variable which is in Dimension column, that value is not passing to detail report from summary report(Union Report). Note its working in normal report.

1. There are two reports, Summary Report and Detail Report.

2. Summary report is an union report. there are two dimension columns, Group and Country.

3. Group dimension column doesn't have custom formula. Country dimension column have custom formula like as below

In below custom formula we have Presentation variable.

CASE WHEN "Final Booking Country"."FBC_GRP_DTL" = 'SINGAPORE' THEN 'SINGAPORE' WHEN "Final Booking Country"."FBC_GRP_DTL" = 'HONG KONG' THEN 'HONG KONG' WHEN "Final Booking Country"."FBC_GRP_DTL" = 'CHINA' THEN 'CHINA' WHEN "Final Booking Country"."FBC_GRP_DTL" = 'TAIWAN' THEN 'TAIWAN' WHEN "Final Booking Country"."FBC_GRP_DTL" = 'INDONESIA' THEN 'INDONESIA' WHEN "Final Booking Country"."FBC_GRP_DTL" = 'INDIA' THEN 'INDIA' WHEN "Final Booking Country"."FBC_GRP_DTL" = '@{PV_SINGLE_DCOR}' THEN '@{PV_SINGLE_DCOR}' ELSE 'REST OF THE WORLD' END

4. Detail report has same dimension columns with formula and filter is applied as prompted. Exactly same as summary report.

5. Dimension column(Country) value which is having formula and presentation variable is not passing to detail report form union summary report.

6. If we remove the Presentation variable then the summary report(Union) passing dimension value to detail report.

Note : When do this same in normal report(without union) its working(i.e value passing to drill through). only the problem that we are getting is in union report if we use presentation variable then the value is not passing to detail report.

If you have any idea/solution please share with us.

by the way we have checked with oracle & they tested and said as bug (development team working on it), if you have any work around/suggestion please share with us. tks

Thanks

Deva

Carina Mendes

Hi,

I also tried using the native drill configured in hierarchies in my analysis with union, but they do not work.

I believe the union changes the form of the metric aggregation and therefore lost this functionality for analysis with union.

Good luck, let us know if you can, please!

Regards,
Carina Mendes.

[Deleted User]

tl;dr in detail but first of all if you have functional issues with a union then maybe think of pushing things to the RPD as far as possible.

Secondly I would appreciate not being sent messages to my private email any more, pointing me to an OTN question - it basically guarantees that I won't read it all word by word.

2964744

Hi Christian,

Sure, we also tried request variable option (RPD) instead of presentation variable method but no luck. thanks

Regards,

Deva