Search found 148 matches

by ardi
Mon Mar 25, 2024 9:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to avoid queuing at the end of processes parallelization ?
Replies: 5
Views: 346

Re: How to avoid queuing at the end of processes parallelization ?

Do yourself a favor, use RushTI. Before I started using RushTI, process parallelization was always causing challenges.
by ardi
Sun Mar 24, 2024 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5111

Re: Ultimate Long TM1 quiz

Data will be spread to leaf cells proportionally with existing values.

In this Case:
Value of January will change from 2 to 3, and value of February will change from 4 to 6. Value of March will remain zero
by ardi
Mon Mar 11, 2024 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding two if loops to a statement
Replies: 4
Views: 687

Re: Adding two if loops to a statement

Wim Gielis wrote: Wed Mar 06, 2024 5:52 am Hello,

Can I ask you why you don’t finish your words and dimension names? It seems weird to have dimension names like that. I have never seen such strange dimension names.
lol: I was thinking exactly the same. Impossible to follow the question with these object names
by ardi
Sat Jan 20, 2024 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5111

Re: Ultimate Long TM1 quiz

In that case, all cells will ne fed. Previously fed cells will remain fed until feeders will be rebuilt. On top of existing feeders, the updated feeder will Feed A1, so the results will be: ABC1('A1', 'Total Year') = 31 ABC1('B1', 'Total Year') = 16 ABC1('C1', 'Total Year') = 15 But after the feeder...
by ardi
Sun Jan 14, 2024 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5111

Re: Ultimate Long TM1 quiz

Still the results will be the same:

ABC1('A1', 'Total Year') = 0
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
  • A1 will not be fed
    B1 will be fed from B
    C1 will be fed from C
by ardi
Sat Jan 06, 2024 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5111

Re: Ultimate Long TM1 quiz

Only B1 and C1 are being fed, so the in the ABC1 Cube, the value of each elements will be:

ABC1('A1', 'Total Year') = 0 # A1 is not being fed,
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
by ardi
Sun Dec 31, 2023 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 18575

Re: REST API Dimension Clone

Thank you Ardian. Good additions. Maybe useful to post a sample file for 'config.ini' (though probably standard and not too difficult to do it ourselves) ? Of course without sensitive information but just the structure and some examples of entries. I would also skip the If test for the PRO extensio...
by ardi
Thu Dec 28, 2023 10:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 18575

Re: REST API Dimension Clone

Here is the version of the code I use to promote TIs from one TM1 Instance to another. I have a config file where I save all the connection details and I created a function to get all the information i need from the config file Also, I check if the Process exists in Target Instance. If it exists, I ...
by ardi
Wed Dec 13, 2023 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flexible PickList Definitions
Replies: 2
Views: 3493

Re: Flexible PickList Definitions

Hi, I want to have a Picklist for all used user defined dimensions. So I want a complete list of all elements, which would be: Dimension:DimName I also want to offer a list of all elements without the top level and a list without the leaf elements. Additionally I need to show attribute names define...
by ardi
Tue Dec 12, 2023 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4017

Re: PAW - GIT Repository Connection issue

Public or enterprise Github? I ran into similar errors trying to connect on-prem PAW to an enterprise Github repo and so far haven't got it working. I suspected that the connection was being blocked/rejected by enterprise github admins but haven't confirmed that. You are using the SSH url and not t...
by ardi
Tue Dec 12, 2023 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4017

PAW - GIT Repository Connection issue

Hello, We are trying to use the new PAW feature to add TM1 objects to GIT Repository, and for some reason, we cannot make it work. We have generated the SSH Public Key / Private Key, and also saved the SSH Key to GitHub, but when we enter the Repo URL / SSH Keys in PAW, we receive an error: TM1 Git ...
by ardi
Thu Dec 07, 2023 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16660

Re: ViewZeroOut doesn't work

Found one very strange thing in one TM1 model I can't zero any view in one Cube in it using ViewZeroOut. I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again CellPutN works, I can put 0 by hands but ViewZeroOu...
by ardi
Wed Nov 08, 2023 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10189

Re: Tm1 Model - Limit Overall RAM Usage

Hi there We have inherited a complex model (which is non business critical) which on rare occasions (every few months), start spiking the RAM to a point where the RAM for the entire server maxes out, and all models go down. Obviously we need to get to the root cause of what is causing this (initial...
by ardi
Wed Nov 08, 2023 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10189

Re: Tm1 Model - Limit Overall RAM Usage

lotsaram wrote: Wed Nov 08, 2023 6:21 pm You can't.

TM1 will eat up all available memory until it runs out.

And then it is paging, hanging and crashing time.
And the worst part is that TM1 does not release the memory back until next restart, even if you Zero Out some of the data
by ardi
Mon Nov 06, 2023 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding another if loop on status
Replies: 3
Views: 6713

Re: Adding another if loop on status

Formatting your code will go a long way in helping you to read/understand it and posting within a code block will go a long way in helping the rest of us help you. By the CellGetN you posted at the bottom for InvStatus, it appears you're using only the variables defined in the source view to derive...
by ardi
Mon Oct 23, 2023 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pafe/PAW View - Auto Spread at Consolidated Level
Replies: 2
Views: 2891

Re: Pafe/PAW View - Auto Spread at Consolidated Level

And if you want to keep Spreading enabled for some of the users, you should consider turning OFF this option

ProportionSpreadToZeroCells=F

By default this is turned on and in my experience this is dangerous
by ardi
Thu Oct 12, 2023 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transferring and Summing Data from cube to another
Replies: 4
Views: 6805

Re: Transferring and Summing Data from cube to another

Hi Everyone, A quick explanation of what I want to do: I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube. I understand I need to use a process to do so, is that correct? Or is there al although a way with a rule? I just want to start in ...
by ardi
Mon Sep 11, 2023 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons - VBA to Change Server Name
Replies: 6
Views: 679

Re: Action Buttons - VBA to Change Server Name

Hi there I am trying to use VBA to change the Server name for multiple actions buttons (in multiple workbooks) in Perspectives There is an article from Wim Gielis which details exactly how to do this: https://www.wimgielis.com/tm1_actionbuttons_EN.htm Unfortunately, I cannot figure out how to add t...
by ardi
Sun Aug 27, 2023 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ClientGroups cube not in sync. with Cognos
Replies: 11
Views: 1382

Re: }ClientGroups cube not in sync. with Cognos

Is the Client Groups membership defined in Cognos or in LDAP (Active Directory)? If it is in Active Directory, you can run some powershell script to extract the User/Group mappings. If they are defined in Cognos, then you can run a SQL against Cognos Content Store database tables ( as suggested by E...
by ardi
Wed Aug 23, 2023 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Next-Button when using SUBNM formula
Replies: 2
Views: 548

Re: Next-Button when using SUBNM formula

First thing, you need to have an attribute "Next_Month" on your Time/Month dimension. Then in your "Next Month" Action Button, make it Navigate to the same Websheet, but set the "Advanced Options" so the "Next_Month" Value of your Selected Month, for Target Ty...