Skip to Content



I have a bex query and created a crystal report on the top of that bex query . now i have to create a variable ( in crystal we call it as a parameter ) to give some inputs based on the calday.

So my question where to create this variable either at bex query designer level or at crystal report ? and what will be impact on the performace if i create the variables at bex query desginer or at crystal report.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2012 at 04:59 PM

    Hi Ravi,

    It is generally recommended that we should create the parameters in BEx Query Designer level. Those prompts will be automatically created in Crystal Reports. Its a very good practise to create the parameters at the backend, so that all the processing and filteration is done at the database level and in Crystal Reports you will get the rectified data depending on the condition you provide.

    BW Query Design Time Considerations

     Clearly determine the output of the reporting requirement of end users.

     Maximize filters and restrictions in the BEx Query.

     Design BEx Queries correctly with limited no of objects.

     Decide on navigational attributes; keep them minimum.

     Create SAP variables rather than using Crystal Reports parameters.

     Create efficient BW aggregates.

     Compress data requests at the BW side regularly.

     Prefer BEx Queries on InfoCube vs MultiProvider vs. Virtual Provider.

     Avoid using large and complex BEx Queries.

    You can also follow this guide for best practices for Crystal Reports and SAP BW

    Best Practices: Crystal Reports with SAP BW

    Hope this would help you 😊.

    - Kuldeep

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.