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

Create new dimension on top of SAP BW data

Hi expert,

I'm having a problem to create a new dimension on top on SAP BW data. I have a dimension details object called 'L01 G/L Account Key'. When I drag this object to the result object in the web intelligence, it display full data like '1000/30100'. How can I trim the data so it shows '30100'?.Is there any formula that support in universe?

I don't want to do the formula inside the web intelligence report because I want to use this dimension to other reports as well.

Please expert....help me!

Thanks & Regards,

Syahida-

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2010 at 09:06 AM

    Hi,

    SAP BW MDX does not support calculations that return string or date: this is a limitation of SAP BW OLAP engine.

    By the way I found exceptions that satisfy your requirement.

    For instance you can manipulate a substring of a dimension only with NAME and UNIQUENAME attributes.

    Example, you can use these expressions:

    <EXPRESSION>right([OD_COUNTRY].currentmember.name, 4)</EXPRESSION>
    <EXPRESSION>right([OD_COUNTRY].currentmember.uniquename, 4)</EXPRESSION>
    <EXPRESSION>left([OD_COUNTRY].currentmember.name, 4)</EXPRESSION>
    <EXPRESSION>left([OD_COUNTRY].currentmember.uniquename, 4)</EXPRESSION>
    <EXPRESSION>mid([OD_COUNTRY].currentmember.uniquename, 2,4)</EXPRESSION>

    Regards

    Didier

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      You can only use currentmember with a hierarchy or a characteristic that is the default hierarchy.

      You can't use a hierarchy attribute or a level.

      So assuming that 0GL_ACCOUNT HTP INCOME STATEMENT is the definition of your characteristic / hierarchy, the syntax could be:

      right( [0GL_ACCOUNT HTP INCOME STATEMENT].currentmember.NAME, 4)

      or

      right( [0GL_ACCOUNT HTP INCOME STATEMENT].currentmember.UNIQUENAME, 4)

      Maybe the solution I provide is not relevant in your case because of SAP BW limitations.

      By the way, as I said SAP BW calculations cannot return string or numeric results (this is only possible using User Exit written in ABAP).

      Didier

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2010 at 11:01 AM

    Thanks guru...now I know there has a limitation on BW itself and I cannot do anything about it. But if anybody know about it..most welcome to let me know..thanks

    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.