Search found 2776 matches

by tomok
Fri Jan 15, 2021 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disable Change of Rules
Replies: 9
Views: 436

Re: Disable Change of Rules

gtonkin wrote:
Fri Jan 15, 2021 3:38 pm
Could you get them to save the view as private and give them access to a TI to PublishView?
IMO, this is the answer. We do this for a select group of users that we don't want to make admins but they are responsible for creating reports and views for others in their departments. Works fine.
by tomok
Wed Jan 13, 2021 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Function Like TM1RPTROW to create Dynamic Columns
Replies: 7
Views: 181

Re: TM1 Function Like TM1RPTROW to create Dynamic Columns

Be careful with volatile functions like OFFSET in PAfE - they, as the name suggests, recalculate whenever a recalc happens. INDEX may be better but OFFSET killed my reports completely, Interesting. The OFFSET index# shouldn't change unless the active form is rebuilt so a simple recalc should not ma...
by tomok
Wed Jan 13, 2021 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom PAW Menus
Replies: 2
Views: 130

Custom PAW Menus

We have been on the IBM Cloud for a while but are just now working on a project to migrate everything from TM1Web to the PAW interface. What I am wondering is if anyone has any tricks or ideas for a menu system in PAW. We currently have a lot of menus and navigation stuff built using Action Buttons ...
by tomok
Wed Jan 13, 2021 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Function Like TM1RPTROW to create Dynamic Columns
Replies: 7
Views: 181

Re: TM1 Function Like TM1RPTROW to create Dynamic Columns

While not a perfect match, and not as dynamic. You could use the INDEX() formula combined with ELIST in excel to create the appearance of dynamic columns. But you would have to prepare your columns. So you would have 20 columns ready but if the subset is short only 10 would show data, the rest woul...
by tomok
Wed Dec 30, 2020 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Upgrade with Autosys Utility
Replies: 3
Views: 862

Re: Planning Analytics Upgrade with Autosys Utility

Hi All, We are about to start the TM1 upgradation to Planning Analytics IBM Cloud environment and currently the On-premise Tm1 is using the external scheduling utility Autosys to run the TI jobs. But we would like to know if the Autosys jobs can be configurable with the IBM Cloud server details to ...
by tomok
Mon Dec 28, 2020 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect – Custom rollup members Division/Multiplication
Replies: 1
Views: 639

Re: TM1 Architect – Custom rollup members Division/Multiplication

You cannot do anything other than multiplication and it cannot be against another member, only a plain numerical value. Something like 1, 2, 5, .5, .001, etc. What you are asking for can only be done in rules.
by tomok
Wed Dec 23, 2020 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementInsert difference between Position Index=1 and =2 in behaviour
Replies: 3
Views: 274

Re: SubsetElementInsert difference between Position Index=1 and =2 in behaviour

Putting 1 as the index means insert it into the first position in the subset. All the other members will be moved down a spot.
by tomok
Fri Dec 18, 2020 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Failed TM1RPTROW to Load in TM1 Web: Having two TM1RPTROWS
Replies: 8
Views: 795

Re: Failed TM1RPTROW to Load in TM1 Web: Having two TM1RPTROWS

Do you Have any idea what else should I change to make it work ? I don't know the answer to your question but it's important to understand that while IBM tries to make active forms work the same way in Perspectives (aka an Excel sheet) as it does in TM1Web there are numerous instances where it does...
by tomok
Fri Dec 18, 2020 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Element Security - Most restrictive
Replies: 5
Views: 329

Re: Dimension Element Security - Most restrictive

For the same dimension element if a user is a member of two groups, one that gives read access and one that gives write access then the user ends up with write access. This is the way it has always been for as long as I have been using TM1. I actually had no idea the documentation said otherwise. N...
by tomok
Thu Dec 17, 2020 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OPS Conosle CubeCellPickListGet Problem
Replies: 2
Views: 515

Re: OPS Conosle CubeCellPickListGet Problem

