on 10-15-2014 7:17 PM
Hi Team System Environment: SAP BW 7.1 & BO 4.1 SP4 Issue-BO Web intelligence reports not displaying list of values for variables while running query Info-provider for Bex query -BW Cube Source for Webi-Report -Bex query Connection type -BICS Connection we have design a BO WebIntelligence report on top of Bex query using BICS connection with couple of Variables When Bex query is executed in BW Environment able to see LOV's for variable When BO Webi report is executed unable to see LOV's for same Variable can any one suggest possible solutions Regards Bose
Hi Bose ,
Are you getting any error .Can you post screenshot of issue .
Use the object as prompt in the webi report to check whether the object holds any values are not.
create a new report on same query and check in the set Variables of webi query panel whether LOV's are populating .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All Many Thanks for your replies.. Please find my issue description in more detail 1)Source for my BO Report is BEx query. 2)I have designed OLAP Connection using BICS in IDT tool 2)BEx query has a variable which is mandatory runs fine in Bex anzlyzer 3)As mandatory Variable in BEx query converts into mandatory Prompt it BO I am supposed to enter a value from the list or manually 4)As of now its not allowing me to manually enter value for this prompt not its displaying as List of values coming from BEx Please suggest Regards Bose
Hello Bose
Are you able to see the list of values in the Prompts created as mandatory variable in BEX while running WEBI reports..
I tried it out in 4.0 version and 4.1 SP01 version but i was not able to .. Kindly confirm the same..
Or if any workaround done kindly let me know..
Many thanks
Regards
Akshay
Hi Bose,
Try the below and let me know.
If you use Prompt:
Uncheck "Keep last values selected" in prompt properties and now LOV's would be displayed automatically.
If you use Value(s) from List:
Check "Match Case", "Search in Keys" and "Search in Database" and give * to get list of values.
---Raji. S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Your creating a prompt in universe based on list of values else in query filters. If it's in query filters are you prompting and enabled the option to show lov's?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.