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

Measures - some basic questions

Hey Experts,

I have a BEx Query that has a measure which includes SUMCT. This application isnt avalible to make a Universe.

So in my opinion the only solution is to create the measure in universe designer.

After I created a new measure I noticed that the SQL Editor isnt on hand. Is the editor not avalible because I work with SAP elements that have predifined table structures?

In the Select section I made a reference on my measure. This works fine.

<EXPRESSION>(@Select(Measure\Name)</EXPRESSION>

But when I want to make a calculation I get errors that the definition isnt correct.

Do somebody know how I can make for e.g. measure / sum(measure) *100 or sth. like that?

Regards

Jan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 09, 2009 at 08:53 AM

    Hi Jan,

    The reason why the SQL option is not available is because BW/OLAP universes uses MDX to communicate with BW and not SQL.

    I would probably do that kind of calculation directly in the WebI document - you have a lot of functions in there and you can easily replicate the SUMCT function there. Ýou can also do it using an MDX statement, but it quickly gets a little complicated. Check this document to see examples of MDX statements/definitions in an OLAP universe. Please note that BW does not support all MDX statements:

    OLAP Universes - Best practise

    Hth.,

    Jacob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2009 at 10:57 AM

    Hi,

    First of all, the expression you wrote is incorrect, here is the correct syntax:

    <EXPRESSION>@Select(Class\Object)</EXPRESSION>

    Then to write an MDX expression that represents the percentage of a member over its parent, the syntax is:

    <EXPRESSION>(@Select(Class\Object), [Dimension].Currentmember) / (@Select(Class\Object), [Dimension].Parent) * 100</EXPRESSION>

    Regards,

    Didier

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2009 at 12:12 PM

    Thanks, for your answers.

    The structure of Universe/WebI is now much clearer 😊

    I tested the options in WebI. The solutions are very nice. Thx a lot.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello, I need you help... I tried to replicate SUMCT function in Web Intelligence but I could not have the right results.

      In Query Designer SUMCT function look like:

      Key figures: Counter and Client AVG

      Formula:

      SUMCT (counter / Client AVG)

      How Can I replicate this using Web Intelligence fuctions?

      Thanks in advance!

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.