TM1 Forum

Here's a link to another thread on the topic.
https://www.tm1forum.com/viewtopic.php?t=14808

The tm1web logs can produce this information such as who accessed what websheet and when. After changing the Log4j properties you'll then need to parse through the file to extract the information you need

Which excel add-in are you using, the legacy perspectives or newer pafe/pax. If it's pafe/pax then for the addin to be fully functional you'll need to install planning analytics workspace (paw) which I wouldn't recommend attempting to install on your laptop. There's an awful lot of hoops you'd need ...

Thank you it helped May be you know another workarounds except offset ? In some places write that it is resource consuming The other question I guess is does sheet1 need be linked to sheet2 like this. I.e. What's stopping sheet1 from also being a dynamic report sharing the same filters as sheet2? T...

On dynamic reports the data rows are destroyed upon rebuild, so any direct reference to these rows will be destroyed on rebuild. Hence the links are broken as you are experiencing. One workaround would be to use the offset function were the range start is above the dynamic rows, then when the report...

You could create two alternate hierarchies Account Location In your dim1 which has the concatenation of account and location So you had Acc1-loc1 Acc1-loc2 Acc2-loc1 Acc2-loc2 In the account hierarchy you would have Parent: acc1 child: acc1-loc1 Parent: acc1 child: acc1-loc2 Parent: acc2 child: acc2...

Rather than looping through the elements in the subset in a ti process and incrementing, you could use the mdx view you already have as the source for the process so the values are already aggregated. To do this solely in rules Cellvaluen may be an option, I believe you can refer to a subset in plac...

Reflecting, consolidations is the only way to go. From a performance perspective you're going to need to use consolidations and should you attempt to refer to a consolidation with all leaves it's going to cause a circular reference, alternate hierarchy or not. Other options to using consolidations w...

Assuming that element 3 value can just be a calculation and doesn't need to be fed then you could maybe do this ['dim1':'dim1':'Element 3','Value']:N ['Dim 1':'hier','all elements'] - ['dim 1':'hier':'Element 3']; Where you're referring to an alternative hierarchy to pull back all elements and subtr...

Hi Steve, I also agree looks like dynamic memory allocation is in effect with a startup close to 35gb you're seeing and max of 72gb Not sure if this is run from the host server or the VM itself but this could confirm your suspicions https://www.dtonias.com/which-virtual-machines-use-dynamic-memory-h...

Is perspectives crashing on the server or end user machines? If it's on the server what's the behaviour with perspectives with windows 10 or 8.1. (windows 11 is not supported for perspectives) Have you, or can you set the compatibility mode for multiple monitors https://analyse-it.com/blog/2018/5/mi...

Windows 2022 is not currently supported for the tm1 server component (according to the ibm's compatibility matrix) Windows server 2019 is the latest supported windows environment for running the TM1 Server and other components such as spreadsheet services and workspace. Regardless... you don't happe...

It's possible as wim alludes to you'd need an if statement I presume the datasource variables are named something like this v1, v2... In the data tab, instead of renaming the variable to pdestver, redefine what v1 or whatever the variable is instead, then the cellputn is straightforward. Here's an i...

long shot, does the tm1p.ini refer to DimensionDownloadMaxSize? If so try removing it.

The other option is you set up the config on one machine adding all the connections and settings you need then take a copy of the office connection folder and push that to the other users machines. The Cognos\office connection folder contains all the settings used for PAX, and can be found here C:\U...

1) Active forms and slice should continue to work. Caveats when working with Pax - Set to automatic calculation as default unless in process of building complex report - more difficult to diagnose issues introduced when building. 2) conversion isn't great, sometimes works, sometimes not, not used en...

Within pmhub.html file stored in cognos analytics I suspect the paw port is specified instead of the proxy path. Try changing that?

It should work fine but if I was upgrading a client, I would upgrade it to cognos analytics. However some things to bear in mind if you don't upgrade... Cognos 10 is not compatible with the latest versions of Windows server so if the server runs if you find yourself needing to upgrade the server in ...

Change the syntax to this vMDX = '{FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = "' | vValue | '" )}'; Notice the double quote before the single quote before vvalue and a double quote after the following s...

Within tm1s.cfg was MaximumCubeLoadThreads previously set to a number like 2,3 but now its set to 0?

The optimuspy results would definitely be interesting, reordering could have a big impact on performance, just watch out for the memory consumption. If you don't have much spare memory capacity it may struggle. It's also worth looking at the rules in the source cube, could they be optimised. There's...