TM1 Forum

I tested it on TM1 9.4 MR1, and Excel 2007.

Passworded files cannot be used, it seems.

Hello

If I understand you correctly, you could just have the All subset on the }Groups subset, as your data source.

In the Metadata & Data tabs, do whatever you need to do. But you do not need to loop in these tabs over another dimension.

Wim

Hi par3

TI is the (only ?) way to go here.

I guess it is the only way since you cannot loop over elements in a rule. You know the number of components of a consolidation (ELCOMPN), but you cannot form the string with a loop say from component 1 to n.

Wim

Are you doing this in the Subset Editor or Excel?

If you are in the case of the former, follow the advice of asvlad. If you are in the case of the latter, use the SUBNM function.

Hi there You can use ASCIIOUTPUT to print a fixed text or the contents of a variable to a text file. Some points to take into account: The first argument of that function should be the file name. If you do not specify the path location, the database directory is used. Separate with comma's what you ...

Hi

Perhaps not the answer you wanted (Grunt helped you already), but do you know why it takes 1-2 hours? Is this normal? Are there certain factors that lead to such a long time to execute the process? Do you turn off cube logging temporarily? And so on.

Wim

Indeed. I don't see any security issue at stake over here. A TM1 client only has access to TM1 objects, metadata and data to which he/she is entitled in the security setup. Moreover, it existed in previous versions for non Admin users.

Wim

Yes. .NET framework 3.5 SP1 is needed for TM1 9.5, while it is advised not to have it in previous versions.

Wim

For only one area, the RAM memory used on the server will probably almost double since we're on Unicode since version 9.4.

Hi

The problem is solved. It appeared that multpiple TM1p.ini files were residing on the PC, which was causing the program not to run.

Wim

Hello, Does someone have any ideas on this one? TM1 9.5 is installed on a desktop PC. When you launch Architect, you see the blue screen appearing, but then nothing. This is the same for Perspectives. If you look in the task manager, you see several instances of tm1s.exe and tm1a.exe. The PC runs Wi...

Hello

No. To do multiplications, you need to write rules and feeders in the Rules Editor associated with a cube.

Case closed since we have solved the case for this customer. We installed the TM1 Web components (custom installation) on the Webserver, and disabled the Excelservices service on the tmserver. Changed a few settings in the config file and off we go. (It's always good practice to have the Excelservic...

Hello there Users don't need to reply to get that information. Just look at the profile of a user, and most of the time he/she will have filled in the version he/she is using most of the time (or multiple versions). I *think* that 8.x versions are rather rare nowadays (and officially not supported a...

Hello George I could really help you out with your challenges, but the one thing I always want to ask is (when someone wants to learn VBA in depth, not writing/recording macro): how good are you in Excel without VBA? :P You can perfectly write a loop in Excel without much knowledge. For instance a l...

Hello Martin

I'm not sure what would trigger the update, though a DimensionElementDelete statement cannot be part of the Epilog tab.

Wim

Hello Borisslu You could create a measure called Revenue, begin: ['Revenue']=N:['Quantity']*['Price']; Most of the time, Price will be manual input (or TI process, or Excel sheet) at the leaf level. At the consolidated level, you have the weighted average for Price as: ['Price']=N:STET;C:['Revenue']...

Hello Jeroen

I don't know about that code, perhaps someone else does, but how about writing it again as a piece of generic code?

Greetz,

Wim

Hello

What about the file tm1pRibbonX.xlam in the Bin directory? That seems to be the Excel 2007 variant if I'm not mistaken. Could it be that you need this one too?

Hello Blaira Can you expand a little bit more on this? So the file crashes when you try to close the file? Does it crash when you have exactly the same file without the action button? What is the purpose of the action button? Does the crash occur if you did not use the button during the time the fil...