TM1 Forum

My first guess would be a slow network (high ping) to the server. Using the newer Excel addin pafe would improve performance if this is the case

Don't know if this setting applies to admins or not and whether it would fit what about the "Allow Write Back from tm1web" setting per the screenshot attached. It might be set to disallow

Try changing from dbrw to dbr just for the components that make the header

The sizing for the virtual machine is too small and the containers are likely stopping due to insufficient resources. Just running the paw component on its own will require 12-16 GB memory about 70/80 GB of storage on windows. That's before accounting for tm1web or the tm1 server component. At a pus...

I take by your suggestion, the clients that have been witnessing this problem stopping the containers and then restarting the them resolves it for this clients. You could look to do a schedule a weekly restart but that may not necessarily help. When you are getting "PAW is unavailable..." ...

}dimensionsecurity can be created with PAW or Architect (by an admin user) by right clicking on dimensions and setting security. In PAW the user gets a notification if the cube doesn't exist checking if the user wants to proceed before creating the cube. (without looking) i don't think this check oc...

Here's the IBM note:
https://www.ibm.com/docs/en/planning-an ... _paste.htm

Both PAW and PASS have endpoints for users to access through. Strictly speaking it doesn't matter how you choose to split out these components over which servers but if you want external users to be able to connect those endpoints will need to be exposed to the web meaning firewalls opened, SSL impl...

Planning analytics is not yet supported on windows server 2025. Windows server 2022 is the latest supported version. This is confirmed via IBM compatability report, link below: https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/osForProduct?deliverableId=8A5A88BAC7844AAE9...

All databases running under a single installation of planning analytics can only run on the same version. Your options are: 1) Have multiple installs of Planning Analytics, one on 2.0.9 and one on 2.1 and migrate one at a time. 2) Upgrade Planning Analytics to the latest version of 2.0.9 for PA, PAW...

Yes, depending on the report type used. Universal Reports - Fully support Quick Reports - Fully support Exploration - Fully support Custom Report - Limited support with use of TM1Set Dynamic Report - Limited support with use of TM1Set The universal reports can be designed to replace dynamic and cust...

I'll also add, the original query won't work as I'm guessing you are trying to run this in the subset editor for the dimension }kw_n_von In that scenario the currentmember statement will only work on that dimension, it won't work on [}Numbers].Currentmember because it's not in context You'd have to ...

Have you tried this FILTER ( { TM1SUBSETALL( [KW] )}, [}FILTER_KW].( StrToMember( "[}KW_N].["+ [KW].CurrentMember.Name +"]"), StrToMember( "[}KW_N_Von].["+ [}TM1Config_UserSelection].( StrToMember( "[}Clients].["+USERNAME+"]"), [}TM1Config_UserSelect...

Yes it's possible, you could use the Generate function to do this. I'm not at a pc today but if noone comes back I can post an example tomorrow

With perspectives your options are likely to be: - Use the rollup button in the subset editor... Select 2 or more elements and click rollup they'll be a temporary consolidation created. - Use subsets... Subsets can be used in DBRW, DBR statements in place of an element name to return the total sum o...

Try this instead

I think that you can remove "" + and + "" unless Burnstripe is sure they are needed ? They were needed for passing the subset name within the tm1subsettoset With the "" it returns as this and works TM1SubsetToSet ([Location].[Location] , "my subset" , "p...

Try this:

Right now there is no function to achieve this natively. Bursting however is on ibm's road map for Q2 2025 https://bigblue.aha.io/published/30f7b700d5eb7d18cfdd19c793f4a10d?page=4 "Workspace book burst includes data export | Workspace book bursts can be configured to include both PDFs of tabs i...

Below is an example. I have a period dimension with a hierarchy financial year which has periods rolling into a year. Multiple years (consolidations) are listed in a public subset called "Years". The code below returns the children of each of those years listed in the subset DISTINCT( GENE...