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

10|10000 characters needed characters exceeded

### Related questions

• 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)
10|10000 characters needed characters exceeded
• Former Member Former Member

Yeah you can't do it within your formula. You have to do the "update" in the SQL editor and also ensure any new data this inserted into the underlying table gets inserted as NULL values instead of space/blank.

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

Kulwinder,

RKF should work for your scenario.

Regards,

Rama

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

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