TM1 Forum

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)

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...

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...

**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...

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...

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.

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.

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...

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".

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 ?

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...

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.

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...

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...

Or use the ElementSecurityPut function. This will create the }ElementSecurity_ cube if it's not already created.

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 ?

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 !

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 !

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 ?

Thanks Ykud, it's really helpful !