TM1 Forum

No workbook is active/opened. You use TM1 > Explorer to log on in Perspectives. You open a view on a random cube and ask for an Active form to Excel. Nothing out of the ordinary I would say. Bam ! Error ! It looks like you also have Planning Analytics for Excel (PAX / PAfE) open. This will cause an...

Right. So you upgrade to 2.0.9.9 (over an existing 2.0.8 install) installing the server, Architect and Perspectives, TM1 Web and a bunch of other things that are not important for now. 2 small TM1 models are opening fine in Architect when their respective services are started and the data is loaded...

Have you tried either putting the conditions within Parentheses e.g. ... ('A' @= !A) & ('B' @= !B) ... or just the dimension reference within Parentheses e.g. ...'A' @= (!A) & 'B' @= (!B)... I would expect both examples to work fine. The first example can also make the rule easier to underst...

Are you installing 32 bit or 64 bit TM1? If 32 bit, I think you need to install the services manually.

From the readme.txt When you apply element security on Dimensions within an Applix TM1 cube, where ancestors of available (read/write) elements are made unavailable as part of the security profile, you must do the following: 1) Preload the cube; 2) If meta-data of the cube is expected to change duri...

I wasn't suggesting to use cell level security. The reason for asking if it has been used was that it could explain why a user can see data for elements that they have no access to. If cell security has been defined as Read or Write then this will override the None set for the dimension element secu...

Have you used cell level security for the cube in question? If so, where defined, this will override the dimension element security.

Bert.

Have you tried TM1SystemServerConnectIntegratedLogin?

Declare Function TM1SystemServerConnectIntegratedLogin Lib "tm1api.dll" (ByVal hPool As Long, ByVal sServerName As Long) As Long

Bert.

I've seen attributes move when database files are renamed, specifically a }ElementAttributes_xxx.cub file (which shouldn't be renamed). It could be worth checking which dimensions are used in the problematic attribute cube to see if this is the case.

Bert.