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.
Search found 97 matches
- Sun Apr 14, 2024 12:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 63
- Views: 8142
- Fri Apr 05, 2024 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 63
- Views: 8142
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: 63
- Views: 8142
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: 63
- Views: 8142
- Thu Feb 22, 2024 2:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 63
- Views: 8142
- Sat Feb 17, 2024 6:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 63
- Views: 8142
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: 618
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: 836
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: 1118
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: 1118
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: 20579
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: 7285
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: 609
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: 666
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.
- Wed Jun 21, 2023 10:54 pm
- Forum: Jedox
- Topic: Any Quality Open Source Olap ??
- Replies: 19
- Views: 662833
Re: Any Quality Open Source Olap ??
The only thing that comes to mind for open source OLAP is this recent blog post: https://community.ibm.com/community/use ... source-tm1
- Sat Mar 18, 2023 11:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Generic Ti for Multiple Cubes - Archive Versions
- Replies: 10
- Views: 1339
Re: Generic Ti for Multiple Cubes - Archive Versions
Hi Chris, Maybe Bedrock is suited for this exercise ? This. I'll help you, this is adapted from what we've used in production for multiple years. Put in some extra # comments for you. Let us know you make out. # Version dimension sVersionDim = 'Version'; # Iterate through all cubes to find ones with...
- Mon Nov 21, 2022 8:21 pm
- Forum: Useful code, tips and tricks
- Topic: IBM PAFE Operations Batch Scripts
- Replies: 2
- Views: 9105
IBM PAFE Operations Batch Scripts
Here are some useful batch scripts for IBM Planning Analytics for Excel (PAFE) Operations. Can use this as baseline to automate install / setup / deployment / configuration of IBM PAFE to end users. If you don't want to run in Windows Command Prompt or Batch file, you can review the below and naviga...
- Mon Nov 14, 2022 8:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM PAFE Add-ins Issue - Classic add-in reappears, New add-in fails to appear, New add-in fails to register for PAX API
- Replies: 4
- Views: 17549
Re: IBM PAFE Add-ins Issue - Classic add-in reappears, New add-in fails to appear
Ran into another issue today that isn't 100% related to Classic add-in (so adjusted thread title) but thought this was the best place to document it as the symptoms are the same. For me this happened during a dirty Excel crash. Symptoms are: No references to IBM PAFE in the Excel Add-ins window. IBM...
- Wed Nov 02, 2022 3:14 pm
- Forum: Useful code, tips and tricks
- Topic: Quickly promote or copy a PAW book
- Replies: 8
- Views: 13882
Re: Quickly promote or copy a PAW book
Nice little use case: When creating an action button in PAW and you link it to a process, when setting parameter picklist, you cannot specify control dimension, e.g. }Clients. So pick some other dimension, then do Ctrl + Q + / and you can find/replace all references of the dummy dimension with the i...
- Wed Oct 12, 2022 1:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cases where MDX is a better alternative to cube rules
- Replies: 9
- Views: 2391
Re: Cases where MDX is a better alternative to cube rules
I had a case where users need to track a measure as a percentage of Sales Revenue. Adding a rule to do this across any number of scenarios, periods, SKUs, Customers etc. etc. would have added huge calculation overhead. Rarely do we disagree, but here I am on the same page as Steve. For us this woul...