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

Data not retrieved in WebI with Measures calculated in Universe on SAPBW

Hi,

Pls share if such error is faced anywhere else and if there is any solution to this.

Environment: SAP BI 7.01 and SAP BO XI 3.1 SP2 FP2.9

Universe has calculated measures.

Problem: No data is fetched by WebI when both direct measures (straight from BEx) and calculated measures are used.

However, data is correctly retrieved if either only the direct measures are used or calculated measures are used.

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 06:55 PM

    The calculations are very simple as below

    <EXPRESSION>@Select(Key Figures\Gross Sales)+@Select(Key Figures\Returns)<\EXPRESSION>

    This calculation needs to be used in more than 20 Reports. Hence, the thought of having the calculation in the universe.

    I am trying to get a confirmation if the expression is known to have problems with SAP BW?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I can retrieve data in the report if I drag these individual objects.

      Is there a difference in behaviour in framing MDX when both calculated and non-calculated Key figures are used in WebI.

      I have been able to drag out the error in the log file. It suggests insufficient space to extend the internal table.

      However, with non-calculated KFs it can fetch more records and BW temp table space is in auto extension mode.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 06:32 PM

    Can you see data @BEx for both KF & CKF??

    Are CKF also based on same KF what you are trying to use both at same time??

    Gracias...!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 06:40 PM

    The calculation is done in the universe layer. The base KFs are returning data when selected in the WebI. Also if I only select the CKFs in WebI I get data. However, when I select CKFs along with other KFs I don't get data.

    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.