Skip to Content

Show Empty Data

I hope there is anybody how could help me:

I create a Bex Query on EA Data (Account with same Key Figures) the Query is its based on a BPC Cube. In rows a only the account and in the columns are the key figures. Now not on all Account are values in the cube. I say in Bex Query that they should show Master Data. In Analyzer there are all accounts also the account without values in the cube.

In crystal I only see account with values. I use CR SP3 and integration Kit SP3. I set u201CShowEmptyDatau201D to True but nothing happened.

As second solution I create a formula in Bex with the value 1, take it in the columns but nothing happened in crystal I only see accounts with values in the cube.

I donu2019t know what I could do.

Second I had problems with the general connection of Bex and Crystal.

In the normal way I create a new report with the Sap Integration Kit Menue. What is the different between this way and the way with the crystal function new report and use a new MDX Connection. In booth ways with the same SAP System I get different connection parameters. Which way is the right way.

In addion if i set Show Empty Data to True, i get ask for the query variables and after it show empty data is set to false automaticly

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 17, 2011 at 01:37 AM

    Hello Carsten,

    the option to show also non-empty data is possible in the 4.0 release of SAP BusinessObjects. In the XI 3.1 release it is not really possible.


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ingo,

      but this function didn't worg. If you change the parameter from false to true it didn't work.

      Sometime if i changed the parameter from false to true by the first time after click ok the parameter is false 😊

      After second change to true it will be true but it didnt works.

      The SAP kollegs from the Support know the problem but i didn't get any information yet.

      If you set the parameter in registry it works, but for all reports and that is not that what we need.

      Edited by: Carsten Ziemann on Nov 9, 2011 4:49 PM

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2011 at 08:00 AM

    Is it possible to workaround this restriction by running multiple queries, one with just the list of accounts and one with the accounts and the key figures, and joining them in the report? This is what I do in v3.1 Business Objects WebI reports in similar situations (I think).

    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.