Search found 312 matches
- Tue Aug 26, 2025 3:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: All data input only at leaf level in Contributor
- Replies: 4
- Views: 2265
Re: All data input only at leaf level in Contributor
In PA, you'll find that setting in the }Capabilities cube, the specific item is "Consolidation TypeIn Spreading" and you'd want DENY for the EXECUTE permission.
- Tue Aug 19, 2025 7:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA to enable the PAfE add-in and auto login users
- Replies: 1
- Views: 1229
Re: VBA to enable the PAfE add-in and auto login users
What values are you passing to the 'hideForm' and 'bypassPAWchooser' arguments of LogonSSO? I use the below in a few reports for PA on cloud and it works fine. Reporting.LogonSSO(<url>, <database>, False, "") What version of Pafe are your users running and are some of them already logged i...
- Fri May 16, 2025 1:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE API to open a set editor
- Replies: 7
- Views: 10427
Re: PAfE API to open a set editor
Double clicking a SUBNM cell to open set editor works in Pafe except when you have an "&" in the subset name. The dropdown selection feature of SUBNM cells also doesn't work when you have an "&" in the subset name.
- Fri Feb 07, 2025 5:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule On consolidation which matches the natural consolidation
- Replies: 8
- Views: 28909
Re: Rule On consolidation which matches the natural consolidation
If I had to guess, 'Parent' used to be a leaf element and someone used that rule to make it the sum of the 3 other elements. Someone else came along later (or same person got a tiny bit wiser) and decided to make 'Parent' a real consolidation with the 3 as children and then forgot to remove the orig...
- Fri Jan 24, 2025 10:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TESTING TI NEW PROCESS TO EXTRACT ALL PROCESSES
- Replies: 12
- Views: 20121
Re: TESTING TI NEW PROCESS TO EXTRACT ALL PROCESSES
Check out TM1py for generating a report of this sort of TI process metadata.
- Wed Jan 15, 2025 10:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Coding Standards
- Replies: 7
- Views: 10193
Re: TM1 Coding Standards
I see things that upset me in both your original and the modified snippets, but if I had to pick which one I'd rather read, I'd pick the modified. Personally, I don't add spaces around a parenthesis, but I like to see consistency no matter what a developer decides they want to do with spaces. I like...
- Thu Jan 09, 2025 1:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Edit Dimension Subset
- Replies: 3
- Views: 4161
Re: Edit Dimension Subset
Let's start with the alias and ignore any changes to the subset itself. Since your screenshots are architect/perspectives, here's specific instructions for updating the alias there: In server explorer of Architect/Perspectives, right-click the dimension and select "Edit Element Attributes"...
- Thu Jan 02, 2025 7:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
I doubt I have the technicalities right, but I've always explained it as the calc cache being invalidated from the CellPut and thus forcing the source view to be re-evaluated/recalculated when you try to read from and write to the same cube in a TI. I believe it's also particularly sensitive to MDX ...
- Fri Dec 13, 2024 5:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
Ceiling or Ceiling.Math in excel? If you simply want similar as RoundUP which would be similar as Ceiling.Math the below would give you similar results in tm1. ## result of ceiling will be same as Ceiling.Math(3.7) in excel: 4 ['value'] = N: 3.7; ['ceiling'] = N: ROUND(['value'] + 0.499999, 0); ## r...
- Thu Dec 12, 2024 4:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DefineCalc on which version and apps available?
- Replies: 8
- Views: 8176
Re: DefineCalc on which version and apps available?
Keep the report structured just as you have it, but try removing the TM1RptTitle for that specific dim from the TM1RptView definition. You don't need to specify all of the title dims in the report definition, just treat it as if you're defining it in the columns but keep it up in the title elements.
- Fri Dec 06, 2024 4:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
Which definition of Floor? If simply rounding down to nearest integer, INT will achieve this. ## result of floor will be same as RoundDown(3.7, 0) in excel ['value'] = N: 3.7; ['floor'] = N: INT(['value']); ## expect floor to be 3 If needing to round to the nearest multiple of a significance value, ...
- Wed Nov 27, 2024 5:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DefineCalc on which version and apps available?
- Replies: 8
- Views: 8176
Re: DefineCalc on which version and apps available?
At minimum, you'll need Pafe to use DefineCalc.
- Mon Nov 18, 2024 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
- Fri Nov 15, 2024 2:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migrate Application folder structure to PAW or Excel?
- Replies: 7
- Views: 6089
Re: Migrate Application folder structure to PAW or Excel?
It would be great if I could get it to pause on the two Excel-based processes... I'm guessing the tm1 authentication piece is preventing you from calling the excel-based processes via a vbs script and running unattended? If not, you could call the vbs from a TI and simply make that part of the exec...
- Mon Nov 11, 2024 2:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Which platform do you use to write TI and Rules ?
- Replies: 8
- Views: 14077
Re: Which platform do you use to write TI and Rules ?
VS Code with the TM1 Helper extension.
cube data: PAW/Pafe/TM1py
cube data: PAW/Pafe/TM1py
- Fri Nov 08, 2024 9:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
Yes, parameter 278 in the sub file will have a 1 which dictates that the subset, despite being static, will be populated with all elements in that dimension anytime it is referenced or opened. As such, there also will be no element count parameter 270 in the .sub file or the list of static elements ...
- Wed Oct 30, 2024 1:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
- Mon Oct 28, 2024 6:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
It is clever but is that really optimised? I'll defer to Elessar's judgement on whether or not my suggestion was the optimization they were looking for, but I do believe Max/Min functions can be quite a bit faster than IF statement processing. I'm sure I've read a comment before by lotsa saying exa...
- Fri Oct 25, 2024 3:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
Code: Select all
['Y'] = MAX(0, ['X']);
- Tue Aug 06, 2024 3:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 215
- Views: 551941
Re: Ultimate Long TM1 quiz
If you want 'Element' to be of type S or C and not N, you'd first want to do a DimensionElementInsert.