Search found 3107 matches

by lotsaram
Mon May 20, 2019 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 188

Re: RulesOverwriteCellsOnLoad is NOT working

I found my root cause now. It is because of PersistentFeeders. I have that enabled and obviously, after disabling, RulsOverwriteCellsOnLoad works as expected. :D That's interesting. RulsOverwriteCellsOnLoad should be independent of PersistentFeeders! That this doesn't work when PersistentFeeders is...
by lotsaram
Thu May 09, 2019 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading a TM1 Application through the REST API
Replies: 3
Views: 949

Re: Uploading a TM1 Application through the REST API

You shouldn't need any workarounds to achieve this, Rest API or otherwise. Application folders is the one area of TM1 where you can give non-admin groups admin access within application folders (update, create, delete entries, create or delete sub-folders, etc.) End users can manage application fold...
by lotsaram
Thu May 09, 2019 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a View in TM1 (Planning Analytics 2.0)
Replies: 3
Views: 112

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

Is is possible for a user to create view of the cube and save it as a public view. My users can only save their views as private. The option to save them as public is greyed out. Is there some security setting that I need to adjust? Please advise. Thank you. If you don't have any TM1 development ex...
by lotsaram
Tue May 07, 2019 7:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 288

Re: TI - Add new element in alphabetical order under consolidation

Sheesh this ran a little off topic. But while I'm here ... DimensionSortOrder sets properties for a dimension; the dimension is not actually sorted until it is saved on the server. You don't need a SaveDataAll or for that matter CubeSaveData('}DimensionProperties') What the documentation is saying, ...
by lotsaram
Fri May 03, 2019 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 19
Views: 557

Re: RunProcess and threads

I agree with what qml said, it's not really about the parallelization of processes ruining on different threads but much more about the commit model used in TI where only the TI processes belonging to the same transaction have access to changes they have made prior to the commit and merge with the b...
by lotsaram
Fri May 03, 2019 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 303

Re: REST API: Space

I now want to change this, select an attribute with a space in the name, e.g. 'Business Unit'. /Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Members('10000')?$expand=Children($select=Name, Attributes/Business Unit),Element($select=Name,Type,Attributes/Busines sUnit) This is th...
by lotsaram
Thu May 02, 2019 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

@PavoGa you also got your wish expressed in https://www.tm1forum.com/viewtopic.php? ... 023#p65002
for new method of exporting cube data.
by lotsaram
Tue Apr 30, 2019 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

As of today PA 2.0.7 (TM1 11.5) is available on Fix Central . In this version the new RunProcess function (which has been present but incognito) is officially supported. The new bedrock library already optionally makes use of RunProcess in processes which deal with reading and writing cube data. }be...
by lotsaram
Fri Apr 26, 2019 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 19
Views: 557

Re: RunProcess and threads

Bakkone wrote:
Fri Apr 26, 2019 2:35 pm
Wait?

Is runprocess already in 2.0.6? I thought I had to wait until 2.0.7 which is getting constant delays.

Or is 2.0.7 already on the cloud plattform?
It's in 2.0.6 (11.4) it just isn't either announced, documented, nor officially supported until 2.0.7.
by lotsaram
Thu Apr 25, 2019 5:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 19
Views: 557

Re: RunProcess and threads

Although I have not used RunProcess just yet, but if I understand it correctly by using Rest API, TM1 does not need to log the user in and out (causing a lock) anymore as it used to happen with TM1RunTI? Typical workaround used to be to create a tone of admin accounts... Yes, the user ID of the par...
by lotsaram
Thu Apr 25, 2019 5:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

I like the new Parallelization option. Still up to a developer to make sure a process does not exceed maximum available threads or just simply use RushTI? Cheers Evgeny At this point there's no mechanism when using RunProcess to query the status of the thread. So the calling process has no way to k...
by lotsaram
Wed Apr 24, 2019 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

There's no external dependencies as any batch file that bedrock writes it also removes in the same process. However, this is a little weird that the backup process writes a single line batch file versus calling the console directly. It does seem unnecessary. Of course bedrock has come from a Windows...
by lotsaram
Wed Apr 24, 2019 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

To answer Wim's questions (but also for anybody else who might have the same or similar questions) Yes to contribute any new processes there are certain conventions to be respected so that the library is coherent. For example: pLogOutput as 1st parameter and consistent handling of informational and ...
by lotsaram
Wed Apr 24, 2019 5:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Re: Bedrock 4 for IBM Planning Analytics is available

Wim Gielis wrote:
Tue Apr 23, 2019 10:20 pm
Just a couple of ideas for new additions to the toolkit....
Hi Wim,

Bedrock is open to contributions by all. You would be welcome to contribute.
by lotsaram
Tue Apr 23, 2019 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 13
Views: 517

Bedrock 4 for IBM Planning Analytics is available

Hi all TM1 & Planning Analytics fans, A new version of the bedrock TurboIntegrator library has just been released. This is version 4 of bedrock and is a ground up rebuild of the library specifically for IBM Planning Analytics. Bedrock is a modular TurboIntegrator library with the intentions of signi...
by lotsaram
Tue Apr 23, 2019 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 11
Views: 1358

Re: Cube Transfer TI Process

Hi Members, I request your guidance for my below problem: I have to create a Cube transfer TI process which has to copy the data from Source cube : ExpRep to Destination cube: ExpRepForecast . Now the problem is both the cubes contain same set of dimensions except Source Cube contains Year and Mont...
by lotsaram
Tue Apr 23, 2019 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 10
Views: 830

Re: Found the Solution - Re: issues with moving TI processes

After many trial and errors, I found that the issue is with the naming of the TI process file. My TM1 server is on AIX and it does not like CAPITAL letters in file names. I changed Bedrock.Dim.Element.Component.Add.pro to bedrock_dim_element_component_add.pro and it worked ! Hi Rtel, Bedrock v4 is ...
by lotsaram
Tue Apr 23, 2019 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Dimensions
Replies: 9
Views: 695

Re: TM1 Dimensions

Bakkone wrote:
Wed Mar 27, 2019 4:35 pm
Too bad Bedrock 4 isn't publicly available yet... *hint hint*
Happy Easter! Bedrock 4 is officially released on GitHub.
by lotsaram
Fri Apr 12, 2019 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 820

Re: calculating WTD, YTD and QTD with rules

Here's your simple answer. Don't. Time period calculations should almost always be done with a hierarchy in the Time dimension and letting the consolidation feature in TM1 take care of it. It will perform light years faster than a rule and you won't have to worry about feeders. I second that. And I...
by lotsaram
Wed Apr 10, 2019 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics
Replies: 2
Views: 361

Re: Planning Analytics

I am looking for documentation which explains the differences and advantages of Planning Analytics vs. TM1. Want to understand how it is used for reporting and what the interface looks like and functions vs. TM1. Thank you. The short answer is Planning Analytics is TM1 . It's basically a re-brandin...