Skip to Content
0

Webi Input Control

Jun 15, 2017 at 07:19 PM

85

avatar image
Former Member

I Have a Webi report with Input Control(drop down box) with Default Value as My Stores in the input control with Filter operator Equal to and List of Values from Report.

My Store Formula: =[Profit Center - Key (Not Compounded)]Where([SAP User ID]=CurrentUser())

So when the report was executed in the input control Mystores should be default value with respect to the person who logs based on his SAP User ID and his store assignment,Instead of store number it should show My Stores, It was working earlier but now my stores is being displayed but not in the initial default view somewhere down in the drop down box user has to select my stores each time when he wants to see the report. How can we make it show as a initial default value when the report was executed.

Thanks in Advance

10 |10000 characters needed characters left characters exceeded

Hi,

How is the BW security on Store Managers assigned?, that should work in similarly in report too.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

BW Security was on roles --- managers assigned to a particular role and store assigned to that particular role

Ex; Store 1013 assigned to Role A

User ABC assigned to Role A hence user ABC can access only Store 1013.

0

Right, so User ABC was able to see other Stores too?.

How are they running the reports? scheduled or thru BI Launchpad?.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

scheduled through instances. User can see his store.

My store value is being populated when the report is executed. but it is not defaulting in the combobox in the initial view, it is somewhere in the down which user has to select each and every time.

0

Hi,

Can you try rescheduling the same report to test for a store manager and see if that works?.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

I tried but my stores values is not the initial default in the combo box. My stores is coming somewhere in the bottom in the combo box of input control.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers