Search found 106 matches
- Sat May 18, 2024 3:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Accessing Planning Analytics Transaction Log in PAFE
- Replies: 0
- Views: 93
Accessing Planning Analytics Transaction Log in PAFE
(Admins please move to useful code if you find this useful. I can't post there.) The TM1 Transaction Log records the history of changes to cube values in your database. This happens seamlessly in the background. It allows you to answer the question: who changed what and when? It’s an invaluable tool...
- Thu May 16, 2024 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to open a PAW report in PAX?
- Replies: 6
- Views: 1330
Re: Is it possible to open a PAW report in PAX?
The reports have attributes displaying along with measures. Is what you're actually looking for displaying multiple attributes next to element in PAFE? Unfortunately MDX-based views (i.e. Quick Report, Exploration) don't support that. It is quite annoying because you can create a cube view in PAW w...
- Thu May 16, 2024 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
I have collected a huge amount of TM1 questions while interviewing people. I want to share them with the community, and I want to make this in a form of a quiz. After all this ends, everybody will be able to use all questions for interviewing or for interview preparation. I don't know about you guy...
- Fri May 10, 2024 7:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
[‘a’] = [‘b’] + 4; For this one, ['a'] will need to be fed when ['b'] is not -4. You can't feed from ['b'] because if it's 0, there's no feeding, therefore ['a'] will be an unfed 4. Assuming the model already has a "Config" cube, I would add an element called "Feed Static Addends&quo...
- Fri May 03, 2024 4:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
- Tue Apr 30, 2024 3:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: using cellput to put the same value in 2 element values
- Replies: 3
- Views: 957
Re: using cellput to put the same value in 2 element values
Try repeating CellPutN function, once with ‘1’ AND once with ‘3’.
- Mon Apr 22, 2024 2:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Methods for Inputting Data into TM1 Cube
- Replies: 12
- Views: 1340
Re: Methods for Inputting Data into TM1 Cube
Google (or ChatGPT) will help as .xlsx to .csv isn’t exactly a tm1-specific problem to solve.
- Fri Apr 19, 2024 7:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Methods for Inputting Data into TM1 Cube
- Replies: 12
- Views: 1340
Re: Methods for Inputting Data into TM1 Cube
If you have access to Excel and access to TI, why not “save as” in Excel to CSV? If multiple files, I suggest writing a VBA that automates this within a chosen folder. You may be able to build a VBScript (or other solution) and then trigger the .xlsx to .csv within TI using ExecuteProcess.
- Fri Apr 19, 2024 7:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
Two. However, I remember getting weird issues with some client apps, so I always do at least three.
- Sun Apr 14, 2024 12:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
Nothing. You have to hit enter first.
After you hit enter, 10 will replace each of the cells in that cell and to the right. In this case Total Year will now equals 120.
After you hit enter, 10 will replace each of the cells in that cell and to the right. In this case Total Year will now equals 120.
- Fri Apr 05, 2024 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
- In PAFE, report definition for: Quick Report, Exploration, Universal Report, as well as parameter for functions e.g. TM1SET - In PAW, report definition for explorations and all other visualizations - In TM1 Server definition for subsets/sets and views, as well as input for various Turbo Integrator...
- Mon Apr 01, 2024 3:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
Send an email to entire company that they have to resubmit their budget due to a catastrophic failure. That and pray to Manny that I don’t lose my job.
- Sat Feb 24, 2024 2:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
- Thu Feb 22, 2024 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
- Sat Feb 17, 2024 6:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 15684
Re: Ultimate Long TM1 quiz
Also feed from Job Type - it’s a string cell so any change to it will cause FEEDER to trigger and re-trigger:
Code: Select all
['Job Type'] => DB('Employee analysis', !organization, !EmployeeList, !Year, !Version,
DB('Employee', !organization, !EmployeeList, !Year, !Version, 'Job Type'),
!Employee);
- Wed Feb 14, 2024 1:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use of VBA in PA
- Replies: 5
- Views: 698
Re: Use of VBA in PA
THAT aside, keep your expectations with VBA/PAfE interactions low. VBA is practically undead at this point and is fairly limited in how it can interpret responses from REST/PAfE. PAfE itself is notoriously undocumented and a few of the core functions (like TM1ELLIST) don't behave as described. Resp...
- Wed Feb 14, 2024 1:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IF Statement Evaluation in Rules
- Replies: 4
- Views: 899
Re: IF Statement Evaluation in Rules
Short-circuiting is the concept here, and not every language implements that. VBA also does not for those using PAXAPI.
- Wed Feb 14, 2024 1:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA on IBM Cloud - Uploading users
- Replies: 4
- Views: 1201
Re: PA on IBM Cloud - Uploading users
Agree - either don't separate, or there should be an Invite T/F column in the CSV.
- Wed Jan 31, 2024 4:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA on IBM Cloud - Uploading users
- Replies: 4
- Views: 1201
PA on IBM Cloud - Uploading users
Just wanted to memorialize something I ran into today for benefit of others in the future. For PA on IBM Cloud (PAOC, IBM SAAS), there's two ways to add users in PAW: Manually creating them one-by-one using the Invite button -or- Uploading users from a CSV. When you use Invite button it's one stop s...
- Fri Sep 08, 2023 1:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 22292
Re: Bedrock And Github vs Other Options
I just wanted to say that I have been using bedrock TI (up to v4) professionally as a TM1 consultant/developer for at least 10 years in a large number of organisations, in big production environments and cannot think of a single instance of any of the processes malfunctioning. Every time I thought ...