SAP HANA Cloud - Calculation Views Transparent Fil... - SAP Community
source link: https://community.sap.com/t5/technology-q-a/sap-hana-cloud-calculation-views-transparent-filters-flag/qaq-p/13616261
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
yesterday
Hello gurus
I am facing some issues during the calculation view creation on a BAS project that i should consume through a cap service. This is the aggregation scenario
I have a cube. In the first projection there is another calculation view with a lot of fields. I have to create an aggregation to get a couple of measures. this is the content of Aggregation Node
To perform my aggregation i only need 3 fields CC_DESC, PS_TIPOLOGIA and PS_CONTRATTO_TERMINATO but I would like to use the QU_DESC just as a filter in the where condition. Conceptually, the query should be this one:
select CC_DESC, PS_TIPOLOGIA, PS_CONTRATTO_TERMINATO, sum(PS_ATTIVO_NUM) as total from table where QU_DESC = 'XXX' group by CC_DESC, PS_TIPOLOGIA, PS_CONTRATTO_TERMINATO
to do this, I did set QU_DESC as a Transparent Filter in my aggregation node
but unfortunately QU_DESC field is always in the group by so the measures of my aggregation is giving me a wrong result because it is considering QU_DESC in my group by.
I am in the same condition showed in the official documentation https://learning.sap.com/learning-journeys/develop-data-models-with-sap-hana-cloud/working-with-aggr...
so i am not understanding if it is due to my mistakes or i am facing a bug of Hana DB template project into BAS.
Any ideas?
Thanks in advance
Patty
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK