Page 1 of 1

Count the number of Accounts for each agency

Posted: Fri Oct 20, 2017 7:22 pm
by Analytics123
Hi ,

I have a hierrachy like Region, Agency,Subregion, Rep and accounts .

The user wants the count of number of accounts under each agency .

Is there a TI function I can use which will take the agency as input and give me the count of accounts under that agency .


Thanks,

Re: Count the number of Accounts for each agency

Posted: Fri Oct 20, 2017 7:32 pm
by tomok
Analytics123 wrote: Fri Oct 20, 2017 7:22 pm Is there a TI function I can use which will take the agency as input and give me the count of accounts under that agency .
No, but you can always write your own. If it was me I would have a TI that takes the agency as an input, builds an MDX-based subset on the dimension that does a TM1DRILLDOWNMEMBER on that input agency and then filters to only 0 level. Then you can use SUBSETGETSIZE on that subset. That will give you the number of accounts under the agency.

Re: Count the number of Accounts for each agency

Posted: Sat Oct 21, 2017 3:48 am
by BariAbdul
Please go through the MDX primer.doc for detail explaination of MDX functions with context to TM1. Thanks