Update TM1 Contributor Views with TI Process

I recently had a client ask how they could go about updating the latest month for users to see when going into a TM1 Contributor application, without having to update each view individually. Well then…let’s discuss TM1 Contributor views. To update the default element that is used in a title/page dimension of a cube view, you will use the Turbo Integrator function ViewTitleElementSet.   This allows you to update the element chosen for the page, without eliminating the other elements in the subset used that would be available if you were to click on the dropdown for choices.  If you have several views that use the same dimension, you would simply add them to your TI Process.  You can leverage the Parameters tab to simplify things further if you have more than one title/page dimension in views that need to be updated.  The example below takes you through the steps for updating one view, but you can update many views at once in a single process.

This is the syntax of the function:

            ViewTitleElementSet(CubeName, ViewName, DimName, Index);

TM1 Contributor Views w/ TI Process

TM1 Contributor Views w/ TI Process

TM1 Contributor Views w/ TI Process

TM1 Contributor Views w/ TI Process

TM1 Contributor Views w/ TI Process

TM1 Contributor Views w/ TI Process

TM1 defaults all user views in a “persisted state”. This means if the user rearranged the default view, as a “favor” it leaves the view the way one left it. So your users will still have to reset each view (or choose the option to reset all views) in order to see your newly updated view after running your TI Process.

At this time, TM1 does not have the magic Reset button some may want or need for their users. If you feel bold and want to try the existing work around, please click here for the IBM documentation:

Resetting All Persisted Views for an IBM Cognos TM1 Application

Should you have any questions about TM1 Contributor views or any other TM1 questions, feel free to contact us at Sales@LodestarSolutions.com.

Leave a Reply 0 comments