TM1 Forum

Hi jpjosey,

We already faced this kind of issue and registering the dlls didn't work at all.

The problem was coming from a conflict with another Excel add-in: Business Object Live Office Add-In
We fixed the issue deactivating this add-in.

Hope that helps

Guillaume

Now our Idea was to add the "Value in % of Net Revenue" KPI wit a formular like ['Value in % of Net Revenue'] = ['Whatever Element of the group is active right now'] / ['Net Revenue']; But i have no idea if it is possible to have the red part as dynamic as "if the element 'xyz' is se...

Hi, I'm on 10.2.2FP1 and SubsetMDXSet is also available. Using the syntax SubsetMDXSet(DimName, SubsetName, '') on an existing dynamic subset, the subset becomes static. But using the syntax SubsetMDXSet(DimName, SubsetName, MDX Expression), the target subset remains dynamic (the MDX is attached to ...

The measure element 'SALES_TAX_AMT' is numeric and has a format with 3 decimals in the ODBC data source. Eg. '35.832'. Since I need to output this value in to a text file, I convert this element in to string data. While converting, I used trim () to get rid of the trailing spaces and str(). With st...

I have a question on the V2 Certificate option (#4). I am reading through the "How to Configure" file provided by IBM and i am not seeing anything that references the Client. Does option 4 not have a required client side update? This would be great as that will save me the headache of pre...

I'm on the same set up as you, although we do use Ops Console and have desires to use CDM in the future too. My testing seemed to show it was mostly fine, as long as you don't currently or in the future have requirements to use other tools with TM1 then you should be fine. Thank you Steve. We're no...

He will update this section tho: Do NOT proceed with this documentation unless you either: a) Do NOT use TM1 Operations Console/PMHub/CAFE b) or are on TM1 10.2.2 FP4+ To state: IBM Cognos TM1 v2 Certificates (TM1 10.2.2 FP4 IF1+ only) Not sure to follow you. That means that switching to v2 certifi...

Hi, The option chosen is to switch to the IBM Cognos TM1 v2 Certificates. Re-reading the Technotes, I feel a bit confused regarding the limitations of this option (limitations I hadn't noted before... :| ). On the technote "How to update your expiring IBM Cognos TM1 Certificates" ( http://...

Well in that case just updating the certificates on the server might work. The Admin Host service will communicate with the TM1 services via SSL using the v2 certificate (communication between server components cannot be non-SSL as far as I'm aware) and the TM1 clients would communicate with Admin ...

Does this mean that updating the certificates to v2 on the Admin Server will be enough to solve the problem in my case? My concern is to go through the 24 Nov without planning a deployment on the clients... Unfortunately, I don't see how this could work. Clients would have to be updated too to use ...

Yes, this behaviour is expected. As already mentioned earlier in this thread, this approach will not work. The reason it doesn't work is the fact that UseSSL is a parameter that controls how the communication between the TM1 server and the TM1 clients is performed, but not how the communication wit...

Hi All, SSL is turned off on my configuration (UseSSL=F into my tm1s.cfg file). I performed some tests simulating the 25 Nov 2016 (changing the system date on the client side). I was expecting to be able to access my servers as usual but it's not the case: all the servers disappeared from my server ...

First of all, thanks for your replies. Tomok, the process i'm talking about, is a big process calling many sub processes to do a lot of mathematical calculation and to fill in a cube. The sources of these processes are other cubes (including data calculated by rules) and the destination cube itself....

Hi everybody, I'm facing a strange behaviour running a TI calculation process. After several working hours or several processes executions, the execution's speed of my calculation process is running low critically (from 10min initially to a couple of hours) Looking at the memory state on the TM1 ser...

Thank you guys for your clear explanations, I understood! The model has effectively been updated recently. The cube "Inventory" has been rebuilt adding new dims, new rules and feeders (conditionnal feeders). For information, the MaximumCubeLoadThreads option into the cfg is set to 1. I've ...

Hi guys ! I'm trying to understand why the starting of our TM1 server has recently increased. Looking at the log I can see this: .... 5296 [] INFO 2013-01-10 17:53:14.285 TM1.Server Processing feeders for cube "Inventory" 4484 [] INFO 2013-01-10 17:56:02.438 TM1.Cube.Dependency Adding cube...

Thanks for your answers guys ! My conf is: Server: Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client: Windows XP. So I can't use the RulesOverwriteCellsOnLoad parameter , but thanks, I will keep it in mind when we will upgrade the system. I've omitted to say that the scope imapcted by my rul...

Hello guys,

I don't understand why, but when I remove a rule on my cube, the scope which was previously calculated by the rule is populated with 0 values.
Dont know if there is a link but I use in my rule the Undefvals function.

Thanks in advance for your help !

Guillaume

Duncan P wrote:Regardless of any other reason, the S: needs to be first. See http://www.tm1forum.com/viewtopic.php?t=7146.

And the winner is Duncan !!

I've just inverted the N: and S: rules and now CellGetS in my TI process returns the good values.

Thank you !!

Guillaume

Thank you all for your replies ! My guess is that you have written ['MyCalcVersion'] = N: ['MySourceVersion']; ['MyCalcVersion'] = S: ['MySourceVersion']; when you need to write ['MyCalcVersion'] = N: ['MySourceVersion']; ['MyCalcVersion'] = S: db('MyCube','MySourceVersion',!Dim1,!Dim2); You can't u...