on 10-17-2017 8:11 AM
Hi all,
following is my issue
As an example,
(as an example EMPLOYEE_TYPE 1 has three Employees. they are Mirana, Venura and Kithsiri and it shows max value as 50000.00 but you can see result is 150000.00 which is a total of all three Employes)
But, Expected output which i have manually added as column name Expected Output . this should be shown as max value for all the EMPLOYEE_TYPE and Total Result should be as 125000.00 which is a addition of (50000.00 + 30000.00 + 45000.00 = 125000.00)
what should be the way to answer this?
Thanks
Mirana
Hi Mirana,
You can solve using following steps:
1. Create a scripted calculation view similar to your existing view but without employee name. In your SQL script, use following logic:
SELECT MAX (<<Your key figure>>), <<ALL other columns except employee>> from XXX group by employee type.
2. Join this scripted calculation view with your existing calculation view on employee type and read the measure from scripted calculation view.
Thanks,
Anup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anup,
that's how i did but with graphical view.
column SALARY_max (screen 02:please check attached file) shows expected result but Total result is wrong as per our requirement, which produce Total Result as 50000.00 .
it should be sum of all MAX values which is 50000+30000+45000 = 125000
i have attached screens for your reference
screen 01
screen 02
Thanks
Mirana
Hi Mirana,
there is no way to do this in the calculation view, you only can do this in your Frontend e.g. the Analysis for office with a separate calculation.
Normally, there is a functionality in AoF in tab "Analysis -> Totals -> Calculate Totals as", but for the use with Hana views unfortunately
this functionality is not active.
Best Regards
Thorsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.