Search found 3129 matches

by lotsaram
Thu Jul 18, 2019 6:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create temp view and open them by returnviewhandle
Replies: 3
Views: 181

Re: Create temp view and open them by returnviewhandle

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...
by lotsaram
Tue Jul 16, 2019 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 4767

Re: Export Cube data in CSV file, with all Months as columns

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...
by lotsaram
Tue Jul 16, 2019 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 301

Re: PAW Button does not give RUN Process option

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 ...
by lotsaram
Wed Jul 10, 2019 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 220

Re: Sandboxes in Dynamic Reports?

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...
by lotsaram
Tue Jul 09, 2019 6:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 17
Views: 3066

Re: Updating Element Attributes in TI Process

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...
by lotsaram
Wed Jul 03, 2019 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour when value set to MaximumPorts in }clientProperties
Replies: 4
Views: 286

Re: Strange behaviour when value set to MaximumPorts in }clientProperties

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...
by lotsaram
Wed Jul 03, 2019 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 8915

Re: difference between prolog, metadata, data, epilog

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...
by lotsaram
Thu Jun 27, 2019 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 6
Views: 454

Re: Use subsets in DBRW

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.
by lotsaram
Thu Jun 27, 2019 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

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...
by lotsaram
Wed Jun 26, 2019 4:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

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...
by lotsaram
Mon Jun 24, 2019 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

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...
by lotsaram
Mon Jun 24, 2019 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 500

Change to DimensionElementComponentAdd in PA vs 10.2?

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...
by lotsaram
Tue Jun 18, 2019 8:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 2
Views: 139

Re: Dimension Order in an MDX cube view as datasource

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.
by lotsaram
Mon Jun 17, 2019 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Replace Columns with Element Attributes
Replies: 5
Views: 153

Re: PAW Replace Columns with Element Attributes

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...
by lotsaram
Mon Jun 17, 2019 5:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 486

Re: RunTI Issue

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...
by lotsaram
Thu Jun 13, 2019 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 271

Re: TI views using alternate hierarchies

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...
by lotsaram
Tue Jun 11, 2019 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 10
Views: 1265

Re: TM1 Perspective Vs Pax

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...
by lotsaram
Tue Jun 04, 2019 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - TM1 - Security
Replies: 5
Views: 211

Re: Planning Analytics - TM1 - Security

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.
by lotsaram
Tue Jun 04, 2019 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 296

Re: Method for handling Rules for Actuals/Forecast periods

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...
by lotsaram
Tue Jun 04, 2019 7:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 486

Re: RunTI Issue

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