TM1 Forum

As you aware of underfeeding gives incorrect data ,so that could be one of the possible reasons. Are you sure that the data in the cube is correct,btw. other suggestion is to build your report (crosstab, chart etc) using the required dimensions, then from each of the other unused dimensions select a...

Please go through the MDX primer.doc for detail explaination of MDX functions with context to TM1. Thanks

Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks

There could be plenty of reasons to look in to, firstly, check the dependency of the processes, whether it is causing any locking , also, suggest checking log file for messages at the time of crash ,also worthwhile to check the event manager on windows server. Thanks

You could get further info regarding LogOutput here:
https://everanalytics.wordpress.com/201 ... ognos-tm1/ Thanks

Have you defined the path correctly in the TI : FileExists('C:\tm1s7\pdata\model.dim'); And created a wapper process to perform the evaluation in the PROLOG: IF(FileExists('FILENAME') =1); ExecuteProcess('Load Process Name Here'); ELSE; ProcessQuit; ENDIF; As for the second part: This feature can be...

Hi Please go through below functions,It will give you an idea: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_ref.10.2.2.doc/c_dimensionmanipulationturbointegratorfunctions_n71607.html#DimensionManipulationTurboIntegratorFunctions_N71607 http://public.dhe.ibm....

Please go through below post:

http://www.tm1forum.com/viewtopic.php?t=11139 Thanks

Try this,It might help:
http://www.wimgielis.com/tm1_copydataonelement_EN.htm

http://www.tm1forum.com/viewtopic.php?t=1767 Thanks

The problem, I guess is here;

IF(vt_months@>vMonthActual);

Think ,what are you doing here.Thanks

Valid elements like for example Total Year or All Years or whatever you call them, will be put instead of the ??

Nope.
I tried, its pass a consolidated value..... Which incorrect.

What Wim has advised you is the way to do in your case. You must have been doing something incorrectly...

This might help:
http://www.tm1forum.com/viewtopic.php?t=4252 Thanks

Thanks a lot, tiagoblauth79.It will definitely help.

I don't know how much it going to help you ,but worth having a look at this thread:
http://www.tm1forum.com/viewtopic.php?f ... ram#p58483 Thanks

Also,Please go through Wim article on relative time dimension,It might give you some ideas:
http://www.wimgielis.com/tm1_relativeti ... ons_EN.htm Thanks

Could you please post you whole rules including feeders statement. Thanks

I have MyVariable which is the dimension that has unique id per invidivial record

Shouldn't MyVariable be element name? Thanks

I honestly don't know what you are asking here.Fact table is one of the data warehousing concept which holds the measures or metrics,Similarly we have measure dimension where we usually have measures and it is mostly last dimension of the cube.Other than that,Please elaborate your question ,which is...

You could find what lotsaram has mentioned in this thread:

http://www.tm1forum.com/viewtopic.php?t=7694 Thanks

Personally,I would prefer option1,Anyway please look at below links for further information on power shell and stored procedures with respect to TM1 :

http://www.tm1forum.com/viewtopic.php?t=12453
https://everanalytics.wordpress.com/201 ... rocedures/ Thanks