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

getting error when i add measure in web i report

Hi experts,

I created an expression in universe and then exported to CMC. if i use this measure in webi report i am getting an MDX query error.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 16, 2011 at 07:47 PM

    Hi Rahul,

    Can you please provide some details as in whats the error message and what exactly have you done in CMC?

    Thx

    Rajnish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2011 at 06:51 AM

    Hi rajinish,

    we have complex calculations in webi report. now i would like to move all the calculations at universe level. for that i created one calculated key figure and moved in web i report i didn't get any error but if i am trying to add one more calcuted key then i am getting error..

    webi calculation

    -


    =Count([L01 Maintenance Order Key] Where([L01 Maintenance Order Order type (Key)]="PM10"))

    now i calculated above formula in universe like below

    SELECT BOX

    -


    <EXPRESSION>

    @Select(Maintenance Order\L01 Maintenance Order Key)

    </EXPRESSION>

    WHERE BOX

    -


    L01 Maintenance Order Order type (Key)="PM10"

    PLEASE GUIDE ME IF I AM MISSING ANYTHING..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rahul,

      I think you are getting this error because of the definition of the WHERE clause as you are defining the condition normally.

      In the where clause also you have to use MDX syntax as you have used in the SELECT clause Eg. may be you need to use <FILTER></FILTER> tags or else create RKF's in the universe.

      Regards,

      Rohit

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.