Skip to Content

mdx in universe

Hi all,

I have created on object on top of BW universe where I want to count number of documents, its output is number. I am using following expression to evauluate number of documents but it is giving me error when I try to use this object in webi.

Syntax is:

<EXPRESSION>COUNT(@Select(BW: Document Line No\L01 BW: Document Line No))</EXPRESSION>

and error it gave is

Please suggest.

regards,

waqar

pastedImage_0.png (11.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 17, 2012 at 04:19 PM

    Hi

    What is the version of BO you are using ?

    If you are using BO 3.1 collect the sofa logs and the mdx statement as per SAP notes herewith

    1260004 - How is SOFA / MDA logging activated in Business Objects XI 3.1 on Windows

    1380517 - How to Capture Sofa Log in 64 bit Windows

    1660002 - How to activate sofa logs in a Unix Environment in BOE XI 3.1?

    apply the one related to the BO O/S you are using.

    Run then the mdx statement in transaction mdxtest.  If it errors with the same error there is a problem with BW and I suggest to open a ticket with BW support.

    Regards

    F.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ray yan

      Hi Waqar

      I have to say that if you use BO XI 3.1 without any Service Pack considering that we are now on SP5 I strongly recommend to test with the latest Service pack.

      I assume that the expression parsed ok when you check the universe integrity and that the problem is in webi when using the object.  The issue might be linked to a product defect hence the test with the latest service pack.

      If you still have the issue with SP5 then do the test in mdxtest to see if the issue comes from BW or from BO. 

      Regards

      F.

  • avatar image
    Former Member
    Sep 21, 2012 at 08:18 AM

    Hi Waqar,

    Unfortunately the XML you can actually use in a universe on top of BW is very limited.

    This is because you are not talking native to an OLAP database, but to the Bex application engine.

    You will want to create count you want in the Bex query as a key figure and not coded in the XML.

    That way also Bex has the option to do this calculation in the most performant way.

    Hope this helps,

    Marianne

    Add comment
    10|10000 characters needed characters exceeded