Cube rule not refresh after loaded from the database

[worachart.jaru]

Hi All,

I created process to load formula with ODBC to dimension from database (SQL Server) with TI and set to attribute 'calculation'. After process execute successful, formula updated in attribute of dimension same as the table in database but the value in cube are incorrect.

Example of this situation
1. Setting formula in database table. (Same as Table1 in file "Formula Table.png")
2. Execute process to import element and update attribute to dimension.
3. Check result in cube
4. Change formula in database table. (Same as Table2 in file "Formula Table.png")

Setting formula in database table for update to dimension attribute

Formula Table.png (6.62 KiB) Viewed 2856 times

In step 3, I have checked the rule in region "Region N-Calculation rules:" (Picture 1.png) is not updated from attribute 'calculation'.

Rule in cube (As I understand line 6 to line 68 generate automatically)

Picture 1.png (104.84 KiB) Viewed 2856 times

I try to right click the cube and then choose "Generate Rule" with "Performance modeler" (Picture 2.png) and cube rule is updated same as attribute and data in the cube are correct.

Generate Rule with Performance modeler

Picture 2.png (22.44 KiB) Viewed 2856 times

I need to help from everyone, What is TI function name to "Generate Rule" same as "Performance modeler" tool.

PS. I can't show some code of rule because it's confidential.

Thank you for the best answer from everyone.

[Edward Stuart]

I would advise reading the performance modeler user guide, there are too many additional questions and possibilities that need to be taken into consideration to make an informed and relevant response to your question(s) without writing an essay.

Chapter 8 - Managing Rules and Feeders and more specifically page 73: Automatically generated rules and feeders will get you some of the way

Do you want the Result to calculate via the TI process or do you want to control the Result within TM1? Will the multiplier always remain 100 or will it vary?

It is possible to use TI to generate rules but this is not common in traditional use, check "RuleLoadFromFile" in the Reference guide for more information. There is no outward TI to replicate Generate Rule and this more than likely is not what you want