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

NE function in analytic view

Hi,

I am tryimg to restrict measure KSL On basis of my attribute cost element.....i want KSL Value where cost element is not blnk. i am trying this by creating calculating measure in my view... i had put below formula .... but it doesnt work....

if(cost_elem != ' ' , KSL).

i had think of restricting my attribute cost element NE Blank......then my measure value will come how i wants........ but i am not able to find formula in my restriction or calculation .....either ways....

Please suggest how to use that function.....

Thnksss

Kulwinder

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2012 at 10:04 PM

    Hi Kulwinder,

    I think what you need is a restricted measure in your analytical view. Something similar to the following (Col2 is what could be your cost_elem and Col1 is your measure - KSL):

    Thanks,

    Anooj


    rest_col.jpg (40.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 24, 2012 at 04:20 AM

    Kulwinder,

    RKF should work for your scenario.

    Regards,

    Rama

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 25, 2012 at 06:24 AM

    Hello Kulwinder,

    My thoughts:

    in the SAP HANA the null is represted as "?" symbol.

    in you case Restricted measure can work.

    or other you case use calcualted measure

    if("cost_elem != ?, KSL,0) (correct if syntax)

    by using above expression if cost element does not equal to null then return KSL otherwise return 0.

    Please try this. hope it helps.

    Regards,

    neha

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 27, 2012 at 06:25 AM

    Hi Kulwinder,

    I faced similar issue and did something "equal" but different, try greater than 0 on your formula.

    Also, if your table is replicated from ERP by SLT it should never have null values inside it, of course if it's a result of left join it can be null.

    Regards, Fernando Da Ros

    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.