Dynamic Cascading parameters on BEX query

[Former Member]

Can we create dynamic cascading parameters in crystal with SAP BEX query as a source? Can any one explain the steps to achieve this?

Thanks

Saagar

[abhilash_kumar]

Hi Saagar,

Dynamic Cascading parameter are NOT supported with Crystal Reports and SAP datasources.

You would need to create the parameters on the SAP side using the BEx designer. On the BEx side, these are actually referred to as variables I guess. So, once you create variables in the BEx query, Crystal Reports treats these variables as Parameters.

The list is automatically created, however it is worth noting that list will always be Static in the Crystal Reports designer.

This list will become dynamic only when the report is published using the SAP BW publisher AND viewed in InfoView.

Even if you were to create dynamic cascading parameters in the CR designer, the way you would normally do when the source is RDMS, the parameters would still not show up in InfoView. The list will infact be empty.

So, you would need to create the variables in the BEx query to see the list of values.

-Abhilash

[Former Member]

Abhilash,

Thanks for the reply.

you mean only way to achieve dynamic cascading: (for ex like Country, State and City parameters)

Have these variables created in BEX query and then just leave them as static. Then the report has to be published to BW and then to BOE? Right?

Thanks

Saagar

[abhilash_kumar]

Hi Saagar,

Yes, that is correct.

-Abhilash

[Former Member]

Abhilash,

I am sorry, I could not get that to work.

My Bex query has variables for Country, state and City. When I connected to the query from my crystal report, I could see the parameters came from BEX variables and they are static. I maintained selection formulas over the parameters. when I run the report I could not see the cascading list of values in crystal report.

I saved the report to BW ( save as ),

I saved the report again to BOE

I ran the report in infoview but I could not see the cascading List of values.

Please help me in this regard to implement the dynamic cascading from BEX queries.

Thanks in advance

Saagar

[abhilash_kumar]

Well, the parameters would never be 'cascading' in CR or InfoView.

They would be dynamic in InfoView though once the report is published through the BW publisher.

Unfortunately, that's how it is at this point in time!

-Abhilash

[Former Member]

Thanks Abhilash.

Still facing these issues for dynamic parameters.

When I connected to BEX query from crytal report I could see the parameters already created (coming from BEX variables). They are static in crystal report and they do have the list of values. But when I refresh and select the parameter values, data is not being filtered but showing everything ( in crystal reporta).

Do I have to set selection formulas( I even tried but not working).

Also please explain hot to save to BW and then BO, in detail steps. I appreciate your help.

Thanks

SAAGAR

[abhilash_kumar]

Hi Saagar,

Did you try executing the query in the BEx Analyzer? Does it filter the records there?

And regarding the BW publisher, please refer to this Wiki:

http://wiki.sdn.sap.com/wiki/display/BOBJ/ConfiguringBWPublisherServiceforCrystalReports+2008

-Abhilash

[Former Member]

Hi Abhilash,

Thanks for the quick reply.

Bex Analyzer is filtering the records.

And FYI, I didn't maintain the selection formula. Do I have to?

Thanks

SAAGAR

[abhilash_kumar]

Hi Saagar,

No, you should not need the Record Selection formula as the parameter should filter the records for you. Are these heirarchy variables or just three separate variables that create three parameters when brought over to Crystal?

-Abhilash

[Former Member]

Abhilash,

Yes these are Hierarchy Variables. Thanks.

SAAGAR

[Former Member]

Hello,

Is dynamic cascading prompting supporeted in Crystal Report for Enterprise with SAP sources? We have created variables in our BEx queries, but do they need to form a hierarchy in order to be able to achieve the "cascading effect"? There are limitations when importing BEx hierarchies to Crystal Report, so trying to find out what the optimal data model/report design should be....

Thank you so much for help,

Victoria