TM1 Forum

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

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

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.

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

You cant have column and rows from the same dimension.

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.

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.

http://pic.dhe.ibm.com/infocenter/ctm1/ ... bes_N60007

Information available on the above link.

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

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.

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

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.

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

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

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

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 ?

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

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

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

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

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