Search found 107 matches
- Fri Jul 05, 2024 11:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 113
- Views: 40102
Re: Ultimate Long TM1 quiz
I like the first choice the most but would opt for DB against }ElementAttributes vs ATTRS as wiser people than me have said it’s faster. I don’t like the Alias approaches as that doesn’t scale beyond 1 to 1 mapping. Same for DIMIX, that doesn’t scale when element order is different between ABC and A...
- 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: 2540
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: 6730
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: 113
- Views: 40102
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: 113
- Views: 40102
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: 113
- Views: 40102
- 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: 1078
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: 1698
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: 1698
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: 113
- Views: 40102
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: 113
- Views: 40102
Re: Ultimate Long TM1 quiz
Nothing. You have to hit enter first. ![Smile :-)](./images/smilies/icon_e_smile.gif)
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.
![Smile :-)](./images/smilies/icon_e_smile.gif)
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: 113
- Views: 40102
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: 113
- Views: 40102
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: 113
- Views: 40102
- Thu Feb 22, 2024 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 113
- Views: 40102
- Sat Feb 17, 2024 6:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 113
- Views: 40102
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: 838
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: 1130
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: 1409
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: 1409
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...