Input Controls

building reports webintelligence
1

Can we use Cascading LOVs with input controls?? If yes How??

Thanks for the help in advance :slight_smile:

Poonam (BOB member since 2009-12-10)

2

The two concepts are not related. Cascading LOVs drive prompts. Input controls are on the report. What are you trying to accomplish?

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Unfortunately not.

LOVs are used at the query level (in queries are in prompts). The input controls are effectively filters on the result sets so are completely separate.

dfoster99 :uk: (BOB member since 2010-11-05)

4

what i am trying to do

I have 5 input controls so what i want to do is when i select the first one it should filter out the rest 4 based on the selection.

for example

Country—>State—>City—>Zip code

when i select Country it should filter the state, city and zip code for that country only and then state should filter the city and zip code for just that state.

I hope that explains it better and thanks for the quick reply I really appreciate it.

Thanks in advance…

Poonam (BOB member since 2009-12-10)

5

Drill filters are dependent on each other; input controls are not. You might try experimenting with drill filters instead.

In my opinion, this is a flaw that should be addressed in a future version. Has anybody played with input controls in BI 4.0 yet that can comment on this behavior?

Dave Rathbun :us: (BOB member since 2002-06-06)

6

i hate to say it, but you are describing Qlikview behaviour (I know, i will seek penance immediately :wink: ).

It may be for this kind of dynamic data exploration you need to look at a different product (I am deliberately not mentioning Explorer here as it doesn’t sound like a good fit)

dfoster99 :uk: (BOB member since 2010-11-05)

7

Thanks for the feed back guys if it was xcelsius i would have done it with no problems but they want it done in webi… i did figure out a good work around that would cascade using input controls but its not 100% ready yet but will provide feed back once it is…

Poonam (BOB member since 2009-12-10)

8

another question can we put a scroll bar on a data block…
So what i need to do is if the data block is returning 100 rows i just want to display 10 and put a scroll bar for them to see the rest

thanks in advance !!

Poonam (BOB member since 2009-12-10)

9

no :smiley:

Definitely a mismatch in reporting requirements and tool selection.

BTW do your clients know that you can upload Xcelsius dashboards into Infoview and view them alongside infoview reports?

dfoster99 :uk: (BOB member since 2010-11-05)

10

Yes they do know that but we are returning 50000 rows of data… that wont work in Xcelsius

Poonam (BOB member since 2009-12-10)

11

Ouch!

Hence the need for the smarter filtering or better summarisation before they need to look at the detail.

dfoster99 :uk: (BOB member since 2010-11-05)

12

It might not be a bad idea to use both Xcelsius and webi.
I could use Xcelsius for input controls and high level and then detail in webi via opendoc…

what do you think??

Thanks

Poonam (BOB member since 2009-12-10)

13

I have proposed that idea to a client before. Using content-linking in a corporate dashboard between a dashboard doing the filter presentation and a webi report showing the data. The challenge would be that content linking can be cranky at the best of times.

dfoster99 :uk: (BOB member since 2010-11-05)

14

Will keep that in mind thanks for the feed back :smiley:

Poonam (BOB member since 2009-12-10)