Basic question on meta data and data

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Basic question on meta data and data

Post by manu0521 »

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 .
ascheevel
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

Post by ascheevel »

Just do you DimensionElementInsert in the PROLOG or EPILOG tabs after your validation.
Wim Gielis
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

Post by Wim Gielis »

ascheevel wrote: Mon Mar 30, 2020 2:35 pm Just do you DimensionElementInsert in the PROLOG or EPILOG tabs after your validation.
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
ascheevel
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

Post by ascheevel »

Thanks for setting me straight Wim!

Yep, use DimensionElementInsertDirect if trying to add the element in the EPILOG tab.
Post Reply