TM1 Forum

Hello, I recently tried to update 1 cell within a cube using the TM1 REST API. I am using a MDX Statement to get the cellset ID. Here is the mdx {"MDX":"SELECT {[ADDiN_DIMS].[DIM1]} on 0 from C_ADDIN2 where ([}Clients].[Admin],[REPORTS_FEBR].[GEN],[ADDIN_PARA].[DIM_LABEL] )"} Thi...

Okay, i finally got it. The first entry of the returned array is the reference to the real array of values. Ok all seems fine. Now i only need to use the cube filter. What syntax should this cube filter have, to reference to a specific cell? For Example: From the Cube 'Sales' i want 'Canada;2015;Sum...

Ok i just checked the ValType of the returnvalue, and it is an array. (Thanks for the tipp)

But the content of the array is pretty useless. All entries are null

Any idea what i could be doing wrong?

Sincerely,
Alexander

Hi BrianL. First of all, thanks for your answer! TM1ServerLogOpen returns a 1 so it should be ok. The weird thing is: It always returns 1. If i use a Starttimestamp for some date in 2017 i get a 1 and if i use a user within the filter, that doesn't even exist, it also returns 1. (Even though no data...

Hi All, I have a little problem reading the transaction Log of my running Tm1 Instance. (tm1s.log) I want to get the information within an C# application using the TM1 C Api. I am already using this Api successful for many querys, but i cant figure out the TM1ServerLogOpen and TM1ServerLogNext funct...

Thanks for the answer. The settings in SORTCOMPONENTSTYPE and SORTCOMPONENTSTYPE solved it!

Hi, I'm trying to import data from a MSSQL database into our TM1 database using a C# console application. The whole project already works pretty fine. The struggle: Insert an element under a consolidation. The elements are under the root and under the consolidation resulting in strange behavior with...