TM1 Forum

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

Hi,

As said before, it's definitely feeders. You need to switch them off before loading data

Create a blank rule file (or a rule file with rules, but without feeders): let it be "dummy"
In Prolog: RuleLoadFromFile('Sales', 'dummy');
In Epilog: RuleLoadFromFile('Sales', '');

Hello everybody! The Commit button commits data only in active sheet, so I'm asked to make a button to commit the entire book. Firstly , maybe there is an option to make the Commit button commit the entire book (like the "Refresh" one)? Secondly , I've made a VBA script to do this. The ide...

Hi, There are many ways to do this. 1. Create a view with 100 customers. Use Architect "Export as text data" function 2. in PAW or TM1web, use "export to excel" function 3. Use Bedrock: https://github.com/cubewise-code/bedrock/wiki/%7Dbedrock.cube.data.export 4. Write your own pr...

Hi,

If the chore doesnt show up in TM1TOP, it is not running. Your interface (Architect/PM/whatever) can hang itself and do not show the "the chore has ended" message.
Check your tm1server.log

Hi! Interesting! I've tried to find it in "TM1 Reference", and didn't find it either...

Hi, No, you've done the right steps. Try to relaunch Architect. Is .pro file new or old after PROD server starts? Try to find "side" errors like: Admin server is correct in Architect The server had stopped completely before you copied the file Double check the folder you are copying to

Thanks burnstripe,

But it is not what I need:
Grey and yellow icons are what I need to hide. And you have an empty ZSTAT, which should also be hidden

Hi,

It's can be done very easily using python and pandas:

1. Use tm1py to load data from TM1 to a dataframe: example
2. use gspread to load dataframe to google sheet: example

Thanks guys,

It's a completely websheet model, so custom macros and PAW could not be used
And yes, of course, I need this to be dynamic

Hi,

I have a websheet with stacked column chart. There are zero-rows and zero-columns. Is there a way to hide them?

Hi,

Do you use Performance Modeler? (if yes, I recommend to stop using it)
As far as I remember, it is the only one who add this lines of code. If you do not need SKIPCHECK in some cubes, double-click them in PM and select and deselect the option for automatic SKIPCHECK adding

I'll just post here an old Russian football joke

If you cheer for your national football team, then you are either a fool or a German

Hi,

Sandbox Synchronization for Action Buttons will be implemented in 2021 Q4: https://bigblue.aha.io/published/30f7b7 ... 10d?page=4