TM1 Forum

There are many other limitations of Temporary Views and subset, the biggest limitation i find is that their scope is only within the process where they get created, it would be nice if they extend the scope to the thread that created them (if you have a batch TI and you execute multiple TIs, then i...

I am using ASCIIOutPut and I want months on columns. I am using the cellgetn to get each month from january from december, but when I use the asciioutput the value of a data point of january for example, cames 12x on rows instead of one. I didn't get what you have done about using flag and the tota...

To add to Wim's point - the ability to run processes from buttons in Workspace only got added in PAW 39 which was released in March. The ability to automatically refresh a book after completion of a process, rumored to be coming in PAW 44. The ability to pass context of SUBNM selections to process ...

Hi Garry Many thx. What else is on your list RE pax not ready to replace Perspectives. Regards Chris Mine might include * Annotations * Spreading * Dynamic reports not supporting alternate hierarchies * Performance not always being equal or better vs. Perspectives on LAN * UDCs * Stability PAX is p...

SubsetMDXSet This function removes the MDX expression from a dynamic subset and converts the dynamic subset to a static subset without locking the underlying dimension. This is just an example of really bad documentation (written no doubt by a professional in this area but someone who has never act...

I don't think it's strange behaviour. It depends on how your Rest based web application is built. The Rest API can handle asynchronous requests from a single user. Although there may be one authentication (logon) the cookie can be reused and separate worker threads initiated for different actions (e...

Love a bit of thread necromancy. For example in the prolog tab you can add an element for allocations. In the Data tab you can process data on the element and in the Epilog tab you cannot delete the element. Therefore you need to have the Prolog tab of a second process to do it. Well you should be a...

User Defined Consolidations aren't supported in PAX. So you can't use a subset name as a pseudo-consolidation. You need to use an actual consolidation.

I'm thinking of testing whether the Dimsiz of 'Hierarchies_' | vDim exceeds 2 or not. vDim is the dimension to be investigated. If > 2, it will involve additional logic. What do others think ? I would create a temporary dynamic subset with MDX Expand('{TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Dimension...

The first one (automatic insert of element with implicit type N where component not known) appears to be a regression bug. It was reported in 2.0.1 and subsequently fixed, so my guess is this will also be fixed again in 2.0.7. The 2nd case, as far as I know will only happen in the case of dimensions...

if DimensionElementComponentAdd is used to add a child to a leaf element (which should change the leaf to consolidated), we get an error. I was almost sure this was not the case in the more distant past Yes definitely that used to work. (Not actually a good thing given that converting elements from...

In the latest TM1 server version 11.5.00000.23 we have detected a change in the behaviour of the TurboIntegrator function DimensionElementComponentAdd. In previous versions if the element supplied as the component to DimensionElementComponentAdd did not already exist in the dimension then it would b...

Is the cube re-ordered ("optimized") in the order of the variables?

• HRLevel

• Period

• Adjustments

• Measure

• Org

It then wouldn't be correct how the variables are being ordered, but it would offer an explaination.

The screenshot you attached looks like it is from the dimension administration (in which case it will work fine on a sheet in a book but only for administrators and not end users). In Perspectives you could just create a view of the }ElementAttributes cube but in Workspace control objects aren't acc...

When loading data to a cube in multiple parallel threads, I always use BatchUpdateStart; and BatchUpdateFinishWait(0); to avoid locking and to speed up the load process. In this case, all commits waits until all parallel threads finish processing and reaches to BatchUpdateFinishWait(0);. Then all o...

Alternate hierarchies don't work with trad views (and never will). AFAIK if the source of a TI is "subset" then this works just fine with an alternate hierarchy. You just need to set DatasourceNameForServer = 'dimension:hierarchy' So if you want to use hierarchies in a view as a source for TI then y...

Rule & TI editor is not coming to PAX. The home of all developer & administrator functionality will be in PAW. "The Undo capability to revert data entry changes is currently not implemented in Planning Analytics for Microsoft Excel" Do the above apply to the web? PAX (as Perspectives) is just the au...

Peter Picazio wrote: ↑

Tue Jun 04, 2019 1:37 am

This user is only is this specific group, no others.

With all due respect, this categorically can't be the case. TM1 security is cumulative so the rights to the elements must be coming from another group the user belongs to.

If the forecast periods will actually be data input (either direct or loaded from external system) versus rule calculated then also consider not having a rule at all and just using cell security to ensure actuals are read only. Although I'm a big fan of rules, any time you can avoid rules and use in...

Hi mce, Although RushTI may assist vs tm1runti by eliminating the overhead for authentication for each separate process execution I think you also really need to consider the design of the data-splitting. Both the number of distinct slices the load is split to and the dimension being used to segment...