Changing Quick view depending on cell drop down
-
- Posts: 18
- Joined: Fri Mar 06, 2020 4:48 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: office 365
Re: Changing Quick view depending on cell drop down
concatenating if this is done i will be good to go, last step i think so
-
- MVP
- Posts: 3116
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Changing Quick view depending on cell drop down
Is this the first time you use Excel ?
=TM1RPTVIEW("KT-FPA:}ElementAttributes_" & C14 & ":40173141",0,TM1RPTFMTRNG40173141,TM1RPTFMTIDCOL40173141)
=TM1RPTVIEW("KT-FPA:}ElementAttributes_" & C14 & ":40173141",0,TM1RPTFMTRNG40173141,TM1RPTFMTIDCOL40173141)
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 18
- Joined: Fri Mar 06, 2020 4:48 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: office 365
Re: Changing Quick view depending on cell drop down
No, but the elements are not changing dynamically when i select the dimension, i tried it
-
- 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: Changing Quick view depending on cell drop down
That's probably because your TM1RPTROW formula in cell B17 is not set up properly to pull back all the elements in the dimension. I suggest making it MDX-based and have the MDX statement based on the dimension name in cell B14.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Changing Quick view depending on cell drop down
You need to replace ALL the hardcoded references to the dimension with a reference to your dimension selection.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.