TM1 Forum

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

LGEIS wrote: ↑Wed Nov 17, 2021 3:27 pm

• 1. disabled auto refresh

Hello, I may misunderstand something... You need to enable autorefresh. Without it, you will not be able to use dynamic drop-downs

Hi, Do you have autorecalculation enabled? Where do you use TM1ELLIST? In named range? In short, you need to make named range using TM1ELLIST (this cannot be used in data validation), then display elements using INDEX, then make named range using OFFSET, and then use it in Excel data validation). I'...

Hi,

Can the subset you are using be private?

Hi,

This looks like PrivilegeGenerationOptimization is turned on in tm1s.cfg. Is it?

Thanks George, Adam, Wim, Geroge's variant looks the most elegant, and it works. And as Adam said, "Wait" is not needed. My final code is: Sub CommitAll() Dim oReport As Variant Dim iReportCount As Integer Dim iReportIndex As Integer 'Get number of reports in the book iReportCount = Report...