TM1 Forum

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

Wat?

Found it in Russian. TM#1 is tissue machine #1

avkaz wrote: ↑Wed Jun 09, 2021 9:28 am but I won't get a results of calculation

Of course, it's not the way to solve the problem. By commenting parts of code, you can figure out what part of code causes the problem, and then try to fix it.

Hi, Does any of your subprocesses update a dimension with heavy hierarchy? Try to find out which subprocess causes this, by commenting "executeprocess". Then you can find the exact operation, commenting half, half and half of the subprocess's code ("log2 search") PS This is a dri...

Hello (to all), I have some suggestions, but do not want to post them with such a Request for assistance. Am I alone? I don't think so: 5 days have passed, 130 views so far. Hello (to tomago), Please read Request for assistance guidelines (PLEASE READ) , analyze tm1server.log and other logs, provide...

Hi,
This is implemented in PAW ver. 2.0.62: https://www.ibm.com/docs/en/planning-an ... -process-2

There's a caveat to LoadOnDemand -- every cube that is rule referenced or has feeders will be loaded regardless, so it's not as useful as the documentation would have you think :) https://www.ibm.com/support/pages/demandload-property Yeah, good point, I didn't think about this... Another lateral id...

Hi,

You can use "load on Demand" parameter for this. Check it on every cube, and monitor the memory usage in }StatsByCube. The cubes which are not loaded - were not used.

hI,

I think this is what you need: viewtopic.php?f=3&t=15300&p=76080#p76080

You do not need "WRITE", "READ" is enough Try to check whether your user can access to this slice in tm1web/architect: "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]" Also check if the user has access to }Clients dimension and it...

Hi,
First of all, please clarify your version. The "Contributor" security settings are very different in different versions (starting with "}tp_owners", ending with date reservations)

Your profile says it's TM1 9.5. Is it right?

Hi,

I assume your user does not have have access to the "Security Type" cube or to dimensions' elements. Try to open this "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]" in Architect

Something I've waited for too long... Finally, I've got around to create an RFE:
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-517

There is a workaround, using a websheet. I've described it here: viewtopic.php?f=3&t=15793

The best I could implement for now, is using the Excel checkboxes: Assume we have a 2-dim cube. We need to replace the numeric values of a flag measure with a checkbox. First we need to enable Developer ribbon (right-click on ribbon, "customise the ribbon", enable "developer" rib...

Hi,
Very useful indeed! That's because the views in PAW are MDX-based, and every dimension, which is not listed in "on 0", "on 1" and "where" clauses, goes to hidden "default" dimensions. And it works fine