Skip to Content
author's profile photo Former Member
Former Member

Display and Retrieve only Overall Results in Bex Query

Dear SAP BI members,

My project is using a BO Dashboard for reporting and source for it is BW Bex Query. However, the structure of query is such that Calendar Year/Week is present in columns which is defined with offset to display last 12 week data. And there are 5 keyfigures apart from 1 characteristic in row. The overall result row is displayed at top and calculated as "Counter of all values". The overall output of query is such that it generates lot of cells and gives error - " Result set too large (606762 cells); data retrieval restricted by configuration (maximum = 500000 cells) ". Unfortunately I cannot change the BO part and I have to solve this problem in BW query only. Another point to be noted here is that BO is using only overall result row which is configured to display at top of the report. So basically BO is interested only in top 3 rows (Calweek, keyfigure description, overall result) and rest all data is irrelevant for it. So I now need to find out a way by which I will display only overall results for the query and somehow hide rest of the row/column data. I also tried option of "Calculate single value As - Hide" for all keyfigures but it is still generating same number of empty cells and giving the same above error. So basically this option did not work for me. Is there any other way to solve this problem? Your help is very appreciated. Thanks.

-Abhijit

SDN.PNG (10.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2013 at 06:54 AM

    Hi,

    You can simply achieve this by creating a new formula which calculates overall result of location codes and hide the Location code display.

    formula: SUMGT 'LocationCode'.

    Br,

    H

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 26, 2013 at 12:03 PM

    This may give you some idea http://scn.sap.com/docs/DOC-35444

    I don't think your query output size is causing the issue. I mean even after not showing the lower three rows. It is giving you the same error.

    What is the query read mode used?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 27, 2013 at 03:59 PM

    Hi Abhijit,

    when you define the Bex query, you defining a view. so in case your BEx query contains elements in the rows, then those will also be transferred to the Dashboards client.

    To me it looks like you have a BEx query which does return a large amount of cells, but you only want to have one row.

    if that is the case, the easiest way to solve the problem is to change the BEx query to what you actually need for the dashboard, which is only the top row.

    regards

    Ingo Hilgefort, SAP

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ingo,

      Thank you for replying in this thread. I forgot to mention one point in my original post. The result row of query is actually calculating result based on count of values of characteristic in row. So if 5 location code returns value, overall result should be 5. This is the reason I am forced to have characteristic in row and thus it is producing huge output based on data. So what I am trying to achieve here is somehow without changing query I should be able to display only result row in query output and not the actual data. But unfortunately I have not found any solution for this.

      Regards

      Abhijit

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.