Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I would like to display only the highest level of hierarchy in my output.
Emp Master:
This has the employee number and the licenses they own
License:
This contains the License Master and the Higherarchy level.
Required Output:
This is the output I am looking for.Though Employee can own many Licensces I need only the Highest higherarchy details.
Is this possible by set analysis?
Or do we need to do only in the datamodel
Need youe help on this
Thanks & Regards
Jeba
Sorry Jeba,
I don't know if I have understood..
Can you try with this?
aggr(min(Hierarchy), [Emp Code])
Hi Team,
Could you please help me
Regards
Jeba
Hello!
I see that if you create a straigth table with Emp Code as dimension, you can use just min(Hierachy) as expression: the output of this is like the one you want.
Let me know
Hi Elena,
It almost worked except if I add one more dimension to it then it is not only fetching min but it fetches all values
Is there any quick fix you can offer me?
Regards
Jeba
Can you upload your excel with the new dimension?
In this way it's more simple for us!
Thanks!
Hi Elena,
Please find the same.
I have highlighted the column in yellow for your kind reference
Regards
Jeba
Sorry Jeba,
I don't know if I have understood..
Can you try with this?
aggr(min(Hierarchy), [Emp Code])
Hi Elena,
It worked and you are Great.
Thanks & Regards
Jeba
WAIT!!!!
11113 has a problem.. hasn't it??
Is it ok for you? I see: Licence name 2,5- instead of 2, even if Hierarchy is ok.
Hi Elena,
Thanks for highlighting this.
Actually it was a typo error from my dymmay data.
My actual scanario works perfect by your code and thanks a lot for that
Thanks & Regards
Jeba