Search found 1000 matches

by qml
Tue Oct 15, 2019 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Speeds
Replies: 4
Views: 1875

Re: RAM Speeds

Because as RAM clock speeds go up each operation takes more clock cycles, increasing the relative latency, therefore you cannot expect to double your performance. A more realistic outcome would be a 10-20% improvement, depending on many additional hardware and software factors.
by qml
Wed Jun 26, 2019 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 3743

Re: Lock Contention and RollBack

mce, Does your master process also execute a DIMIX on the DimX dimension? Or any other function on that dim? Contrary to what you might think, DIMIX sometimes requires more than just an R lock. I don't understand it fully, but I have observed that e.g. the first DIMIX on a given dim after a server r...
by qml
Thu May 09, 2019 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a View in TM1 (Planning Analytics 2.0)
Replies: 3
Views: 383

Re: Creating a View in TM1 (Planning Analytics 2.0)

I received a DM from Peter: "How difficult is it to create the TI process? What is involved?" I'm replying here as this is a public forum and discussions should be available to everyone who wants to benefit from them. Such a process would take a few minutes to create by anyone with any TM1 developme...
by qml
Thu May 09, 2019 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a View in TM1 (Planning Analytics 2.0)
Replies: 3
Views: 383

Re: Creating a View in TM1 (Planning Analytics 2.0)

Unfortunately and notoriously, a user cannot create a public view without being at least Admin for the cube in question, which is rarely a good idea. Luckily, you can create a simple TI process based on the function PublishView to turn any private views into public ones. The users can run this proce...
by qml
Wed May 01, 2019 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 3997

Re: RunProcess and threads

When you consider Synchronized() function or when you consider batchupdate functions, are the threads treated as completely independent process executions similar to the way it happens when executed via RunTI or are they still dependent on the main process that triggered them similar to the way it ...
by qml
Thu Apr 25, 2019 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 3997

Re: RunProcess and threads

To be fair though about tm1runti the locking that you *sometimes* get during the login phase only happens when using CAM. Never seen it happen when using vanilla TM1 security. That's right. CAM log-on consists of more than just the log-on itself. And CAM log-off consists of more than just the log-o...
by qml
Wed Apr 24, 2019 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 3997

Re: RunProcess and threads

Nah, these threads stick around in the exact same way as any other REST API threads do (because RunProcess uses REST API calls behind the scenes). Ultimately these threads do go away, perhaps when IdleConnectionTimeOutSeconds is reached (this needs to be confirmed). Not sure if this is really a prob...
by qml
Fri Mar 15, 2019 4:28 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 16
Views: 16216

Re: Using old clients with new planning analytics server

But I have a question. Once I have done the step 4, I see my instances that are migrated to Planning Analytics. But I don't see any more 10.2.2 instances that are not migrated yet. Is there a way to see at the same time PA instances, and 10.2.2 instances ? Hi Catherine, Yes, you will need to change...
by qml
Wed Jan 30, 2019 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Views_* and }Subsets_* control dimensions
Replies: 5
Views: 502

Re: }Views_* and }Subsets_* control dimensions

Fantastic, thanks both for the useful details. Both my googling and observational skills are in dire need of an upgrade!
by qml
Wed Jan 30, 2019 12:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Views_* and }Subsets_* control dimensions
Replies: 5
Views: 502

}Views_* and }Subsets_* control dimensions

This is a bit of a public service announcement and a bit of a question. I have noticed that as of PA 2.0.5 there are new control dimensions available which list all existing public views and subsets: - Dimensions named '}Views_ cube ' list public views associated with each cube. - Dimensions named '...
by qml
Mon Jan 28, 2019 9:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 12
Views: 2395

Re: Cube Viewer suppress zeroes hiding non-zero cells

There is a bug that one my customers currently has, I believe they are on PA 2.0.5 but not 100% as I don’t have access to install etc in their environment. The issue means that check feeders never shows “not fed” - I tested this with a simple a = b rule on a 2 dim cube. Again due to not having acce...
by qml
Wed Sep 05, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is the TM1 element member name maximum size limitation?
Replies: 3
Views: 2111

Re: What is the TM1 element member name maximum size limitation?

Apologies for this thread necromancy, but maybe someone will find some answers to the actual question in the thread title useful. The maximum number of characters in an element name seems to be 5459 , at least in PA 2.0.5, but this seems to be a front-end (Architect and Perspectives) limitation, not...
by qml
Wed Aug 29, 2018 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Process
Replies: 4
Views: 702

Re: Copy Process

It would be helpful to see your TI code. A few questions: - Are the rule-calculated values in the source cube at the N or C level? - What are the following extract settings for the source view in your TI: ViewExtractSkipCalcsSet ViewExtractSkipRuleValuesSet The reason I'm asking is that it's possibl...
by qml
Fri Aug 03, 2018 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 14393

Re: Planning Analytics using twice the memory of 10.1

One thing that does not hold true is that they seem to be saying that it did this anyway, in previous versions, but instead of doing it at startup it did it when you first did an MDX query. We have lots of MDX queries in the system and it is inconceivable that the system could be running for very l...
by qml
Wed Jul 18, 2018 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero out cube view from source elements
Replies: 5
Views: 830

Re: Zero out cube view from source elements

If your data source contains a record for all the intersections in the cube that you want to update why bother zeroing it out? Just replace the existing value with the new one. This accomplishes the same thing as zeroing out and updating. One case where such zeroout would be needed is if data in th...
by qml
Wed Jul 18, 2018 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero out cube view from source elements
Replies: 5
Views: 830

Re: Zero out cube view from source elements

Sure this can be done in a single TI, although it is not by any means a typical use case. Remember that if an element disappears from your data source it will not be zeroed out and that data will stay in the cube indefinitely. The way to do what you want is to use the Metadata tab to collect all the...
by qml
Mon May 14, 2018 2:04 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 16
Views: 16216

Re: Using old clients with new planning analytics server

Step 3 on Kamil's post implies (or at least it did to me) that you don't need to add the ibmtm1.arm file to the local install \ssl directory. Using 10.2 and 10.2.2 it wouldn't work for me unless that file is in the \ssl directory, no matter which directory I pointed the SSL Certificate Authority to...
by qml
Wed May 09, 2018 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 1573

Re: stored values in tm1

How are others overcoming this issue . do you always write roundp when there is a decimal value stored . To be frank in most cases* this is not a problem at all. Number formatting usually takes care of the small discrepancies that you can generally only see on the fifteenth or sixteenth significant...
by qml
Wed May 09, 2018 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 1573

Re: stored values in tm1

Here is a good TM1-focused article on the subject with some suggestions on how to minimise the impact of the problem of number representation.
by qml
Tue May 01, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtering Organizational Hierarchy Dimension using User logon
Replies: 2
Views: 612

Re: Filtering Organizational Hierarchy Dimension using User logon

First of all, security in TM1 is done via groups. So create group A for user A and group B for user B and assign users accordingly. Create alternate hierarchies in the organizational dimension and using element security restrict group A and group B to their appropriate hierarchies. The template will...