TM1 Forum

Hi, this can appear when you have a mismatch in quick report and cube structures. Possible reasons: You have several dimensions in rows/columns, and their order is broken (eg you have accounts and months in rows (in this order), but the labels aer in different order (September, Revenue)) Sandbox doe...

I've dragged random dimensions (Version and Cost center) to colors just to show how it works.

This depends on what you want to be split to different lines and different columns. Note that This should be different dimensions

You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)

Hi,

You need "Color" section in "Fields" tab for this.

Hi, Here is mine: $serverSmtp = "smtp.XXXXXX.XXX" #May be different! Check with mail server administrator $port = 587 $encoding = [System.Text.Encoding]::UTF8 $From = "XX@XXXX.XXX" $To1 = "XXX" $To2 = "XXXXX" $subject = "My subject" $user = "XXX...

These are basic things, and BIM documentation and Google will help you more at this stage than tm1forum
https://www.ibm.com/docs/en/planning-an ... d-activity

Hi, There can be 2 reasons of slow data entry: Somebody locked something, and you are in queue The cell you are writing data in overfeeds something (most probably, a large consolidation) Use tm1top (or PAW administration) to determine this. But, is it really data entry? You say that you wait 10 minu...

Aaaand I think it's the last in this thread and I will stop spamming

It looks like 10.2.2 is not affected. Try to switch the date to 26 AUG 2022 on you server and check if something fails.

I've addressed this question to IBM team here: https://community.ibm.com/community/use ... fd25c11045

Hi, I could not find the certificates on IBM site I doubt that I can share with you the certificates from my PA installations due to Intellectual Property Rights and because of other security stuff I'm not sure PA certificates can be used in TM1 10.2.2 10.2.2 is no longer supported by IBM Having all...

Hi all,

I've had another RefreshAllData fault with "91" error recently: DAX add-in caused this. Disabling it fixed the error

This is fixed: https://www.ibm.com/support/pages/node/ ... SSCTEW-_-E

Hi, Primo , beware of several dates being summed up on consolidations Secundo , This is much easier with dates, than if it was really a string measure, because you can convert date to number and then to string again. Here is idea how to do this: Say we have string "Date" measure where we h...

Wow, thanks George!

Thanks Wim! A very useful one! :--)
I have already rewritten all my backup processes using your idea. It is much more efficient than 7zip: faster and needs less memory.
Now rewriting log files archiver.

Hi, Did it work before on your PM? Does it work on another PM? Try to edit rights in TM1 Applications (my.server.com:9510/pmpsvc). If there is an error, the logs in webapps/pmpsvc/logs folder should be more informative. Also, check you }tp_tasks_appGUID dimension. It should be equal to your approval...

hisathishkumar wrote: ↑Mon Jan 24, 2022 11:39 pm
Is there any way to get that working? either by changing the MDX or changing something in PAW?

No. Somebody has already asked this on IBM community forum: IBM said that when you drag filter to external widget, MDX becomes disconnected from view.

Hi, what interface are you using?
If it is tm1web, it will not work. such dynamic subsets work only when Year is in context and Employee is in rows/columns
"Both dims in filters" will work only in PAW (until you drag them out of the view to external selector widget)

You can possibly mean Package Connector (Thanks George Tonkin for reminding this), which used Cognos packages to connect to SAP. It is depreciated now. There are other options, using the proper software: Cognos Integration Server - can get values from SAP and push them to TM1 SAP PI - can also push ...

Hi,

It not possible to integrate with SAP using TI. The options are:

• SQL server as a Stage DB
• Flat files
• Pure Rest API
• Tm1py