Hi
Is it possible to include a Attribute as a column in Active Form and include that in the rebuild? Say you want to update the attribute of the Dimension, so you include that in the Active form.
regards,
Abi
Active Form
-
- MVP
- Posts: 2836
- 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: Active Form
Anything you put in the top row of an Active Form (assuming that it's still inside the column range as defined in TM1RPTFMTIDCOL) will get "rebuilt", i.e., copied down as the form is redrawn. This includes values, Excel formulas, and TM1 formulas.
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Active Form
Thanks. Is that means, say we can use DBRA in a column and as long it's within the range of active form it will be updated for all the rows of the rebuild?
-
- MVP
- Posts: 3241
- 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: Active Form
Yes
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
-
- Posts: 57
- Joined: Fri Sep 17, 2010 11:57 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Active Form
Thanks. Also I have loaded the Active form in the TM1 web as websheets. Now I did some changes to the data and saved using the button "Data Review
changes". Now I want to generate a exception report of the all the changes I did. How can I do this?
Should I try to read from log file?
changes". Now I want to generate a exception report of the all the changes I did. How can I do this?
Should I try to read from log file?