Can we pass drill filter parameter from parent WebI to child

[system]

Hi All,

Is it possible to pass the drill filter parameter from a parent WebI report to Child webI report.

Here is the scenario:

There ar 2 WebI reports: Test1 and Test2.
Test1 is the parent report which is having the drill options and a link to detial report.

Depending upon user selection of Region, Market Unit or Country the detail report should display data dynamically by taking those drill filters as input for prompts of second report.

ie. if user drills to region = APJ, detail report should only display APJ Data at detail level.
If user is on drill level = Market Unit, only that Market unit details should be displayed, similarly for country.

I am able to pass the drill parameters of Test1 report using the formula:
="<A HREF=https:///OpenDocument/opendoc/openDocument.jsp?sType=wid&sDocName="+URLEncode(“Test2”)
+"&sWindow=New&lsMRegion="+URLEncode(If(DrillFilters([Region])="" ; [Region_All];DrillFilters([Region])))+"&lsMMU="+URLEncode(If(DrillFilters([Market Unit])="" ; [MU_All] ; DrillFilters([Market Unit])))
+"&lsMMU="+URLEncode(If(DrillFilters([Country])="" ; [Country_All] ; DrillFilters([Country])))
+">"+“Detail Report”+""

But I am not sure what formula I need to write in the Test2 report so that column changes based on the drill filter selection in Test1 Report.

Can you please someone help me out in this?

Thanks in Advance.

Regards
Sindhu

---

sindhu_cs (BOB member since 2009-04-24)

[system]

=“<A HREF=https:///OpenDocument/opendoc/openDocument.jsp?sType=wid&sDocName=”+URLEncode(“Test2”)
+“&sWindow=New&lsMRegion=”+URLEncode(If(DrillFilters([Region])=“” ; [Region_All];DrillFilters([Region])))+"&lsMMU=“+URLEncode(If(DrillFilters([Market Unit])=”" ; [MU_All] ; DrillFilters([Market Unit])))
+"&lsMMU=“+URLEncode(If(DrillFilters([Country])=”" ; [Country_All] ; DrillFilters([Country])))
+“>”+“Detail Report”+“”

first thing that you are tring to pass Values of Market Unit and Country in one prompt of next report. it is purposly or typo?

and if u r passing values in different prompt then by capturing values of prompt through user response and you can hide columns accordingly…

i think this will solve ur issue…

revert me if any…

---

priyank_bhayani (BOB member since 2008-12-22)

[system]

Take a look at this thread below, it’s a similar situation that may give you some ideas…

120×120 10.4 KB

Hi All, I need some help with one of my requirements. I have a report which prompts user to select the Metric Name - for ex a or B now i need to pass this to second report and based on this metric value this report needs to apply a filter (may be a case logic) Please let me know how to pass this from first report and then how to read this in second report to determine the filter value. Any help is appreciated, please let me know for more info. Thanks, reachmenow (BOB member since 2009-10…

In your case you want to have a different value instead of filtering… so you would just have a single variable, that depending on the UserResponse input would output a different Universe object.

Something like:

Var_CustomColumn => IF UserResponse = ValueX Then Universe.Object1 elseif Userresponse = ValueY then Universe.Object2 else Universe.Object3

(Note that’s not BOBJ syntax but the logic is the same)

---

JPetlev (BOB member since 2006-11-01)

[system]

Hi JPetlev,

Thanks for your comment…

---

priyank_bhayani (BOB member since 2008-12-22)

[system]

Hi Sindhu,

Could you let me know about the resolution of mentioned problem.

I am using the same syntax and facing the issue with Drill Filter.

---

In the parent report, I have merged dimensions as drill Filters. In the detail report (Called from Parent using Opendoc) there are prompts for Drill FIlters.

For ex: Hyperlink code for one Drill Filter.This value will be passed to detail report prompt.

="<a href=…/…/…/OpenDocument/opendoc/openDocument.jsp?&iDocID=ASn_Z6loBVpEpjtf1UPvPJ4&sIDType=CUID&sType=wid&sRefresh=N&sWindow=New&lsMAPAC+Sen+MGR+CCTR+Group="+If(DrillFilters([APAC Sen Mgr Cost Center Group])="";“ALL”;URLEncode(DrillFilters([APAC Sen Mgr Cost Center Group])))+">"+“Click Here To View Detail Report”+""

Report Behaviour:-

1. Initially when Drill filter value is "All Values’ and user clicks on Hyperlink, “ALL” is passed from Parent to Child which is as expected.
2. When the value is changed from Drill Filter for ex: China, the changed value is getting passed to Detail report prompt.This is also as expected.

Issue :-

When I again changed value to “All Values” from Drill Filter then “ALL” should be passed to Prompt. However Last changed value “China” is getting passed to Detail Report Prompt.

Does anyone have any idea about resolution of this. Please advise

Thanks in advance !

---

techi_BO (BOB member since 2010-02-13)