Crystal Report on BW Query

31 Views

Hello,

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