web intelligence

[former_member200330]

Hi Experts,

Is there a way we can pass the report filter(Set up in Filter bar) value selected in the first to the second tab of the report?

Also is it possible to pass the the report filter value to a different report?

Please advise.

Regards,

NRR

[amitrathi239]

if your BO version is BI 4.1 SP06 or above then you can apply single input control on whole document.

[former_member200330]

Hi Amit,

Thanks for the reply, due to security reasons the users wont be having access to the left tool bar which shows input controls.

Is there a way we can accomplish this without input controls?

Thanks in advance.

Regards,

NRR

[former_member198519]

Try something like this:

[Variable]=reportfilter([Region])

Use opendoclink to access the second report and pass the region variable data with it:

http://../BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=567&sType=wid&sRefresh=Y&lsSRegion=([Variable]).

Also have a look at this blog post. Web Intelligence – Input Control that affects all tabs

[former_member200330]

Hi Kuldeep,

Thanks for the reply, but the problem is this is not a report filter, this is a filter that we created in the report on the filer bar.

In other words this is a Drill Filter. Is there a way we can pass the Drill filter to tabs in the same report or a separate report?

Thanks in advance.

Regards,

NRR

[former_member198519]

If they are Drill Filters then why don't you use drillfilter(). Try using the below

http://../BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=567&sType=wid&sRefresh=Y&lsSRegion=(Drillfilter([Region]))