TM1 Forum

Hi Paul, Windows Server 2016 is no longer supported the file you mentioned ipa_workspace_win_2019_2.1.14.258 is only suitable for installing on Windows Server 2019. The last version of PAW that's supports Windows Server 2016 is 2.0.95. There are different installers for PAW for different windows env...

PAW applications cannot be published to Cognos Analytics. However Cognos Analytics could display/embed the webpage/PAW application within an iFrame. The pax to Cognos connection I suspect won't give you what you are looking for Outside of nesting the application, new reports could be built in Cognos...

Hi, the parameter MTQ can only be controlled with tm1s.cfg or REST API, it is a dynamic parameter so technically you could update the parameter before execution but I'd be more curious why you'd need/want to set it to 1? Assuming you have MTQQuery set to T, you could use DisableMTQViewConstruct in y...

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