TM1 Forum

I'm using TM1 10.1 and have created a TM1 Contributor Application. I ran across an issue where a dimension item's picklist based on another dimension item is not populating unless I click commit first.

These are my two rules:

1) Picklist cube rule:
y = S: ('static:Yes:No');

2) Main cube rule
y= S: IF(x = 'Vacancy', CONTINUE,'')

So if the dimension item x is anything other than "Vacancy", dimension item y will not allow data entry and will have no value. If dimension item x is "Vacancy", the picklist of Yes/No will apply for dimension item y.

The problem is that when I enter "Vacancy" for dimension item y, the cell is now unlocked for editing but the picklist does not appear until I click the Commit button.

Is there any way to force the commit without the user having to click the button? Is there something I might be missing in my rules?

Thanks!

jim2011 wrote: Is there any way to force the commit without the user having to click the button? Is there something I might be missing in my rules?

Considering the rule works correctly once the picklist submission is committed, it is safe to say that your rule is working correctly.

What interface are you using within the Contributor Application?
If its websheets there is an option in the web config file to make websheets automatically recalculate when a picklist value is changed, I haven't however tested to see if this holds true for Contributor Application websheets but it would be worth a look.
If you are using cube views directly, do you have automatic calculation selected?

Thanks for the reply. I'm using TM1 Applications (Contributor). Automatic recalculation is on. If I manually click recalculate, the picklist still isn't populated. It's only once I click the commit button. TM1 Applications uses the cube views but I think the way it works it that it essentially acts as a sandbox. Therefore, until commit is clicked, the picklist rule is not taking it into account. I should mention that the actual syntax of the rule is using a cube reference for the dependent dimension item instead of just using brackets.

Just in case anyone else ran into the same issue I did. The problem wasn't committing data, it was simply a recalculate that was necessary. Here is IBM's solution:

Set RecalcOnPicklistChange in tm1web_config.xml file to enable recalculation when a value in a picklist is change.

RecalcOnPicklistChange - Specifies whether the default recalculation behavior will be overridden when changing the value of a picklist.
If set to true, a recalculation will be triggered when a value in a picklist is changed.
If set to false, a recalculation will not be triggered when a value in a picklist is changed.

The configuration parameters for IBM Cognos TM1 Web are stored in the tm1web_config.xml file.

The tm1web_config.xml file is located in the following location: <TM1 install location>\webapps\tm1web\WEB-INF\configuration\

http://www-01.ibm.com/support/docview.w ... wg21653590