Skip to Content
avatar image
Former Member

Where condition in Analytical View in HANA

Hi All,

we have a requirement to achieve

Sales 01.02.03 Category Management Store Category Details Fact
Sale Event Dim Revenue in GC
Sale Event SR Key
Sale Event Description Sum(Revenue in GC)
Where
Sale Event Description =
Thanks giving
OR Christmas
OR New Year

we have to SUM(revenue in GC ) with where condition.

Pls let us know how to achieve this

Regards,

Saroja

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi ,

    I have tried to implement IF condition but didn't worked out and also I stucked how to write WHERE condition in IF statement.

    Pls give me a workaroung ho to achieve this.

    Thnaks,

    Saroja

  • Former Member

    Hi All,

    I have tried the above formulae with CASE & MATCH statement , now i am able to receive data but Only for one sales event ie.

    CASE(MATCH("SALES_EVT",'Christmas'), 'Newyear')

    Using this I am able to get data only for New year. It should come either it is Christmas or New year.

    Pls help me how to correct the statement inorder to get both the events data.

    Regards,

    Saroja

  • Get RSS Feed

0 Answers