Search found 3065 matches

by lotsaram
Fri Feb 22, 2019 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads
Replies: 6
Views: 577

Re: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads

There are 4 parameters here (actually some extra related ones for fine tuning as well but the documentation doesn't really explain what they do e.g. IndexStoreDirectory, PreallocatedMemory.Size, PreallocatedMemory.BeforeLoad) MTQ MTCubeLoad MTFeeders MTFeeders.AtStartup Without MTQ enabled as a prer...
by lotsaram
Thu Feb 21, 2019 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads
Replies: 6
Views: 577

Re: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads

To try and keep the explanation as brief as possible MaximumCubeLoadThreads=N would release N threads at once, each one loading a separate cube. As cubes are not uniform in size and each thread finished at a different time then goes onto the next cube this means the order of processing cannot be con...
by lotsaram
Thu Feb 21, 2019 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget planning model with dynamically shifting costs
Replies: 6
Views: 115

Re: Budget planning model with dynamically shifting costs

... my preference would be to resolve it with users inputting directly to the cube with period/year dimensions in it and utilising MDX and/or a dynamic websheet to only show them the relevant ranges for their projects. But this is precisely what you can't do for the reasons the OP described. Start ...
by lotsaram
Thu Feb 21, 2019 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 7
Views: 140

Re: Temp View difference to Perm Views

In my opinion the original implementation of temporary objects being only available to the immediate process which created them is seriously flawed and constitutes a product defect. Temporary subsets & views being only available to the TI creating them excludes the possibility of a functional librar...
by lotsaram
Wed Feb 13, 2019 6:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is vcsch.log ?
Replies: 2
Views: 244

Re: What is vcsch.log ?

I'm guessing you have Pulse installed? On install Pulse modifies or creates the tm1s-log.properties file to create this separate log file where GlobalCollection, File & System loggers are monitored. It is managed in a separate log file to not pollute the default tm1server.log file. Pulse monitors th...
by lotsaram
Tue Feb 12, 2019 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Location of the file accessible from the Cognos TM1 server
Replies: 3
Views: 167

Re: Location of the file accessible from the Cognos TM1 server

To get everything running error free you need a common location that is visible from both the client and the server, often the paths will be different. I find it easier to think of DatasourceNameForClient as what is used for the sole purpose of populating the preview window and setting the variable...
by lotsaram
Mon Feb 11, 2019 9:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 311

Re: How to get top parent of an element ?

macsir wrote:
Mon Feb 11, 2019 9:10 pm
Looks like Ascendants only returns all parents in the first rollup?1.PNG2.PNG
Yes seems to be the case. I just checked with Ancestors function and seems to be the same restriction.
by lotsaram
Mon Feb 11, 2019 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 311

Re: How to get top parent of an element ?

I think there is a pretty easy way to get your result via MDX E.g. {Tail( {Ascendants([Dimension].[Hierarchy].[Element])}, 1 )} In TM1 an element may have multiple parents within a hierarchy so if there are multiple parent branches you may need the intersect between the ancestors and all top node el...
by lotsaram
Thu Feb 07, 2019 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 10
Views: 195

Re: TM1 Server crash on saving dimension (status Suspended)

This is common when using the Architect dimension editor with a v11 server. Especially if the dimension has alternate hierarchy.
by lotsaram
Mon Feb 04, 2019 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to calculate AvergaeFYTD Rate
Replies: 2
Views: 78

Re: Rule to calculate AvergaeFYTD Rate

This would appear to be a near perfect example of how (for a linear time dimension) custom consolidations with weightings would be a much more efficient design choice for such calculations. Indeed if my cube didn't have a linear time dimension I would go so far as to have a helper calculation cube o...
by lotsaram
Mon Feb 04, 2019 10:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Administration agent
Replies: 3
Views: 111

Re: Planning Analytics Administration agent

Much like the CAM option in the latest TM1 Cognos Configuration this appears to be a half-built feature that (at least for on-premise) doesn't do anything yet.
by lotsaram
Thu Jan 31, 2019 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 189

Re: PAW: cannot enter into a consolidation

Can you remember the creation sequence that led to this? In theory every N level should end up in the leaves hierarchy, if this is not reliable then this is a bit of an issue.. Absolutely agreed! I have also seen this happen. The behaviour of the Leaves hierarchy should be “maintenance free” for ad...
by lotsaram
Thu Jan 31, 2019 9:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Views_* and }Subsets_* control dimensions
Replies: 5
Views: 119

Re: }Views_* and }Subsets_* control dimensions

True. On the other hand, we should review existing code too when there is a loop over elements in the dimension }Dimensions, since hierarchies can be part of that list too. We should make sure that everything translates well in the case of names like dim:hier instead of dim. With an entire library ...
by lotsaram
Wed Jan 30, 2019 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Views_* and }Subsets_* control dimensions
Replies: 5
Views: 119

Re: }Views_* and }Subsets_* control dimensions

The }Views_ }Hierarchies_ & }Subsetts_ control dimensions have been there right from PA 2.0 However be aware that in 2.0.6 IBM changed how }Subsets_ dimensions are implemented . It is a change for the better, but if you had already developed tools based on the old structure then still a pain to upda...
by lotsaram
Sun Jan 27, 2019 7:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel data loads and TM1runTI, Hustle
Replies: 3
Views: 616

Re: Parallel data loads and TM1runTI, Hustle

For example, that Hustle would start number 11 after that any of the first 10 calls to TM1runti finishes. That would also happen in a situation where I call TM1runTI 50 times in the Prolog of a process, no ? But I understand that Hustle would make sure that all 10 cores are used efficiently ? Well ...
by lotsaram
Sun Jan 27, 2019 7:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Element Insert
Replies: 10
Views: 519

Re: Subset Element Insert

I have tried this as well before but got an error saying "Dimension element not found in dimension". I had to move the subsetElementInsert to the data tab coz of the error and it works only in the data tab. This is expected. You need to lean what happens on each tab of a TI process. In particular a...
by lotsaram
Fri Jan 25, 2019 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel data loads and TM1runTI, Hustle
Replies: 3
Views: 616

Re: Parallel data loads and TM1runTI, Hustle

Have you read the 1 page documentation at https://github.com/cubewise-code/hustle ? I am a big fan of hustle, but hey what do you expect :) Hustle just makes it really easy to manage executing lots of TI threads in parallel in a well managed way. All you do is pass to hustle 2 parameters i) the addr...
by lotsaram
Wed Jan 23, 2019 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passport Advantage Online for customers
Replies: 2
Views: 310

Re: Passport Advantage Online for customers

This depends on which model you purchased the software. If you purchased under the "SPP" model (Support-Providing-Partner) then the customer will not have direct access to download software via Passport Advantage nor to directly raise support tickets. As under the SPP model these services are provid...
by lotsaram
Mon Jan 14, 2019 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2951

Re: TM1 REST API

Hi @bgregs Sorry I didn't mean to shout you down. I have no problem with being direct and opinionated. I am famously blunt myself. :oops: And I have no issue with difference of opinion, that's healthy. It's just that in this instance I felt something needed to be said as my (and others) actual exper...