Search found 327 matches

by rkaif
Sun Oct 20, 2013 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Audit Log reports
Replies: 7
Views: 6496

Re: TM1 Audit Log reports

The Audit log file name has the Date/Time Stamp. You can store this value in a control/Lookup cube and each time you refresh the cube then you check this value in the Lookup cube. If the Log file name is less then the Date/Time in the control cube then you simply ignore that file into the cube. Each...
by rkaif
Sun Oct 13, 2013 12:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel report issue in TM1
Replies: 2
Views: 925

Re: Excel report issue in TM1

Try this formula:

Code: Select all

SUBNM("pftm1serv:Account_PF","AccMgr_Fox","Andrea_Underhill")
by rkaif
Sat Oct 12, 2013 6:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel reports and TM1 Web
Replies: 3
Views: 1283

Re: TM1 Excel reports and TM1 Web

As per the formula (SUBNM)when filter the elements can able to pic the elements only which are available in the dimensions ,elements which are not in the dimensions will not pic and display the elements in the report throw the error First of all can you explain that how can you select a element in ...
by rkaif
Sat Oct 12, 2013 6:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Slice vs ISB vs Active Form vs Cube Viewer
Replies: 3
Views: 1329

Re: Performance of Slice vs ISB vs Active Form vs Cube Viewe

Are you using DBRW() or DBR() formulas in the Excel?

If you are using the DBR() then you may hit performance issues because of the nature of the DBR() function which process each cell individually.
by rkaif
Sat Oct 12, 2013 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Audit Log reports
Replies: 7
Views: 6496

Re: TM1 Audit Log reports

Please advice for automated method to create audit log reports for users login (Success/Fail). Is there any best practice to generate reports from audit log files using TI or any other method? I Found it a little bit problematic to automate this task as: 1. The audit log files format is not complet...
by rkaif
Thu Oct 10, 2013 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Picklist access in protected Excel 2007 worksheet
Replies: 8
Views: 3678

Re: Picklist access in protected Excel 2007 worksheet

As soon as I protect the worksheet, I lose the dropdown functionality on the cells that have the Picklist DBRW formulas in them These particular cells have been unlocked so one would assume that the drop down functionality would be available even if the worksheet has been protected Has anyone exper...
by rkaif
Thu Oct 10, 2013 6:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Questions about Perspectives & Active Forms
Replies: 3
Views: 1277

Re: Questions about Perspectives & Active Forms

3 - When I want to lock the page to protect certain fields. It seems that picklists are no longer usable, they give some vba error and stop working. Is there a fix for this? Instead of using the Excel protection put your DBRW formula into some Excel formula e.g. =SUM(DBRW(x,y,z...)) This is a known...
by rkaif
Wed Jun 05, 2013 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Operations Console Installation issue
Replies: 0
Views: 457

TM1 Operations Console Installation issue

There is a bug in 64-bit TM1 10.1.1 Operations Console installation in Windows enviornment. The TM1 Operations Console will not work if TM1 Admin Server is using non-default ports. According to IBM support the fix of this bug will likely not be available as a patch for version 10.1.1, but most likel...
by rkaif
Wed Oct 10, 2012 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding Link to Tm1Web to send the link
Replies: 2
Views: 2102

Re: Adding Link to Tm1Web to send the link

TM1 comes with a Custom URL API, if you use it will be very simple to create the URLs for you Cube Views. See this link: http://publib.boulder.ibm.com/infocenter/ctm1/v9r5m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.tm1_dg_dvlpr.9.5.0.doc%2Ftm1_dg_dvlpr_id8544DevelopingCustomWebApplicationswitht.html...
by rkaif
Thu Sep 27, 2012 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button Error Message with No Error
Replies: 6
Views: 1732

Re: Action Button Error Message with No Error

Apparently this error has been identified as a bug in version 9.5.x in the TI interface and has been fixed in the TM1 10.1 version.

See this URL for details: http://www-01.ibm.com/support/docview.w ... wg1PM32962
by rkaif
Mon Jul 23, 2012 7:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.5.2 VUSlicing to Excel 2000
Replies: 4
Views: 608

Re: 9.5.2 VUSlicing to Excel 2000

In short, officially Excel 2000 is not supported with 9.5.2.

For details check out this URL: http://www-01.ibm.com/support/docview.w ... wg27020888

When upgrading to Excel 2010 make sure that they upgrade to 32-bit version of Excel as per the support webpage provided below.
by rkaif
Tue Jul 17, 2012 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.5.1 client crashes TM1 9.5.2 server
Replies: 1
Views: 418

Re: TM1 9.5.1 client crashes TM1 9.5.2 server

The PMR suggests to upgrade the client. Have you tried upgrading the client?
by rkaif
Mon Jul 09, 2012 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Re-Ordering of the dimensions to optmize my cubes
Replies: 4
Views: 667

Re: Re-Ordering of the dimensions to optmize my cubes

As mentioned by Wim you will have to manually note the Time difference before and after of the Dimension re-ordering.

If you want to get some sophisticated results then you may use JMeter or IBM Rational Performance Tester.
by rkaif
Fri Jul 06, 2012 7:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill through with Active Form?
Replies: 4
Views: 1239

Re: Drill through with Active Form?

Why don't you simply pass the Parameters from Parent sheet to the other sheet? Once parameters are passed you can Refresh the Active Form to see the result.
by rkaif
Fri Jul 06, 2012 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Form Location
Replies: 4
Views: 592

Re: Form Location

I am not aware of any built-in TM1 function to give you the exact results as per your screen shot. As a starting point you can make use of the }ApplicationEntries control dimension - this dimension has got the list of all the Application uploaded to the TM1 server. Or else if you are not using TM1We...
by rkaif
Fri Jul 06, 2012 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating Session reset and password reset
Replies: 6
Views: 1303

Re: Automating Session reset and password reset

I am not aware of this integrated password could please put insight on this. Lets say you are using CAM Authentication. In that case you will not have to create users/passwords in TM1 - actually the user names/passwords will be managed by Cognos. You can find more information here: http://www-01.ib...
by rkaif
Wed Jun 27, 2012 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input->Calculate->Report
Replies: 6
Views: 1233

Re: Input->Calculate->Report

I agree with Tomok and Declanr for this scenario. is it possible to force second TI process to wait until calculations in Calculation Cubes will have ended? But if someone wants to introduce some delay between the processes then you can do it using the Sleep command in Windows. SLEEP x ( where x is ...
by rkaif
Tue Jun 26, 2012 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Preferred Web Browser for Cognos Connection?
Replies: 1
Views: 857

Re: Preferred Web Browser for Cognos Connection?

The official supported browsers for Cognos Connections 10.1 are:
IE 6, 7, 8
Firefox 3.5 , 3.6

See this link for details: http://www-01.ibm.com/support/docview.w ... wg27019126
by rkaif
Tue Jun 26, 2012 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 installation error on Windows 2008 R2
Replies: 2
Views: 513

Re: TM1 installation error on Windows 2008 R2

Are you running the setup as an Administrator? (Right click on setup file and run-as admin)
by rkaif
Fri Jun 22, 2012 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Useful TM1 language highlighter for Notepad ++
Replies: 13
Views: 7443

Re: Useful TM1 language highlighter for Notepad ++

macsir wrote: Yeah, I have thought about that but looks like notepad++ only supports one section. Anyway, WHILE-END is not so widely used as IF-ENDIF;
We can setup While as well as IF at the same time. Please see the attached screen shot.