TM1 Forum

I'm testing TM1's 10.2.2 FP1 undocumented SubsetMDXSet function ( see http://www-01.ibm.com/support/docview.wss?uid=swg27042401 ) and thus far cannot get it to function as documented: ### total_lvl_0_w_alias vDim = 'Legal_Entity'; vMdx = '{[legal_entity].[Total Company],TM1SORT( {TM1FILTERBYLEVEL( ...

Just for sure, try switching off persistent feeders and recycle your test.
Regards
Petr

Hi I would think that if the data source is odbc or txt or another cube, and Process B does not use any data from the target cube's S1 slice then it should work, but this is just an assumption, I have only ever used batch update in a master process when on its Data tab I went through the }Cubes dim...

When you change an element from leaf to consolidated (in either direction) you are essentially deleting the leaf element and creating new consolidated element. There was a bug in 10.1 where the direct dimension edit TI functions did not correctly implement this. Would you really want cube data to p...

Hello, Have you ever noticed that when adding an N-element to different N-element (future parent) to form a consolidation (thus altering the future parent element from N to C "automatically") will cause loss of attributes on the future parent element? I believe this method worked fine in v...

Hi It is ok to use as long as in the second child TI you do not reference results from the first child TI So if the executed TIs are independent from each other, this should work. If TI 1 writes a value to a cell that TI2 reads then, I assume it won't work. Thank you mvaspal! The above seems logica...

Hello, Is it ok to use BatchUpdateStart and BatchUpdateFinishWait in a master process that calls several child processes? Or is it necessary to put them in each of child process? When using batch updates in master process I get inconistent results in target cubes for each child process. Thanks for h...

There was a feature put in that SubsetCreateByMDX could take an additional argument of the dimension name to apply the subset definition to if the MDX didn't return any elements. It was put in about 2 to three years ago and I think it's in 10.1.? but definitely in 10.2. It hadn't been documented wh...

My approach is to always make sure the MDX does not return an empty set by always glueing a "dummy" element at the end of the MDX statement. This dummy could be a consolidation that you can later filter out or just an unused element, whatever works in that particular case. Then once the s...

It's good to be aware of this as some MDX functions might be affected as well - for example ORDER function in MDX is not picking up aliases "populated" by default. The point is that TM1 engine uses element principal name whenever alias value for that element is technically empty in given }...

Cube logging must be switched on if you want the replication to be working. Cube logging switched off will simply end-up in not copying the data by replication. Replication relies completely on cube logs and timestamps of changes. I won't agree with avoiding replication, but I agree it has some pitf...

Although very outdated thread - I was recently solving the same issue. It turned out that problem is not ORDER function at all, but rather problem in alias (attribute) values. Check your }ElementAttributes cube for the dimension and refer to the alias you want to use for sorting. The alias values ar...

ending support for the rules editor, but no mention of its replacement. if we are going back to the basic editor only thats the clearest indication yet about how little they now care about the core product. Well, literally taken they are just ending support, but who knows what it does exactly mean....

Just for sure - if you will use replication in your model against star server, you should have cube logging turned on on each star cube that is being replicated to your planets. The point is that replication of data is based on cube logs / timestamps. I think it is necessary to have cube log turned ...

Hi, refer to TM1Web URL API documentation. You can use redirect in login page, so setting redirect address to address of you report might work. It might be even your own custom login page that will supply all possible credentials data to TM1. Consider this javascript piece of code that might be used...

Hi, the utility has its parameters for logging a CAM user and these are kept outside username parameter, so first I would exclude "CompanyT\" from the username. I think for logging-in you should use username you can see in }Groups dimension under alias }TM1_DefaultDisplayValue. CAMNameSpac...