Search found 103 matches
- Fri May 10, 2024 7:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 78
- Views: 14052
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: 78
- Views: 14052
- 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: 813
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: 1100
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: 1100
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: 78
- Views: 14052
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: 78
- Views: 14052
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: 78
- Views: 14052
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: 78
- Views: 14052
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: 78
- Views: 14052
- Thu Feb 22, 2024 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 78
- Views: 14052
- Sat Feb 17, 2024 6:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 78
- Views: 14052
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: 668
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: 878
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: 1163
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: 1163
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: 21419
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 ...
- Wed Sep 06, 2023 11:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX which takes Value from Cube
- Replies: 12
- Views: 7437
Re: MDX which takes Value from Cube
Was thinking the same thing.
Did someone ask for me?
- Tue Jul 11, 2023 11:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hide 'Applications and Plans'
- Replies: 2
- Views: 633
Re: Hide 'Applications and Plans'
That is not currently possible.
- Fri Jun 30, 2023 12:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Check current user selection in UI
- Replies: 2
- Views: 688
Re: Check current user selection in UI
The only way would be to add an element to your column dimension (perhaps named “Selected”), then if a user inputs a value or picks a value in a picklist, you can programmatically identify which elements have been selected.