Search found 984 matches

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: 13
Views: 1347

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: 318

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: 318

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: 191

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...
by qml
Mon Apr 23, 2018 9:11 am
Forum: Useful code, tips and tricks
Topic: Available loggers for use in tm1s-log.properties
Replies: 3
Views: 1832

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...
by qml
Thu Apr 19, 2018 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 337

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...
by qml
Fri Mar 23, 2018 5:34 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 13
Views: 1347

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...
by qml
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: 393

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 ...
by qml
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: 690

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)?
by qml
Wed Nov 22, 2017 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube not showing data in Analysis/Report studio
Replies: 6
Views: 690

Re: TM1 cube not showing data in Analysis/Report studio

The report doesn't even have to be zero-suppressed. For a number of years now the default behaviour for TM1 as a data source for Cognos BI has been to do server-side zero suppression. Which means that if your cube is not fed correctly you will see no data in Cognos. Server-side zero suppression can ...
by qml
Tue Oct 24, 2017 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parent Element in Subset
Replies: 3
Views: 337

Re: Parent Element in Subset

Subsets do not store any relationships between elements, so unless your subset is designed to encode relationships in the element order itself (e.g. the parent you're after is always directly before the child or something similar) then you're out of luck. Of course, ELPAR can be used to get any pare...
by qml
Mon Oct 23, 2017 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Package Connector is disabled
Replies: 3
Views: 355

Re: TM1 Package Connector is disabled

Do you have the Package Connector installed on the machine where you are running Architect (as well as on the server)?
by qml
Tue Oct 10, 2017 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to re-use the data from source twice?
Replies: 3
Views: 315

Re: How to re-use the data from source twice?

TM1 has a built-in mechanism to loop through the source data twice already - that's what the Metadata and Data tabs are for. And you can manipulate data on the Metadata tab - there are no rules against that. Having said that, why can't you execute the condition separately for each record? I can't th...
by qml
Fri Sep 22, 2017 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 1376

Re: Rules Created by Links are not allowing us to copy data from source version to target version

cTempViewTo is a target view.can i send the code written in TI Process. While normally posting your actual code is highly encouraged (ideally in the first post of the thread), it looks to me like in this case we have painstakingly amassed enough information to conclude that you need to include rule...
by qml
Fri Sep 22, 2017 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 1376

Re: Rules Created by Links are not allowing us to copy data from source version to target version

I will ask again, because it seems very important here:

Is cTempViewTo your source view?

The name suggests that this is your target (ZeroOut) view, not the source. That would explain why the ViewExtractSkip functions are not having the expected result.
by qml
Thu Sep 21, 2017 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 1376

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Is cTempViewTo your source view? Also, typically you would not want to include consolidations or zero values because the view can become very large and usually there is no point in copying such values. Or even a place to store them. Are you perhaps trying to copy some C-level rule-calculated values?
by qml
Thu Sep 21, 2017 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Replies: 5
Views: 648

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

Steve is right. Cognos BI needs a single, unique hierarchy path to each element. If there is more than one, because e.g. there are alternate hierarchies, it will use the full path to identify an element. And what is more, from Cognos's perspective each one of the instances of that element in the hie...
by qml
Thu Sep 21, 2017 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 1376

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi Rajesh. The Cube View you are using as the data source for your TI needs to include rule-calculated cells. By default such cells are excluded, just as consolidations and zero values are. You can use the TI function ViewExtractSkipRuleValuesSet to set the flag appropriately.
by qml
Wed Aug 30, 2017 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to write to two WRITE members on control dim
Replies: 2
Views: 422

Re: Unable to write to two WRITE members on control dim

When you say your version dim is a 'control' dim do you simply mean its name is prefixed with the '}' character or do you mean it's actually one of TM1's pre-existing control dimensions? How is this dimension updated? I would assume it's updated via TI? Are you by any chance using DIrect functions t...
by qml
Wed Aug 02, 2017 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a cube with a separate administrator
Replies: 11
Views: 985

Re: Create a cube with a separate administrator

Kamil, Interesting suggestion. I expect the people who wrote the license agreement will have no idea about a "Local server" and I can find no specific referenc to it in the 10.2.2 licence agreement. However, if it is running on the administrator's local PC (not the server) and the instance is consi...