Drill Filters Are NOT Passed Correctly Through Hyperlink.

building reports webintelligence
1

Hi All,

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)

2

Hi Guys,

I am still facing the issue.

Could you please let me know if there is any resolution on this.

Thanks in advance !

techi_BO (BOB member since 2010-02-13)

3

Guys,

Any update…Please reply…

techi_BO (BOB member since 2010-02-13)

4

Hi All,

I am still facing this issue. Could you please let me know if anybody has any solution on this?

Thanks in advance!

techi_BO (BOB member since 2010-02-13)

5

Hi Yogesh,

You can do some basic checks to cross check the values captured by the DrillFilters function.

Create a object based on following formula & drag this on to the report. Then verify this object is returning the results as per drill selection or not.

If(DrillFilters([APAC Sen Mgr Cost Center Group])="";“ALL”;DrillFilters([APAC Sen Mgr Cost Center Group]))

If it’s behaving correct way then verify the Opendoc code.

patneel :india: (BOB member since 2006-11-02)

6

Hi,

Thanks for your reply.

I alreday checked and it is working fine with one Variable in the report.

The problem comes only when I am passing the variable through OPENDOC.

Anu futher inputs on this would be appreciated.

Thanks,
Yogesh.

techi_BO (BOB member since 2010-02-13)

7

Hi All,

Please let me know if there are any further inputs on this.

Thanks in advance !

techi_BO (BOB member since 2010-02-13)

8

I found several bugs with OpenDocument when I was trying to pass parameters from Performance Manager to Webi XIr2. It was one of the reasons (of very many) why we ditched EPM in the end.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

9

Thanks all for your reply.

As per BO tech support, this is a known issue in BO XI R3.

techi_BO (BOB member since 2010-02-13)