PA 2.0.9.4 (11.8.00300.34)
Search found 94 matches
- Thu Jan 14, 2021 11:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.SQLAPI error message in TM1Server log
- Replies: 4
- Views: 128
- Thu Jan 14, 2021 1:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.SQLAPI error message in TM1Server log
- Replies: 4
- Views: 128
Re: TM1.SQLAPI error message in TM1Server log
Thanks Lotsaram, I guess we need to understand what cause this error on our ODBC driver. I was thinking about removing TM1.SQLAPI logs from the tm1server log with the following line but I'm afraid I won't get the 'real' errors such as E16) Cannot connect to ODBC data source log4j.logger.TM1.SQLAPI=O...
- Wed Jan 13, 2021 4:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.SQLAPI error message in TM1Server log
- Replies: 4
- Views: 128
TM1.SQLAPI error message in TM1Server log
Hello, We recently update all of our IBM applications (PA, CA, PAW, Controller, FAP, ..) and we started getting these error in our TM1Server log everytime we execute or open a TI: 8288 [] ERROR 2021-01-10 04:00:24.664 TM1.SQLAPI 01000[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database co...
- Tue Jan 05, 2021 5:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW on Windows server 2019
- Replies: 4
- Views: 171
Re: PAW on Windows server 2019
**EDIT: I didn't saw the question was about Workspace. Based on an IBM Software product compatibility report , PAW is only available for the following Windows server: Windows Server 2016 Datacenter Edition Base x86-64 Windows Server 2016 Essentials Edition Base x86-64 Windows Server 2016 Standard E...
- Wed Dec 23, 2020 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 10
- Views: 639
Re: ASCIIOUTPUT does not create output file
But when I run the asciioutput in data section on the same path it does not create file at all. It's most likely the metadata/data tabs that are not getting processed. If you put a random ProcessQuit() in the data tab, did your TI gets terminated with a ProcessQuit error ? If it doesn't, there is m...
- Thu Dec 17, 2020 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Metadata and Data tab not getting processed
- Replies: 8
- Views: 701
Re: Metadata and Data tab not getting processed
Correct.cognos4321 wrote: ↑Thu Dec 17, 2020 10:03 pmAnd there is no way we can load data on top of rule driven cells.
You can use the CellIsUpdateable function to determines whether a cube cell can be written to.
- Thu Dec 17, 2020 9:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Metadata and Data tab not getting processed
- Replies: 8
- Views: 701
Re: Metadata and Data tab not getting processed
You can't load data in a cube if there is rules.cognos4321 wrote: ↑Thu Dec 17, 2020 9:14 pmWhat else can I do so that data gets copied over the rule driven
- Thu Dec 17, 2020 7:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Metadata and Data tab not getting processed
- Replies: 8
- Views: 701
Re: Metadata and Data tab not getting processed
I created a TI process where data needs to be uploaded into a cube from a csv file. In the Prolog tab there is source view created I'm not sure to understand because you said you want to load data in a cube from a csv file but you are using the view created in the prolog as data source ? # Assign t...
- Mon Dec 14, 2020 12:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.07 - }ClientProperties cube
- Replies: 15
- Views: 1468
Re: PA 2.07 - }ClientProperties cube
Thank you macsir but i'm looking for something more straightforward. I was thinking of something like "if user A is NOT in group X then disable user A".
- Mon Dec 14, 2020 12:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.07 - }ClientProperties cube
- Replies: 15
- Views: 1468
- Wed Nov 25, 2020 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Load time and tm1s log
- Replies: 1
- Views: 140
Re: Data Load time and tm1s log
Hello, I am loading around 5 million rows of data and it takes 6 hours . Is this normal as this will be 1 time load and will be refreshing only 2 months of data daily. I would say no, especially if you are only doing a simple CellPutN. Is there a lots of rules in your cube ? Show us your code, it wi...
- Thu Nov 19, 2020 3:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How can I make sure exported data are using the same decimal separator [English vs French]
- Replies: 3
- Views: 166
Re: How can I make sure exported data are using the same decimal separator [English vs French]
Thanks for your answer Steve, I'll have a look at the DatasourceASCIIThousandSeparator.
They are using PA on prem so the client is running the export either from Architect/Perspective or TM1Web. TM1 Server is on a VM and everything is in English.
- Thu Nov 19, 2020 2:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How can I make sure exported data are using the same decimal separator [English vs French]
- Replies: 3
- Views: 166
How can I make sure exported data are using the same decimal separator [English vs French]
Hello everyone I have a client with offices all around the world. A user is in France and everything is in French (OS, Microsoft Excel, Architect, ..) so when he opens a cube view, the numerical values are display using a comma as decimal separator (0,95 instead of 0.95). That same user needs to run...
- Thu Nov 12, 2020 5:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MTQ
- Replies: 4
- Views: 677
Re: MTQ
Hello, Based on IBM website , MTQ=n where n represents the number of threads to be used for a single operation. And by definition, The number of threads you have depends on the number of cores in your CPU. Each CPU core can have two threads. So a processor with two cores will have four threads. A pr...
- Tue Nov 10, 2020 3:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Security Import
- Replies: 3
- Views: 494
Re: TM1 Security Import
Or use the ElementSecurityPut function. This will create the }ElementSecurity_ cube if it's not already created.
- Wed Nov 04, 2020 6:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Commit Sandbox Numbers Generated by TI
- Replies: 3
- Views: 337
Re: Commit Sandbox Numbers Generated by TI
When you add the following line tm1s-log.properties and ask a user to try to commit/submit, what do you see in tm1server.log ?
Code: Select all
log4j.logger.TM1.Sandbox=DEBUG
- Tue Oct 13, 2020 5:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How you would explain what is TM1 to your mom ?
- Replies: 6
- Views: 899
- Tue Oct 13, 2020 4:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Admin access - Read Only
- Replies: 2
- Views: 749
Admin access - Read Only
Hello,
Is there an easy way to setup a group that will see everything ( Cube, dimensions, TI, ...) but will not be able to edit anything (READ only) ?
Thanks !
Is there an easy way to setup a group that will see everything ( Cube, dimensions, TI, ...) but will not be able to edit anything (READ only) ?
Thanks !
- Thu Oct 08, 2020 2:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How you would explain what is TM1 to your mom ?
- Replies: 6
- Views: 899
How you would explain what is TM1 to your mom ?
Hello everybody,
I'm always struggling when I try to explain to my family and friends what I'm doing.
How you would explain what is TM1 (and what a TM1 developer is doing) to someone who don't even know what Excel is ?
I'm always struggling when I try to explain to my family and friends what I'm doing.
How you would explain what is TM1 (and what a TM1 developer is doing) to someone who don't even know what Excel is ?
- Tue Sep 15, 2020 12:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Risks of using Multiple Commit Mode
- Replies: 2
- Views: 316
Re: Risks of using Multiple Commit Mode
Thanks Ykud, it's really helpful !