Search found 415 matches

by BariAbdul
Wed May 30, 2018 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rules file and sparsity alogrithm
Replies: 3
Views: 342

Re: Empty rules file and sparsity alogrithm

Thanks Tomok. My bad ,I was thinking "even an empty rule file switches sparsity algorithm on". Thanks again for the clarification.
by BariAbdul
Wed May 30, 2018 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rules file and sparsity alogrithm
Replies: 3
Views: 342

Empty rules file and sparsity alogrithm

I have come across interesting comment " Even an empty rule file switches sparsity algorithm off?" and it is emphatically written as Yes.But on the similar vein when although feeders are written but skip check is forgotten, the feeders are ignored silently and rules are being evaluated for every cel...
by BariAbdul
Wed Mar 28, 2018 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where to learn the business concepts of the budet and planning
Replies: 4
Views: 663

Re: Where to learn the business concepts of the budet and planning

If you are looking for source for fundamentals of accounting, there is a new book by TM1 guru Martin Ryan:

https://lnkd.in/fSaEZR9 Thanks
by BariAbdul
Fri Mar 16, 2018 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }CellSecurity
Replies: 8
Views: 911

Re: }CellSecurity

Hi ,It is basically a control cube, please go through below links for further details: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.prfmdl_ug.10.2.2.doc/t_prfmdl_creating_cell_security_cube.html https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ib...
by BariAbdul
Tue Feb 13, 2018 6:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 dimension elements not appearing in Cognos Report Studio
Replies: 3
Views: 706

Re: TM1 dimension elements not appearing in Cognos Report Studio

Please go through below Tech note, it basically talks about what Paul has advised you.

https://www.ibm.com/support/knowledgece ... n2835.html Thanks
by BariAbdul
Wed Jan 24, 2018 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What are TM1 Rules Capabilities?
Replies: 6
Views: 668

Re: What are TM1 Rules Capabilities?

And for most complex part, that is Feeders, please read this document:
https://www.ibm.com/developerworks/data ... ge620.html Thanks
by BariAbdul
Thu Dec 21, 2017 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders - not fed
Replies: 2
Views: 443

Re: Feeders - not fed

Just came across very good article on Feeders, please go through it:
https://code.cubewise.com/blog/how-to-f ... and-fix-it Thanks
by BariAbdul
Sun Dec 17, 2017 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- Cell Background Color Change
Replies: 3
Views: 410

Re: TM1 Web- Cell Background Color Change

If it is a active form or slice TM1 supports conditional formatting for a criteria : https://www.ibm.com/support/knowledgecenter/SS9RXT_9.5.0/com.ibm.swg.im.cognos.tm1_wb.9.5.2.doc/tm1_wb_id868ConditionalFormatting_N10064D.html But other than that, the default behavior is not editable/rules driven c...
by BariAbdul
Fri Dec 15, 2017 1:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Read Lock on CSV Source File
Replies: 3
Views: 494

Re: TI Process Read Lock on CSV Source File

Have you checked the log files,What does it says? There is similar issue here, might help:
http://www.tm1forum.com/viewtopic.php?t=13433 Thanks
by BariAbdul
Fri Dec 01, 2017 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: unwinding certain elements issue
Replies: 10
Views: 1067

Re: unwinding certain elements issue

Might be not exactly what you looking for ,but along the similar lines,might help:
http://www.tm1forum.com/viewtopic.php?f=3&t=13716 Thanks
by BariAbdul
Wed Nov 22, 2017 12:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube not showing data in Analysis/Report studio
Replies: 6
Views: 855

Re: TM1 cube not showing data in Analysis/Report studio

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...
by BariAbdul
Sat Oct 21, 2017 3:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of Accounts for each agency
Replies: 2
Views: 508

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Negligible value in consolidation
Replies: 2
Views: 524

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combined TI Processes in Chore
Replies: 1
Views: 399

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 786

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: fileexists and dimensionexists
Replies: 8
Views: 786

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding elements in dimesnion using TI
Replies: 3
Views: 494

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