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,
Count the number of Accounts for each agency
-
- Posts: 128
- Joined: Tue May 23, 2017 12:45 pm
- OLAP Product: Tm1
- Version: 9.5
- Excel Version: 2010
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Count the number of Accounts for each 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.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 .
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Count the number of Accounts for each agency
Please go through the MDX primer.doc for detail explaination of MDX functions with context to TM1. Thanks
- Attachments
-
- MDX_Primer.doc
- (669 KiB) Downloaded 220 times
"You Never Fail Until You Stop Trying......"