on 02-25-2022 3:42 AM
I have a Time dependent Master data table – DRNUMBER
Recently with new CLASS – ‘1TC’, ECC folks introduced Role information. Earlier with CLASS - ‘1JL’ role information will not be available.
CLASS - 1JL is some what detail level and CLASS - 1TC is aggregated level if same role is performed with continued dates.
Expected output should look like below. How to achieve this in HANA - SQL and if Calculation view Model level is possible how it is…..
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
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.