Hierarchy

[samkp]

Cost Center Hierarchy to be as below

RegionName(Attrs of LeafLevel)->DistrictName(Attrs of LeafLevel)->Leaf Level CostCenters

For example , Please check the below screenshots... leaf elements have the RegionName and District Name Attr Names. if Elements have different Attribute names under Hierarchy , we need to consider the common attribute name which max elements have. in the below examplen it should be R01-MARTIN,ROBERTJ -> R01D01-UNASSIGNED->ALL LEAF ELEMENTS UNDER THAT.

Any help in logic is much appreciated.

[deepakjain2020]

Hi Sam,

Are you looking for Hierarchy creation based on all elements listed.

RegionName(Attrs of LeafLevel)->DistrictName(Attrs of LeafLevel)->Leaf Level CostCenters

For example , Please check the below screenshots... leaf elements have the RegionName and District Name Attr Names. if Elements have different Attribute names under Hierarchy , we need to consider the common attribute name which max elements have. in the below examplen it should be R01-MARTIN,ROBERTJ -> R01D01-UNASSIGNED->ALL LEAF ELEMENTS UNDER THAT.

Or you need only the one which have max elements?

You need leaf level elements to be under the consolidated element "RegionName(Attrs of LeafLevel)->DistrictName(Attrs of LeafLevel)" separately or all under the one which have maximum elements?

Regards,
Deepak Jain

[samkp]

It is for max elements.

[deepakjain2020]

Now as you said you need Attributes to be as consolidated which are having the Maximum Number of same attributes.
One more thing now, you need only respective elements to be under that consolidated or all the elements which are existing in dimension?

Regards,
Deepak Jain

[samkp]

All the elements existing in the dimension

[deepakjain2020]

Hey Sam,

You can get the max count for combination of RegionName(Attrs of LeafLevel)->DistrictName(Attrs of LeafLevel) based on all the elements. To get that I would try using IF condition.
Store them in some dummy variables.

Next perform which of the combination is having a greater value. I am not sure how you are planning to showcase when there is a same value for two combinations.
Once you have your combination with greatest value insert it into your dimension and then go on adding your leaf level elements under that consolidated element.

I would have tried at my end and shared the code, but it can be done on weekend from my side.

Regards,
Deepak Jain

[samkp]

Thanks that would be greatful.

[BariAbdul]

Hi Deepak,Any updates Please.Thanks

[deepakjain2020]

Hi Abdul,

I requested Sam for sample file, so that I would start up. but there was no response.

Anyway will create one sample based on screenshot shared on this weekend.

Regards,
Deepak Jain