Search found 402 matches

by BariAbdul
Sat Oct 21, 2017 3:48 am
Forum: Cognos TM1
Topic: Count the number of Accounts for each agency
Replies: 2
Views: 246

Re: Count the number of Accounts for each agency

Please go through the MDX primer.doc for detail explaination of MDX functions with context to TM1. Thanks
by BariAbdul
Thu Oct 19, 2017 8:36 am
Forum: Cognos TM1
Topic: Negligible value in consolidation
Replies: 1
Views: 90

Re: Negligible value in consolidation

Have you tried formatting the numbers:
https://goo.gl/PT54d8 Thanks
by BariAbdul
Sat Sep 30, 2017 7:11 am
Forum: Cognos TM1
Topic: Combined TI Processes in Chore
Replies: 1
Views: 194

Re: Combined TI Processes in Chore

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
by BariAbdul
Wed Sep 20, 2017 1:40 pm
Forum: Cognos TM1
Topic: fileexists and dimensionexists
Replies: 8
Views: 237

Re: fileexists and dimensionexists

You could get further info regarding LogOutput here:
https://everanalytics.wordpress.com/201 ... ognos-tm1/ Thanks
by BariAbdul
Wed Sep 20, 2017 11:30 am
Forum: Cognos TM1
Topic: fileexists and dimensionexists
Replies: 8
Views: 237

Re: fileexists and dimensionexists

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...
by BariAbdul
Wed Sep 20, 2017 11:07 am
Forum: Cognos TM1
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 144

Re: adding elements in dimesnion using TI

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....
by BariAbdul
Thu Aug 17, 2017 5:16 am
Forum: Cognos TM1
Topic: Data Tab (TI)
Replies: 2
Views: 577

Re: Data Tab (TI)

The problem, I guess is here;
IF(vt_months@>vMonthActual);
Think ,what are you doing here.Thanks
by BariAbdul
Mon Aug 14, 2017 6:03 am
Forum: Cognos TM1
Topic: Fresher..Rules & Feeders
Replies: 9
Views: 815

Re: Fresher..Rules & Feeders

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...
by BariAbdul
Sun Aug 13, 2017 1:16 am
Forum: Cognos TM1
Topic: Fresher..Rules & Feeders
Replies: 9
Views: 815

Re: Fresher..Rules & Feeders

by BariAbdul
Wed Jul 26, 2017 12:02 pm
Forum: Cognos TM1
Topic: TM1 Performance Tips
Replies: 1
Views: 281

Re: TM1 Performance Tips

Thanks a lot, tiagoblauth79.It will definitely help.
by BariAbdul
Fri Jul 14, 2017 3:20 am
Forum: Cognos TM1
Topic: TM1 Object dependency walker- get list of all dependent objects
Replies: 4
Views: 521

Re: TM1 Object dependency walker- get list of all dependent objects

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
by BariAbdul
Tue Jun 13, 2017 2:48 am
Forum: Cognos TM1
Topic: Time dimension, alternate drill-down path
Replies: 7
Views: 549

Re: Time dimension, alternate drill-down path

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
by BariAbdul
Sat Jun 10, 2017 5:56 am
Forum: Cognos TM1
Topic: Assigning string value in a rule
Replies: 8
Views: 512

Re: Assigning string value in a rule

Could you please post you whole rules including feeders statement. Thanks
by BariAbdul
Fri May 19, 2017 12:04 pm
Forum: Cognos TM1
Topic: TI Process Error
Replies: 11
Views: 1049

Re: TI Process Error

I have MyVariable which is the dimension that has unique id per invidivial record
Shouldn't MyVariable be element name? Thanks
by BariAbdul
Wed Mar 15, 2017 7:37 am
Forum: Cognos TM1
Topic: fact table
Replies: 3
Views: 384

Re: fact table

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...
by BariAbdul
Sun Feb 26, 2017 6:59 am
Forum: Cognos TM1
Topic: Managing user security assignments in Cognos TM1 Application
Replies: 6
Views: 575

Re: Managing user security assignments in Cognos TM1 Application

You could find what lotsaram has mentioned in this thread:

http://www.tm1forum.com/viewtopic.php?t=7694 Thanks
by BariAbdul
Fri Feb 24, 2017 4:33 am
Forum: Cognos TM1
Topic: Combine multiple cubes and re-number
Replies: 5
Views: 600

Re: Combine multiple cubes and re-number

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