TM1 Forum

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.

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

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

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

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

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

Pretty sure this would return the same. Childless consolidations still evaluate as level 1 and not level 0.

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?

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

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

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.

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

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

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

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

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

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

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

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

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