Skip to Content
0

web intelligence

Nov 02, 2016 at 09:31 AM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Nov 02, 2016 at 09:39 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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]))

0
AMIT KUMAR
Nov 02, 2016 at 09:47 AM
0

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


input-control.png (12.2 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0