on 08-16-2016 1:08 PM
I have a webi report with Bex query prompt calendar year..I need to run the report for 5 years.. so I created a date prompt greater than or equal to and less than or equal to.. when I select 2016 in Bex query prompt results are accurate..when I select date 1/1/2016 and till date in newly created prompts (without selecting Bex calendar year prompt).. all objects in the table values are shown zeroes..
do you have data in BW for the date object for 2016?
Year prompt is mandatory in BEx or optional?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
are you getting data when you enter Year value 2016 and date prompt (1/1/16..8/16/16).
if you are getting values like (1/1/16..8/16/16) in the report then what is coming blank?
if you just enter the Year 2016 then are you getting data in the date object?
try with between operator instead of Greater then or less then operator in date prompt
What is the Bex Restricted variable format and data type that you are using as prompt?
Regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.