Hi,
Weu2019re on BI 7, Crystal Report 2008 V1 and SAP Integration Kit 3.1.
Query is created in BEx Query Designer, with Variable. In Crystal Report, I have set to use the MDX driver u2013 recommended by SAP.
I have created the Crystal Report on top of this BW Query. When I click on Preview, I have Variable screen appeared. I have 5 Variables on the screen:
1) I noticed that we MUST enter the value into the Variable (all of them) else I got nothing to display on the screen. Why? The Variable is configured as u201COptionalu201D in the BEx Query.
>> in case the variable is optional then you will have a "set to null" checkbox in Crystal Reports for the prompt
2) I have entered the specific value for the Varible i.e. Product = A001, but I still have other Product being display on the screen. Why?
>> did you actually add the value to the list of values ?
3) And I dont see to have the option to select all value (*) for each of these Variable. Why?
>> in case the prompt is optional using the option "set to null" means you getting all values because you not setting a value.
4) In Crystal Report ->Field Explorer ->Parameters, I can see that the Variables defined in BEx Query is there. What can we do with these Paramaters?
>> not sure what you mean here.
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.