Search found 103 matches

by whitej_d
Wed Jun 21, 2017 3:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using sandboxes to migrate data changes from dev to prod
Replies: 1
Views: 464

Re: Using sandboxes to migrate data changes from dev to prod

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...
by whitej_d
Wed Jun 21, 2017 2:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using sandboxes to migrate data changes from dev to prod
Replies: 1
Views: 464

Using sandboxes to migrate data changes from dev to prod

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...
by whitej_d
Wed May 31, 2017 2:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 perspectives TM1RPTROW problem
Replies: 10
Views: 1926

Re: TM1 perspectives TM1RPTROW problem

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...
by whitej_d
Wed May 31, 2017 2:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing Data showing as Blank in EXCEL. How to Default to "0"
Replies: 8
Views: 1454

Re: Missing Data showing as Blank in EXCEL. How to Default to "0"

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, performan...
by whitej_d
Fri Mar 24, 2017 2:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy version performance
Replies: 15
Views: 3151

Re: Copy version performance

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...
by whitej_d
Fri Mar 03, 2017 5:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder problem in allocation model
Replies: 5
Views: 1288

Re: Feeder problem in allocation model

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...
by whitej_d
Wed Feb 22, 2017 1:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder performance - Which is better to feed from?
Replies: 4
Views: 1034

Re: Feeder performance - Which is better to feed from?

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...
by whitej_d
Thu Jan 12, 2017 8:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance Issue
Replies: 11
Views: 2036

Re: TM1 Performance Issue

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...
by whitej_d
Thu Nov 17, 2016 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Data Underneath ruled cells 10.2.2 FP6
Replies: 2
Views: 587

Re: String Data Underneath ruled cells 10.2.2 FP6

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.
by whitej_d
Thu Nov 17, 2016 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Data Underneath ruled cells 10.2.2 FP6
Replies: 2
Views: 587

String Data Underneath ruled cells 10.2.2 FP6

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...
by whitej_d
Mon Sep 12, 2016 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cubes structure optimisation or complex feeders
Replies: 7
Views: 1051

Re: Cubes structure optimisation or complex feeders

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 conside...
by whitej_d
Thu Sep 08, 2016 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having a rubbish TI editor is a good thing.
Replies: 10
Views: 1742

Re: Having a rubbish TI editor is a good thing.

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...
by whitej_d
Wed Sep 07, 2016 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having a rubbish TI editor is a good thing.
Replies: 10
Views: 1742

Re: Having a rubbish TI editor is a good thing.

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...
by whitej_d
Wed Sep 07, 2016 3:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Editing code... your preferred way?
Replies: 13
Views: 2633

Re: Editing code... your preferred way?

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.
by whitej_d
Wed Sep 07, 2016 2:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having a rubbish TI editor is a good thing.
Replies: 10
Views: 1742

Having a rubbish TI editor is a good thing.

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...
by whitej_d
Wed Aug 31, 2016 3:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 22
Views: 3537

Re: Export Cube data in CSV file, with all Months as columns

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...
by whitej_d
Wed Aug 31, 2016 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 22
Views: 3537

Re: Export Cube data in CSV file, with all Months as columns

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...
by whitej_d
Wed Aug 31, 2016 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 22
Views: 3537

Re: Export Cube data in CSV file, with all Months as columns

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...
by whitej_d
Wed Aug 31, 2016 2:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 21237

Re: TM1 REST API ( Any early adopters )

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...
by whitej_d
Wed Aug 31, 2016 2:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API ( Any early adopters )
Replies: 52
Views: 21237

TM1 Rest API and Google Sheets

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...