TM1 Forum

hmm, although thinking about it, you'd probably have to set all the TI processes use the active sandbox for dev in order to effectively test any config changes - SetUseActiveSandboxProperty(1); Could probably do this fairly easily using a cmd script though. Is it getting to be more trouble than it's...

Has anyone tried using sandboxes to help with dev to prod migration of data changes? I tried it our this morning and it seems to work quite well. It would also solve quite a few issues caused by forgetting about some configuration changes done within cubes in a dev environment which don't make it to...

In this situation I prefer to use a separate control cube to define the valid combinations of product/shop and any other dimension which is relevant. I think this is a good approach for 2 reasons. First, a valid combination of product/shop is possibly relevant to more than one cube, and I don't want...

Another thing that was the case in 10.2, not sure since, is that if you have "undefvals" in your rule it tends to return blank vs zero in excel. For cells which have had a number, but it was then deleted, it will return 0. It then plays all kinds of havoc with zero suppression. Up to 10.2,...

Based on your description of the problem, it's likely to be either rules taking too long to calculate, or feeders taking to long to process on the write side. You can easily tell which it is by finding out from the log file if it is the export sub process or the import sub process which is taking th...

1, ['GLValue'] => could be changed to ['GLValue', 'AllCountries', 'AllProfitCenters'] This would mean feeding from a consolidation. But since I specify the targets it should work. This wouldn't really fix overfeeding since Im still feeding as many cells. But maybe there is a performance gain to not...

I think there's an argument for readability too. If you're trying to debug rules and feeders, the natural place to look for the feeder is in the components of the corresponding rule. If you feed from components that are not part of the rule, It gets hard to manage pretty quickly, particularly if you...

I'm pretty sure it's not feeder related. If it was, you would more likely see the opposite behaviour, in that including a non-zero number in the view would be slower than a view containing only zeros, as having a number will almost always result in more feeders, therefore more calculations and there...

Hi,

I did look at this but the documentation states that this behaviour is on by default, so I thought it wouldn't help.

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

I'll give it a go anyhow incase the doc is wrong (surely not!).

Thanks.

Hi, Wondering if anyone has come across a solution to what seems to be a simple issue. We have some cells that have at some point in time contained string data. They are currently being blanked out by a rule dependent on a picklist in an adjoining cell. The problem is that the presence of a rule doe...

I presume you must have more rules than this, or is this just the starting point? I've usually used '&' instead of nested if statements for this sort of thing, but to be honest I've never really thought about which one would be faster. Perhaps someone else could shed some light? I would also con...

Should the Masters course be brought back... in my opinion yes but only if the test format was changed They'd also have to translate the Spanish examples into at least English! Perhaps I'm going through the 'trough of disillusionment' in my own TM1 hype cycle, but I'm starting to think that the tec...

Any scripting language is by definition a programming language (one being a subtype of the other). The TI scripting language is therefore most definitely a programming language, regardless of any real or perceived shortcomings, which every programming language has. The fact that it's lacking certai...

I will add that I have been guilty in the past of building things which are far too complex, and will probably be guilty of it in the future too! Don't want to sound like I'm preaching, but the drive should be towards simplifying things, not towards making it easier to do complicated things.

I'll say something that might be controversial, but I haven't had anywhere near enough coffee and I have a small baby that doesn't like sleeping so I'm past caring today! I like that the TI editor is rubbish. Sames with the rules editor. If you ask me the number one issue with TM1 systems is that th...

In fact, any decimal reversal with just 2 numbers will always sum to exactly zero and be suppressed. eg. 0.123456789 -0.123456789 so anything that is mis-posted to an unused account and then reversed out the following month, for example would be removed. Or a customer who gets a refund and has no ot...

Hi Qml, I used to believe exactly the same thing, until I spent about a day going crazy wondering why the monthly totals in my csv export didn't reconcile with the monthly totals in my cube view! I've just done a bit of random testing in v 10.2.2 FP6, and about 50% of the combinations I enter do end...

And as an extra note, if you use a 'Total of Months' and zero suppression is on, you need to make sure somehow you don't miss rows where the total of all months is zero, but the individual months are not. E.g. Financial data which has been posted against an account in Jan, but reversed out in Feb. Y...

For the sake of sharing, here was my attempt at DBRW functionality in Google Sheets using Google script and the TM1 Rest API. As I mentioned, I think it's a dead end due to the way the cache service is on a different server to the sheet service and communication between the two is too slow to put th...

I used this tool which was very helpful for querying the TM1 rest API - Post or Get, including authentication: https://www.hurl.it/ I actually managed to host a TM1 server on an Amazon AWS instance, and then using the REST Api, successfully managed to get a cube view onto a Google Sheet using a Goog...