Hi togehter, I have a strange issue on one of my perspective reports in Excel. In some situations (scrolling / clicking in a Cell) TM1 is starting to calculate something even though the automatic Excel calculations are switched off. The OPS Console shows in this moments "CubeCellPickListGet" and I ...
by tomok
Fri Dec 11, 2020 11:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX TM1RPTROW : Stop Drill Down in Only one Element
Replies: 2
Views: 735

Re: MDX TM1RPTROW : Stop Drill Down in Only one Element

If you are talking about an active form report then you cannot make a consolidated element "not drillable". If the element is displayed as part of the TM1RPTRPW formula inside the AF and it is a parent node then it's going to have a plus sign next to it and it's going to be drillable. These are situ...
by tomok
Wed Dec 09, 2020 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about While Loop
Replies: 3
Views: 284

Re: Question about While Loop

You can use the DIMSIZ function to get the number of elements in your Region dimension, assign that number to a variable and then do a loop:

Code: Select all

nSize = DIMSIZ('Server:Region');
i = 0;
WHILE (i <= nSize);
  Do something;
  i = i + 1;
END;
by tomok
Fri Dec 04, 2020 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding attributes only to newly created elements
Replies: 6
Views: 395

Re: Adding attributes only to newly created

Or loop through all products in the Prolog tab and set the status to empty or "Inactive" with AttrPutS function. Then in the Data tab set status "Active" with AttrPutS. Or create a view on the }ElementAttributes_Products dimension with just that one attribute and do a ViewZeroOut. This will likely ...
by tomok
Wed Dec 02, 2020 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Default view not picking up Default subset
Replies: 4
Views: 275

Re: Default view not picking up Default subset

According to your pictures the subset used in the public view is indeed private. This is an invalid combination which is why other users are not seeing your private subset when opening the view.
by tomok
Mon Nov 30, 2020 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 795

Re: TM1 Servers with TBs of Memory

Hello, I would like to hear experiences with Large TM1 servers with more than or close to 1 TB of memory. Are there anyone who experienced TM1 servers with more than or equal to 1 TB of memory? What are the major challenges and how do you overcome those? Thanks in advance for all replies. Regards, ...
by tomok
Mon Nov 30, 2020 12:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multi threading in planning analytics
Replies: 4
Views: 379

Re: Multi threading in planning analytics

Hi, I am trying to find more information related to multi-threading in Planning analytics. Did not find any great examples to implement this in TM1. I want to load the data from source (csv file with 500,000 records) to a staging cube in TM1 using multi-threading feature to improve performance. Any...
by tomok
Tue Nov 24, 2020 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with IF...ENDIF and assigning a value to a variable
Replies: 4
Views: 262

Re: Problem with IF...ENDIF and assigning a value to a variable

I think the key is the syntax checker is not smart enough to follow conditional logic. It just looks at the code and barks if it thinks something is wrong. Since the first mention of V3 in your code is to set it to VN, which is a numerical, it thinks V3 is a numerical variable. Your next mention of ...
by tomok
Fri Nov 20, 2020 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT does not create output file
Replies: 10
Views: 695

Re: ASCIIOUTPUT does not create output file

Hello, its strange that the ASCIIOUTPUT does not create the output .cma file at all The code is very simple .... ASCIIOUTPUT('/folder1/folder2/test1.cma', '1', '2', '3'); Its a linux server and running TM1 10.2.2 (I want to extract a view and that's not working either ...so I tried a simple code as...
by tomok
Wed Nov 18, 2020 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form rebuild removes MDX in subset
Replies: 2
Views: 288

Re: Active form rebuild removes MDX in subset

For starters, subsets exist on the server and there is no functionality in TM1 to create or modify subsets via an active form so this is not happening. It sounds like you are talking about using MDX in a TM1RPTROW formula, instead of a subset. If so, that formula only exists in the first row of the ...
by tomok
Wed Nov 04, 2020 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Time period Dimension
Replies: 9
Views: 589

Re: Time period Dimension

I bet not many of us have used the second argument (Insertion point) in a function like DimensionElementInsert :D For me, I can count those situations on 1 hand. I know about that one but the problem for me isn't the position of the newly inserted elements, it's the ability to re-order the existing...