Search found 3079 matches

by lotsaram
Thu Mar 21, 2019 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LEN works in Architect, not PAW
Replies: 5
Views: 97

Re: LEN works in Architect, not PAW

But don't forget that member properties are explicitly strings and TM1's MDX implementation doesn't allow type recasting. So if you want to treat the value as numeric then you need to query the ElementAttributes cube not get the member property.
by lotsaram
Tue Mar 19, 2019 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 676

Re: Does anyone know how to run 2 PAW instances on same server?

Out of curiosity. Why would you want to? Well load balancing ... Horizontal scaling is a key advantage of containerization. And the containerization of Docker is the whole point of IBM going this route. It does seem a bit remiss that (at this point) there isn't any documentation from IBM on how to ...
by lotsaram
Fri Mar 08, 2019 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

Hi Lotsaram I am probably too stupid to realise that it couldn't be done and just went ahead and did it since it seemed like a logical thing to be able to do. Anyway, I suggest you try an experiment yourself to confirm it. Regards Paul Buried away (not in the release notes, mind you but buried in t...
by lotsaram
Fri Mar 08, 2019 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Replies: 10
Views: 1291

Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly

I think you might be getting mixed up with ItemReject. AFAIK LogOutput should not cause any minor error status (in fact would be pretty bad if it did).
by lotsaram
Wed Mar 06, 2019 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to move Active forms from one server to another server manually
Replies: 8
Views: 659

Re: Unable to move Active forms from one server to another server manually

Hi Folks , How can i use server instance reference in active forms . any idea . i couldnt use Tm1server& in place of server instance name in active form . any suggestions ? The method described in this post is a pretty common way of setting up workbooks/websheets to automatically set the server nam...
by lotsaram
Wed Mar 06, 2019 9:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 203

Re: REST API: consolidated elements without children

@Wim I'm kinda surprised that the first query works! {Filter( TM1FilterByLevel( TM1SubsetAll([test]), 1), ISLEAF( [test].CurrentMember ))} That I think would have to be a bug in the MDX engine or interpretation of what a "leaf" is (that is a numeric element). A consolidation without children can't s...
by lotsaram
Tue Mar 05, 2019 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 203

Re: REST API: consolidated elements without children

Pretty sure this would return the same.

Code: Select all

FILTER(TM1FILTERBYLEVEL( TM1SUBSETALL( [test2]), 1), TM1TUPLESIZE( ([test2].currentmember.children).ITEM(0)) = 0)
Childless consolidations still evaluate as level 1 and not level 0.
by lotsaram
Mon Mar 04, 2019 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA and TM1RUNTI separately from installation
Replies: 2
Views: 271

Re: PA and TM1RUNTI separately from installation

When you say "separate from installation" I assume you mean you have moved the tm1runti.exe to a different folder. Is this correct? Possibly in v11 there is a new dll dependency which you haven't copied across?
Have you tried using dependency walker to check if you have all the required dlls?
by lotsaram
Wed Feb 27, 2019 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 8
Views: 248

Re: Manage Rights when a big chunk of elements are deleted

It takes about an hour for SecurityRefresh normally. On PA 2.0.4 and 2.0.6, it takes about 1.5 hours. Oh my! I have worked on some pretty huge models (and talking security not just data; thousands of users, thousands of groups) but I have never seen SecurityRefresh take longer than about 5 - 10 min...
by lotsaram
Wed Feb 27, 2019 9:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to get the Data Directory Location in TI?
Replies: 21
Views: 3226

Re: Is there a way to get the Data Directory Location in TI?

On a related note: does anyone use multiple data directories for 1 model ? We can specify multiple folders in the crg file but I have never been a fan of it. I don't often use it but I actually think it's a good idea for things like frameworks or modules that are common to multiple TM1 models. It m...
by lotsaram
Wed Feb 27, 2019 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to get the Data Directory Location in TI?
Replies: 21
Views: 3226

Re: Is there a way to get the Data Directory Location in TI?

You can also use relative file paths where the data directory will simply always be "."

This is however not 100% foolproof if cd is ever done in the cmd prompt by the system user that the TM1 service is running under.
by lotsaram
Mon Feb 25, 2019 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

We are using PA 2.0.5. My understanding is that a temp view created in a master process is available to any process called by that process. We have a case here where we use a generic process to transfer data from one cube to another. The calling process first uses a temp view to clear existing data...
by lotsaram
Mon Feb 25, 2019 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 442

Re: Temp View difference to Perm Views

I have found that a temporary subset is not available to a subsequent MDX query within the same TI. In that case, the first query has be a permanent subset and is removed in the Epilog. You mean using one subset as the base set for another? As in either ... {FILTER( [Dimension].[Temp Subset], filte...
by lotsaram
Sun Feb 24, 2019 2:00 pm
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 12275

Re: Clear TM1 Formulae from Excel

If the report is delivered via PDF then why go to the bother of just hard-coding TM1 references, why not just hardcode everything ? (Pseudo code) Sheet.UsedRange.Copy Sheet.UsedRange.PasteSpecial Paste:=xlPasteValues If only sheets and not cells are being iterated then it's going to be a hell of a l...
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: 8
Views: 870

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: 8
Views: 870

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: 7
Views: 245

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: 14
Views: 442

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: 288

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: 210

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