Pass the dynamic parameters in webi parent to detail report using hyperlink

[Former Member]

Hi all,

I hope you are all doing well!!

Please help on below scenario.....

Scenario:

u2022 There are two reports one is source and an other one is target report.

u2022 Source report input parameters are Year and Company Name.

u2022 Target report input parameters are Company, Year and City.

u2022 Source report is having Drill functionality on Year and company.

u2022 YEAR>QUARTER>MONTH

u2022 Company-->Branch

u2022 Source report is having hyperlink on City

u2022 Source report is a cross tab report.

Now our requirement is, based on the level of drill parameters should pass to target report.

Scenario 1:

1. If source report at Quarter level hyperlink must pass company name ,year, city and Quarter to target report.

2. If source report at Month level hyperlink must pass company name,city,year,quarter and month to target report.

Scenario 2:

If source report at Branch level hyperlink must pass company name,year,city and branch to target report.

Is there any possibility to implement above scenario's in one report.

Version BO: BOXI3.1

[former_member142702]

I would recommend to check the documentation of openDocument URL

http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_url_reporting_opendocument_en.pd...

In a WebI report it is possible to identify the drill level by checking the results of the DrillFilters variables. Furthermore you can build the linking URLs dynamically using web variables. Make sure that the report element that displays the URL is set to display its contents as hyperlink.

For the month prompt make sure that you declare your universe prompt as optional. This way you do not always have to supply a value for this in your URL (eg. when the user has drill down to a specific quarter).

Regards,

Stratos

[Former Member]

Thank you very much Stratos !!!

Applied your suggestions and getting "#Multivalues" error in Source report, Please advise

Details,

Source report input parameters are Year,Company Name, No.Employees and City.

Source report is having hyperlink on City. but passing web parameters are

YEAR,QUARTE and MONTH (Drill purpose) in hyperlink - these all are optional prompts in Target report.

Getting #Multivalue errors in Source report in below cases:

1) Year, Company Name,No.Employees, City

2) Quarter, Comapny Name, No.Employees,City - ( drill applied on year; Year --> Quarter)

But, In this case it is working perfactly.

3) Month, Comapny Name,No.Employees, City - ( drill applied on Quarter; Year > QuarterMonth)

[former_member142702]

1) Create 3 tables, one for each drill level (Year, Quarter. month) one below the other.

2) Create 3 variables that put together your URLs, one for each drill level (Year, Quarte,Month) and add each on of those to the appropriate table

3) Go to the display properties of your tables and select not to display them when empty.

4) Use the DrillFilters function and create a dimension variable that will return 0,1 or 2 according to the drill level you are in.

eg.

if (DrillFilters([Year])="") then "0" else if ((DrillFilters([Year])<>"") and (DrillFilters([Quarter])="")) then "1" else  if ((DrillFilters([Year])<>"") and (DrillFilters([Quarter])<>"") and (DrillFilters([Month])="")) then 2 

5) Add on each of the above tables a block filter based on the variable created in step 4 and use the value of the appropriate drill level for which the table has to be displayed.

6) Change the position of all 3 tables so that they overlap.

Regards,

Stratos

[Former Member]

The above approach to get drill level does not work in one scenario..

Drill down one level and then set the drill filter to all...  in this case, drill level actually is 1 but as per the formula the drill level would show 0

[Former Member]

Hi Yuvaraj, I am facing the same problem. When i set the drill filter to all, DrillFilters() returns blank. Can you please share if there is a workaround for this? Thanks for your help.