Search found 327 matches
- Sun Oct 20, 2013 8:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Audit Log reports
- Replies: 7
- Views: 14737
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...
- Sun Oct 13, 2013 12:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel report issue in TM1
- Replies: 2
- Views: 2828
Re: Excel report issue in TM1
Try this formula:
Code: Select all
SUBNM("pftm1serv:Account_PF","AccMgr_Fox","Andrea_Underhill")
- 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: 3848
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 ...
- 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: 3697
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.
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.
- Sat Oct 12, 2013 6:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Audit Log reports
- Replies: 7
- Views: 14737
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...
- 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: 8007
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...
- Thu Oct 10, 2013 6:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Questions about Perspectives & Active Forms
- Replies: 3
- Views: 4008
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...
- Wed Jun 05, 2013 3:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Operations Console Installation issue
- Replies: 0
- Views: 1746
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...
- 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: 10321
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...
- 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: 6148
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
See this URL for details: http://www-01.ibm.com/support/docview.w ... wg1PM32962
- 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: 3408
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.
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.
- 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: 2110
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?
- 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: 3406
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.
If you want to get some sophisticated results then you may use JMeter or IBM Rational Performance Tester.
- Fri Jul 06, 2012 7:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill through with Active Form?
- Replies: 4
- Views: 4187
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.
- Fri Jul 06, 2012 2:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Form Location
- Replies: 4
- Views: 3405
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...
- 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: 5182
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...
- Wed Jun 27, 2012 8:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Input->Calculate->Report
- Replies: 6
- Views: 4401
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 ...
- 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: 2450
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
IE 6, 7, 8
Firefox 3.5 , 3.6
See this link for details: http://www-01.ibm.com/support/docview.w ... wg27019126
- 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: 2495
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)
- Fri Jun 22, 2012 3:50 pm
- Forum: Free And Open Source Tools
- Topic: Useful TM1 language highlighter for Notepad ++
- Replies: 13
- Views: 89082
Re: Useful TM1 language highlighter for Notepad ++
We can setup While as well as IF at the same time. Please see the attached screen shot.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;