on 03-29-2012 8:01 PM
Hello All,
I have problems in creating Restricted measures in Analytic view.
1. How to restrict a parameter(eg: Comp code) not equal to blank? eg: Comp code <> '#'
I am trying with operator 'Is Not Null', but include check box is not selectable. I cant find not equal operator. how to achieve not equals to and what is values for blank in hana data base. for example in BW-Bex query, blank is restricted with unassigned '#'.
2. how to achieve complex exprssions?
for example i want sales amount based on document type and prod group.
Sales amount, where (Document type = '10' AND prod group <> 'RV') OR (Document type = '11' AND prod group <> 'NV') OR (Document type = '12' AND Prod Group <> 'KR'), How to achieve this kind of expression, is it possible achieve using the combination of both calaculated measures and restricted measures?
Thanks
Hello Pundari,
1. How to restrict a parameter(eg: Comp code) not equal to blank? eg: Comp code <> '#'
I am trying with operator 'Is Not Null', but include check box is not selectable. I cant find not equal operator. how to achieve not equals to and what is values for blank in hana data base. for example in BW-Bex query, blank is restricted with unassigned '#'.
Yes, in this is will not selectable because you are using "Is Not Null" operator and if you will see while selecting "IS Null" which will not able to deselect include. But don't worry you will be able to see the column while previewing the data.
In HANA "?" sign is used for blank.
so for that us can use IS null operator directly.
2. how to achieve complex exprssions?
for example i want sales amount based on document type and prod group.
Sales amount, where (Document type = '10' AND prod group <> 'RV') OR (Document type = '11' AND prod group <> 'NV') OR (Document type = '12' AND Prod Group <> 'KR'), How to achieve this kind of expression, is it possible achieve using the combination of both calaculated measures and restricted measures?
For complex calculation you an go fro calculation view using SQL Scripting. yes, it is possible to achieve calculated measure and restricted measure both.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hellp Pundari,
Please find the below link:
or you can see the my document also.
http://scn.sap.com/docs/DOC-26056
Hope it is useful.
Regards,neha
Hi,
Any ideas on this question?
- Is it possible to add a column/measure using SQL statemnt in Analytic view?
- do you think just to achieve not equal to(<>) operator is Calculation view only the way?
please throw some light..
thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Pundari,
- Is it possible to add a column/measure using SQL statemnt in Analytic view?
Till now it is not available but in near future it will be available that you can create the analytical view using SQL.
- do you think just to achieve not equal to(<>) operator is Calculation view only the way?
No, you can use the calculation measure also with using If Statement what you want to achieve.
Hope it is helpful.
Regards,Neha
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.