Search found 1015 matches
- Thu Apr 25, 2019 9:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and threads
- Replies: 21
- Views: 19408
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...
- Wed Apr 24, 2019 8:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and threads
- Replies: 21
- Views: 19408
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...
- 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: 57182
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...
- Wed Jan 30, 2019 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }Views_* and }Subsets_* control dimensions
- Replies: 5
- Views: 3239
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!
- Wed Jan 30, 2019 12:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }Views_* and }Subsets_* control dimensions
- Replies: 5
- Views: 3239
}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 '...
- 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: 9532
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...
- 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: 5
- Views: 6425
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...
- Wed Aug 29, 2018 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy Process
- Replies: 4
- Views: 2582
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...
- 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: 52922
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...
- 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: 5404
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...
- 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: 5404
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...
- 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: 57182
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...
- Wed May 09, 2018 9:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: stored values in tm1
- Replies: 6
- Views: 4612
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...
- Wed May 09, 2018 8:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: stored values in tm1
- Replies: 6
- Views: 4612
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.
- 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: 2258
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...
- Mon Apr 23, 2018 9:11 am
- Forum: Useful code, tips and tricks
- Topic: Available loggers for use in tm1s-log.properties
- Replies: 5
- Views: 30750
Re: Available loggers for use in tm1s-log.properties
I've tried the Rest API loggers but nothing came through.. anybody succeeded with that? Sorry to resurrect the thread, but in case anyone is looking for the REST API loggers - the following ones are working correctly as of the last few versions: TM1.HttpRequest TM1.HttpRequestHeaders TM1.HttpReques...
- Thu Apr 19, 2018 11:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Direct version of dimension updates
- Replies: 5
- Views: 3479
Re: Direct version of dimension updates
DimensionUpdateDirect is very important. If you don't use it to recompile the dim after using any of the Direct insert functions then I find that: a) rules will not be attached to the new elements; b) the first use of DIMIX will put an IX lock on the dimension - something you don't want to have if y...
- Fri Mar 23, 2018 5:34 pm
- Forum: Useful code, tips and tricks
- Topic: Using old clients with new planning analytics server
- Replies: 16
- Views: 57182
Re: Using old clients with new planning analytics server
We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done: 1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration 2) add in tm1s.cfg: SupportPreTLSv12Cli...
- Wed Jan 03, 2018 4:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How To Avoid LF in source file
- Replies: 2
- Views: 2985
Re: How To Avoid LF in source file
I think you'll have to do some sort of pre-processing of the file to remove the unwanted LF characters. You can do it directly in TI (if you have a way of recognising where the genuine new lines should be - e.g. any LF within a string enclosed in double quotes would be a candidate for removal), but ...
- Thu Nov 23, 2017 4:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 cube not showing data in Analysis/Report studio
- Replies: 6
- Views: 6107
Re: TM1 cube not showing data in Analysis/Report studio
There must be some difference between the packages. Maybe one is published as CQM (Classic Query Mode) and the other as DQM (Dynamic Query Mode)?