on 04-09-2019 4:58 PM
Hello everyone,
We have created a count distint in the last node of our calculated HANA view.
The target of the HANA view is a composite provider and then a query.
The counter is the field zdpm. It counts the number of the Company comercial activities.
Besides, the mentioned couter is restricted by VISIT (type of activity) in the query. This is the field ZDPMVISITA_RES.
Then we execute the query, (displaying both fields)
After that, we eliminate the restricted field (ZDPMVISITA_RES).
We find that the field zdpm, changes in the moment that we don´t display the restricted field.
This difference happens becouse the restricted field is adding its dimension (VISIT) to the counter zdpm.
We have tried different solutions, including a transparent filter in the HANA view, and nothing changed.
Any idea to help us with this issue?
Thank you very much!
Kind regards.
Could you build the different counters on two different views (with a composite on top) ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cristian,
Can't you count at the query level (on the BEX side)?
Regards,
Frederic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.