Search found 178 matches

by winsonlee
Sat Mar 08, 2014 10:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2010 64bit Compatability, with CX 10.2.1
Replies: 7
Views: 3443

Re: Excel 2010 64bit Compatability, with CX 10.2.1

I have missed the info written on the"Notes" and when I saw the error msg mentioning "32-bit editions of Microsoft Office Excel 2007 or above", i I didn't realize the "Above" is referring to the office version and not the bits . After reading through the info posted by you guys, now it make more sen...
by winsonlee
Sat Mar 08, 2014 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2010 64bit Compatability, with CX 10.2.1
Replies: 7
Views: 3443

Excel 2010 64bit Compatability, with CX 10.2.1

In reference to this post http://www.tm1forum.com/viewtopic.php?p=45284 and http://publib.boulder.ibm.com/infocenter/prodguid/v1r0/clarity-reports/report/html/prereqsForProduct?deliverableId=1314816214693 MS office 2010 64 bit should be supported. When i install Xcelerator, i get the following error...
by winsonlee
Fri Mar 07, 2014 3:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get dimensions and column values used while generatin
Replies: 4
Views: 1319

Re: How to get dimensions and column values used while gener

You can try the mdx on control cube , eg }ElementAttributes_Branch.
This will give you the list of elements in the dimension and also the attributes that attach to the dimension.
by winsonlee
Fri Mar 07, 2014 12:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get dimensions and column values used while generatin
Replies: 4
Views: 1319

Re: How to get dimensions and column values used while gener

select {TM1Subsetall( [Branch] ) } ON COLUMNS, {TM1SUBSETALL( [Dimension2] ) } ON ROWS FROM [mycube]

You cant have column and rows from the same dimension.
by winsonlee
Thu Feb 27, 2014 4:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get username with timestamp for last cube update
Replies: 8
Views: 1800

Re: How to get username with timestamp for last cube update

http://www.tm1forum.com/viewtopic.php?p=16098

Have a read at the above topic to find out if it is the answer you looking for.
If you do not want to use relational database, you can still loop through the transaction log with TI to read the data back to the cube.
by winsonlee
Wed Feb 26, 2014 10:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get username with timestamp for last cube update
Replies: 8
Views: 1800

Re: How to get username with timestamp for last cube update

If cube logging is enabled, why not use transaction log to get the required information ?
Not through the tm1s.log but through the Transaction Log Query interface.
by winsonlee
Tue Feb 25, 2014 10:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying data from one cube to another cube
Replies: 5
Views: 4358

Re: Copying data from one cube to another cube

If you are doing this once off, then just save the view with the data you would like to copy across, create a TI using Cube View as the data source and use a cellputn command in the data tab to paste the data in the destination cube. If this has to happen regularly, then consider creating view using...
by winsonlee
Tue Feb 25, 2014 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT data
Replies: 6
Views: 1160

Re: ASCIIOUTPUT data

Yes, you are right, i am actually reffering to the order of the subset.
That would mean the best option now is to export the data out via prolog.

The only disadvantage of looping through the subset is not being able to supress zero.
by winsonlee
Tue Feb 25, 2014 5:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT data
Replies: 6
Views: 1160

Re: ASCIIOUTPUT data

http://blog.tm1tutorials.com/tag/asciioutput/ Found this posted by Wim Gielis "The aim is to export a list of projects that generated revenues in a chosen year, but sorted by project name in column A. The project name is an alias on the project number element names. It is possible to create a subset...
by winsonlee
Tue Feb 25, 2014 2:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT data
Replies: 6
Views: 1160

ASCIIOUTPUT data

Hi All

Has anyone come across the order of the data that gets exported is not the same as the order of elements in the dimension ?
Static subset is created through TI prior to exporting the data out.
by winsonlee
Fri Dec 06, 2013 6:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Issue
Replies: 3
Views: 903

Re: Feeders Issue

Thanks for the reply. I was thinking i am able to get away with not using CubeProcessFeeders as it takes 10-15 minutes to refresh the feeders. But i was testing it and it got to use CubeProcessFeeders . Does it make any difference if making Adhoc N level element, and copy the data to Adhoc depending...
by winsonlee
Fri Dec 06, 2013 5:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Issue
Replies: 3
Views: 903

Feeders Issue

Hi All, Version A Version B Version C Version D Version E Version F Adhoc (C) ['Adhoc']=>['Version A']; Version A is a calculated version depending on what is assign to Adhoc consolidation. so if I move Version B to Adhoc consolidation, this would mean that Version B is feeding version A. Will the f...
by winsonlee
Fri Oct 11, 2013 9:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cafe - System URL
Replies: 9
Views: 9396

Re: Cafe - System URL

When i did a test connection i got the following error. I have entered as per mention in the "External Server URI". Any idea what else could be wrong ? I am getting COI-ERR-2019 Connection Failed. COnnection returned an error. Verify that the connection string, including the server name and port num...
by winsonlee
Fri Oct 11, 2013 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cafe - System URL
Replies: 9
Views: 9396

Cafe - System URL

hI ,

Any one here uses Cafe before ?
I am trying to configure it to connect to TM1 but couldnt find the right System URL.

What should I enter for that ?
by winsonlee
Fri Aug 23, 2013 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1
Replies: 5
Views: 1219

Re: Cognos TM1

Have a read at the following link. http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/index.jsp?topic=/com.ibm.swg.im.cognos.tm1_ref.9.4.1.doc/tm1_ref_id16833tifun_subsetcreate.html http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/index.jsp?topic=/com.ibm.swg.im.cognos.tm1_ref.9.4.1.doc/tm1_re...
by winsonlee
Mon Apr 29, 2013 6:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Budget and Forecast for Profit and Loss
Replies: 2
Views: 1205

Budget and Forecast for Profit and Loss

There is a dimension call GL_Code and different group of cost is being forecast using different calculation. There are some similarities in the formula when the calculation is used. My question is comparing having rules that is easy to maintain vs rules that is faster, which one will you go for ? Is...
by winsonlee
Mon Apr 22, 2013 2:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: using .NET API for TM1
Replies: 18
Views: 3445

Re: using .NET API for TM1

You would only want to use .NET API for certain function. If you are planning to use it entirely to replace the whole interface, then it really defeat the purpose of using TM1. You would be better off coding the interface and use a normal back end database eg MS SQL server. I have been through the p...
by winsonlee
Tue Nov 27, 2012 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating View in Applications Folder
Replies: 1
Views: 471

Creating View in Applications Folder

I would like to find out if there is an automated way of creating folders in the applications ? The folder structure will be a replicate of a dimension eg Sales Rep dimension which has the following structure Sales Manager David -- Sales Rep Henry ---- Top10 Products Sales for Henry -- Sales Rep Wil...
by winsonlee
Mon Nov 26, 2012 5:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process error logs not getting updated
Replies: 8
Views: 2060

Re: Process error logs not getting updated

Have you tried removing the path in "Data Source Name On Server", browse the file again and run the process ?