Search found 3032 matches
- Mon Mar 18, 2024 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 722
Re: ODBCOutput Delete table error with MS SQL2019
Hello, I did not mean a production environment, but a testing environment would have been good too. Nice to see that there is a solution. Just note that ExecuteCommand will not be available anymore in the next major version of PA (that being said, changes to ODBC could come too but that's a differen...
- Mon Mar 18, 2024 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 722
Re: ODBCOutput Delete table error with MS SQL2019
Hello,
Do you have an environment with the latest version of PA ?
Do you have an environment with the latest version of PA ?
- Fri Mar 15, 2024 8:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving data from cube with different dimension
- Replies: 5
- Views: 602
Re: Moving data from cube with different dimension
2 people who do not reply anymore because no one wrote down all the code they needed ?
- Mon Mar 11, 2024 1:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding two if loops to a statement
- Replies: 4
- Views: 1042
- Fri Mar 08, 2024 5:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional Pick Lists
- Replies: 3
- Views: 204
Re: Conditional Pick Lists
Hi Wim, Thank you for this. It really helped me to understand more about using picklist control cubes. I've wrote this rule for one of my picklists: ['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function...
- Thu Mar 07, 2024 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional Pick Lists
- Replies: 3
- Views: 204
Re: Conditional Pick Lists
Hello
Did you try Google on:
TM1 dependent picklists
Did you try Google on:
TM1 dependent picklists
- Wed Mar 06, 2024 5:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding two if loops to a statement
- Replies: 4
- Views: 1042
Re: Adding two if loops to a statement
Hello, Can I ask you why you don’t finish your words and dimension names? It seems weird to have dimension names like that. I have never seen such strange dimension names. You mentioned that you have double loops, but I don’t see any code for that. I would also like to question your cube design. Ins...
- Mon Mar 04, 2024 6:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving data from cube with different dimension
- Replies: 5
- Views: 602
Re: Moving data from cube with different dimension
Yes, but I need help with the TI code As is the case for many TI processes, the Prolog tab code contains a zero out of the target cells. Also, the Prolog tab contains the code for creating a view collecting the input cells - those that need to be allocated. After that, the Data tab contains code to...
- Sun Mar 03, 2024 10:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }Drill process return handle
- Replies: 3
- Views: 245
Re: }Drill process return handle
Hello,
George Tonkin and Edward Stuart have been working on this in the past:
https://community.ibm.com/community/use ... utput-file
Does this help ?
George Tonkin and Edward Stuart have been working on this in the past:
https://community.ibm.com/community/use ... utput-file
Does this help ?
- Sat Mar 02, 2024 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving data from cube with different dimension
- Replies: 5
- Views: 602
Re: Moving data from cube with different dimension
TI will be the better option here.
- Fri Mar 01, 2024 6:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW mdx subset
- Replies: 1
- Views: 196
Re: PAW mdx subset
It’s not very clear to me but hopefully I get it right. The cube on which you have a view, doesn’t it have dimensions year / version / department ? Why would you be creating concatenations of these in another dimension ? I expect to see these 3 dimensions and the }Clients dimension and possibly a fe...
- Sun Feb 25, 2024 9:02 am
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14329
Re: Transfer private objects from one user to another
Updated version.
- Wed Feb 21, 2024 7:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ELPAR in Rule
- Replies: 2
- Views: 208
Re: ELPAR in Rule
Of you can turn it into a parent-child relation, why not store the parent name in a string value for the child ?
- Mon Feb 19, 2024 8:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subsets locked by phantom views
- Replies: 9
- Views: 5948
Re: Subsets locked by phantom views
That version is 2 years old, maybe it’s solved in the meantime ?
- Wed Feb 14, 2024 1:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Subset TI Data Source Alias
- Replies: 4
- Views: 774
Re: Dimension Subset TI Data Source Alias
Yes. You would retrieve the values in the Metadata and/or Data tab of the process. Or use the element attributes cube as the data source.
- Mon Feb 05, 2024 9:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA on IBM Cloud - Uploading users
- Replies: 4
- Views: 1117
Re: PA on IBM Cloud - Uploading users
What I did notice is that I could import a CSV containing 50 PAW users. I am not a Subscription Administrator in that model. The "Send invitation" button is greyed out. Importing users, however, is possible. Maybe that’s why IBM separated it in 2 parts. Someone that is not a Subscription A...
- Thu Feb 01, 2024 10:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA on IBM Cloud - Uploading users
- Replies: 4
- Views: 1117
Re: PA on IBM Cloud - Uploading users
Confirmed. Not really intuitive. Why would someone upload users to PAW and not wanting to invite them ?
- Wed Jan 31, 2024 10:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Tools 64 Bit - Does it exist?
- Replies: 7
- Views: 1571
Re: TM1 Tools 64 Bit - Does it exist?
In response to the original question, I have a new user base which is entirely on 64 bit Excel and some of them are pining for TM1 Tools so yes, I am working on a 64 bit version but I'm looking at converting over to the Rest API since some of the functionality in the existing one is based on ye old...
- Sun Jan 28, 2024 8:05 pm
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14329
Re: Transfer private objects from one user to another
As I am not really happy with my solutions in TI and the REST API, I loaded an idea / request for assistance.
https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-1340
Feel free to give it your vote.
https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-1340
Feel free to give it your vote.
- Sat Jan 27, 2024 9:05 am
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14329
Re: Transfer private objects from one user to another
I tried using TM1py and the TM1 REST API to achieve the same result. We all know that the file system and ExecuteCommand will be out soon. The solution suffers from being slow as well as that I cannot retrieve private application entries for a user. Also, impersonation is also out in V12 I think so ...