SAP HANA Cloud - Calculation Views Transparent Filters flag

[patty_1982]

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

KRs

Patty

[patty_1982 · Accepted solution]

I solved the issue. It was due to Graphical Editor. If I set the Transparent Filters flag on the first projection node it works correctly instead to set it on Aggregation Node