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.
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?
3) And I dont see to have the option to select all value (*) for each of these Variable. Why?
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?
Please advise, thank you.
Edited by: lynn on Feb 4, 2010 4:34 AM