Question Input Control

building reports webintelligence
1

I have 2input controls ina Web-i Report.
Department and Employee

Now when my user selects department from the list of input control he does not see the the employees for the selected department. He sees all the employees.

How can I restrict the values in the Input control.

Note: I already have cascading prompt in my universe for Dept and Employee , but the user selects more than 1 dept (via prompt) and then wants to use input control to filter more values.

Please advise how can I use input control so that it shows the values for the selected department.

Thanks

Masonlko (BOB member since 2010-06-11)

2

Check the underlying query for the LOV of the Employee dimension in the Universe. Since you have already set-up cascading prompts, it should have a where clause for Department. Change the operator to an “In” instead of “=”. Also, ensure that you Department prompt allows to choose multiple values.

nithya_raj (BOB member since 2007-02-03)

3

The underlying Query in the Universe already has IN LIST.

Also one thing to note is that I am using 3 queries to get all the measures and Dept and Emp is in all of them. Is this (Merge Dimension) causing any conflict?

Please advise

Masonlko (BOB member since 2010-06-11)

4

I dont think merged dimensions is the issue. While creating the prompt(in Universe or report), you would have chosen the field from a particular Data provider right?

It would help if you could paste the SQL being generated with the prompts.

nithya_raj (BOB member since 2007-02-03)

5

At present, there is no “out of the box” solution for implementing cascading Input controls.

However, it sounds like this facility might be on its way in a future release.

http://forums.sdn.sap.com/thread.jspa?threadID=1683432
(see the post from David Brunner)

I have looked at the Release notes for SP3 and there is no mention of the feature there. Perhaps it will be implemented in BOXI 4?

Cheers,
Sean

Sean Reynolds :uk: (BOB member since 2004-12-16)

6

I am having the problem has anyone figured out a way to solve this issue

Poonam (BOB member since 2009-12-10)