TM1 Forum

Maybe one of the loggers could write to a log that you could use: https://www.tm1forum.com/viewtopic.php? ... ers#p81607

As a start, are both of you in Automatic calculation mode in Excel? PAfE works better like this whereas Perspectives was better suited to Manual.

What version of PAfE are you both using?

If you are using PAW as the UI and assuming you are just trying to show the PLC Rate, you could use a derived Member to get the value from the underlying cube and display it in the exploration. No feeding as it is purely for display purposes.

Probably not going to solve your problem but one of my pet hates is random variable names. Why pDir for the new of the new hierarchy? Is this a poor convention picked up from the consultant? Why not call it what it is, pHierarchy? Same would go for all variables used. Be descriptive for the next per...

A little gotcha for anyone following this or reading on CellValueN.
Had an issue on a rule not workingas expected. A silly typo, but rules editor does not warn of invalid hierarchies or elements.
Best to try use the intellisense/Ctrl+space (in PAW) to avoid silly mistakes...

You are in for a surprise! IBM sent this out recently: https://www.ibm.com/support/pages/node/6856989?myns=swgother&mynp=OCSSCTEW&mync=E&cm_sp=swgother-_-OCSSCTEW-_-E TLDR: From end April 2023, the runtime will no longer be free, you will need to purchase a subscription to get access to ...

Have you looked at CellValueN?
Probably the right function to use:
https://www.ibm.com/docs/en/planning-an ... cellvaluen

If you have ever needed to copy a tab from one PAW book to another, please read this article on the IBM Community. It describes how to locate the necessary source JSON and how to insert it into the target book. This obviously saves a whole lot of time needed to recreate the tab as well as reducing t...

An update on this one. I got a response from Sami that DBR and DBRA are identical in PAfE (REST API world).

Documentation has also recently been updated to reflect that they are identical and both effectively WAN-optimised.

Think I had something similar and ended up adding this along with the HierarchyElementSecurityPut statements iirc:

A couple of things here but the main one is that your apostrophe should be after the month number and before the pipe, not after the year.

Edit: Also best to do meta data updates in meta data otherwise you may rather want to look at the Direct commands for your inserts.

I am thinking that you may have found a use-case for TM1TupleSize!

I have used M_Clear in macro code previously but has some additional erratic behaviour like suddenly having your connection close.

Hopefully someone else has a better alternative…

What happens if you create the new sets, close Perspectives and Excel then open and connect again?
Could be a meta data sync issue where new objects are not available/recognized.

... Note: Difference between DBR and DBRW in PAX: "DBRW works the same as the DBR function, with one major difference; DBRW reduces network traffic and may improve performance on wide area networks. ... https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wf-dbrw Not sure I agree with th...

For my case, we wanted to avoid having users copying things around. I guess we could have also created a script that does the copy of the necessary files to the relevant folder. Still in testing so final deployment may change. In terms of your questions: 1) Best place for the add-in - we rename the ...

You are in luck John - I happened to create a script this morning to assist with some of this: Create a .bat file with the following: @echo off REM --Create folders if needed IF NOT EXIST "%localappdata%\Cognos\Office Connection" ( Echo Creating folders... mkdir "%localappdata%\Cognos...

Thanks for the notification-added my vote and 2c

Another approach to consider is using Expand() - This makes these MDX queries easier to read by limiting all the quotes needed: vMDX = Expand('{FILTER(TM1SubsetAll([vDimension1].[vDimension1]), ([vDimension1].[vDimension1].CURRENTMEMBER.PROPERTIES("vAttribute1") = "%vValue%")}');

Steve Rowe wrote: ↑Fri Jan 20, 2023 8:27 amsigh.....

In the meantime you can hone your DefineCalc and TM1Set skills!
(AFAIK TM1Set only supported on local)
DefineCalc Reference
TM1Set Reference