Skip to Content
0

Store Input Control in Webi

Jun 19, 2017 at 01:22 PM

22

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. below are the formulas used Store Store Input Control formula

=If(Not(IsNull([Mystore]));"My Stores";If((IsNull(MemberAtDepth([LumberLiquidators ProfitCenter Hierarchy];4)));If(UserResponse([ProSales];"Region or Division")=[LumberLiquidators ProfitCenter Hierarchy];"My Stores";[Profit Center - Key (Not Compounded)]);[Profit Center - Key (Not Compounded)]))

MyStore formula

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

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

0 Answers