Count the number of children and store it as an attribute for the parent
Posted: Wed Feb 14, 2018 3:15 pm
Hi,
I have a cube with customer dimension which has an hierarchy like
Region ->Agency - > Rep-> Customer
Now the cube has measures based on the customer loaded like recent activity , balances, sales etc .
Users wants to know the count of number of customers for each region and each agency .
Now I plan to store the count as an attribute value on the region and agency level .
How would I go about going this count and storing as an attribute.
Do I have two TI process with one have all regions as source and Iterate them and counts its customers and other Ti with Agency as subset and iterate all agencies and find the count of children .
How to do I get the number of children of a region , meaning the customers which is 3 rd level .
Thanks,
I have a cube with customer dimension which has an hierarchy like
Region ->Agency - > Rep-> Customer
Now the cube has measures based on the customer loaded like recent activity , balances, sales etc .
Users wants to know the count of number of customers for each region and each agency .
Now I plan to store the count as an attribute value on the region and agency level .
How would I go about going this count and storing as an attribute.
Do I have two TI process with one have all regions as source and Iterate them and counts its customers and other Ti with Agency as subset and iterate all agencies and find the count of children .
How to do I get the number of children of a region , meaning the customers which is 3 rd level .
Thanks,