Skip to Content
0

Where condition in Analytical View in HANA

May 19, 2017 at 10:11 AM

37

avatar image
Former Member

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

10 |10000 characters needed characters left 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

0
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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers