I have a pax excel which has some fields for entry by user and there is an action button which calls a TI ,
In the TI I recive the paramaters with data source as none and then do some validations , now if the validartions are successful I need to add the parameter value to a dimension ,
Since my meta data and data is disabled as my source is empty , how would i enable them here , all i am doing is sending data from my pax sheet via action button .
Basic question on meta data and data
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Basic question on meta data and data
Just do you DimensionElementInsert in the PROLOG or EPILOG tabs after your validation.
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Basic question on meta data and data
Not in Epilog tab, use the Prolog tab.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Basic question on meta data and data
Thanks for setting me straight Wim!
Yep, use DimensionElementInsertDirect if trying to add the element in the EPILOG tab.
Yep, use DimensionElementInsertDirect if trying to add the element in the EPILOG tab.