Saturday 23 March 2013
Thursday 7 March 2013
TM1 Tip - Feeders
For debugging feeders,
1. Go to detail level of one specific example.
2. If the rule is very long, make sure there is no TYPO!!! (This is very important since many errors come from this kind of issue.)
3. Use "Trace Calculation" to make sure calculation is right.
4. Use "Check Feeders" to verify it is fed or not.
5. From source cells, use "Trace Feeders" to check if it is feeding right target cells or not.
6. You can put some specific feeder ( e.g. one specific cell) to feed target cells and check.
7. Usually, the rules and feeders will take effect immediately after saving to servers. ( no need to restart server and run refreshing feeder process.)
8. To feed multiple cells at one time, you can feed their consolidate cells directly.
9. You need to find some key drivers to make the feeders fire, especially for conditional feeders. In other words, Don't always obey the formulas. E.g. >>>
10. Turn off Zero Suppression when using one small example and you will find target values are there with improper feeding.
11. The intermediate values coming from other fomulas can be used as feeders.
12. It is recommended to use CubeProcessFeeders(CubeName) function to proccess feeders rather than restarting server each time.
13. Be careful about saving rules to server as once it starts rule attaching, you can't stop it until server crashed by using the memory up. Thus, you can save data first before saving any complex rule.
1. Go to detail level of one specific example.
2. If the rule is very long, make sure there is no TYPO!!! (This is very important since many errors come from this kind of issue.)
3. Use "Trace Calculation" to make sure calculation is right.
4. Use "Check Feeders" to verify it is fed or not.
5. From source cells, use "Trace Feeders" to check if it is feeding right target cells or not.
6. You can put some specific feeder ( e.g. one specific cell) to feed target cells and check.
7. Usually, the rules and feeders will take effect immediately after saving to servers. ( no need to restart server and run refreshing feeder process.)
8. To feed multiple cells at one time, you can feed their consolidate cells directly.
9. You need to find some key drivers to make the feeders fire, especially for conditional feeders. In other words, Don't always obey the formulas. E.g. >>>
10. Turn off Zero Suppression when using one small example and you will find target values are there with improper feeding.
11. The intermediate values coming from other fomulas can be used as feeders.
12. It is recommended to use CubeProcessFeeders(CubeName) function to proccess feeders rather than restarting server each time.
13. Be careful about saving rules to server as once it starts rule attaching, you can't stop it until server crashed by using the memory up. Thus, you can save data first before saving any complex rule.
Sunday 3 March 2013
Useful TM1 language highlighter for Notepad ++
I worte it and it supports all languages up to 9.5.2 in TM1 (Process scripts, rules etc.)
You can use latest Notepad++ to import this UDL xml file into it and it would be there in Language menu for you to select and highlight.
In Notepad ++, View -> User Defined Dialogue... -> Import
From >>> , you can find the attachment.
You can use latest Notepad++ to import this UDL xml file into it and it would be there in Language menu for you to select and highlight.
In Notepad ++, View -> User Defined Dialogue... -> Import
From >>> , you can find the attachment.
Subscribe to:
Posts (Atom)