Search found 94 matches

by Emixam
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

Re: TM1.SQLAPI error message in TM1Server log

macsir wrote:
Thu Jan 14, 2021 8:26 pm
What is the version of your TM1 server? I have seen some in 2.0.8 but they disappeared after upgrading to 2.0.9.1.
PA 2.0.9.4 (11.8.00300.34)
by Emixam
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...
by Emixam
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...
by Emixam
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...
by Emixam
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...
by Emixam
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

cognos4321 wrote:
Thu Dec 17, 2020 10:03 pm
And there is no way we can load data on top of rule driven cells.
Correct.

You can use the CellIsUpdateable function to determines whether a cube cell can be written to.
by Emixam
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

cognos4321 wrote:
Thu Dec 17, 2020 9:14 pm
What else can I do so that data gets copied over the rule driven
You can't load data in a cube if there is rules.
by Emixam
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...
by Emixam
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".
by Emixam
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

Re: PA 2.07 - }ClientProperties cube

macsir wrote:
Thu Oct 01, 2020 8:31 pm
Thanks, I am using CAM. Maybe that's the reason?
I'm also using CAM and it's not working. Is there another easy way to disable a client then ?
by Emixam
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...
by Emixam
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.
Steve Rowe wrote:
Thu Nov 19, 2020 3:04 pm
Where are you running the export from though?
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.
by Emixam
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...
by Emixam
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...
by Emixam
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.
by Emixam
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
by Emixam
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

Re: How you would explain what is TM1 to your mom ?

macsir wrote:
Thu Oct 08, 2020 8:49 pm
I build lots of rubik's cubes in a company so that people can play with. That's my job.
I'll keep this one ;)

Thanks guys !
by Emixam
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 !
by Emixam
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 ?
by Emixam
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 !