TM1 Forum

Hello,

I have similar scenario and i am using above MDX query mentioned by you in active form in the MDX subset section. It is not giving me any data.


Thanks

Thanks all !!

I was able to do a workaround..

Hi All, I need to schedule a reset view of each node in my application when the user opens it. User should not be able to see their last saved view. I am assuming that there is some }tp_ process which run in back. I am not able to find the process name. Kindly throw some light on it. Thanks in advan...

Thanks for the reply Tomok...

As i require the value till 9 precision. Hence, Round is not suitable.

ROUNDP function is not working beyond 9 decimal precisions to display or extract the value
ex -
ROUNDP(- 0.0000000000000345,10) = (0.000000000)

Let me know if i am missing any thing.

Thanks !!

Hi , Environment - Cognos TM1 10.2 I have a rule calculated cell which is calculating to = - 0.0000000000000345 TM1 has limitations with the no of decimal values it takes. Hence, TM1 is storing this value as -0.000000000 As minus zero does not make any sense and while exporting the value. It is trea...

Hi All,

Hope everyone is doing fine.

I have a TI process which loads the data into a cube from data source. Is there any approach to skip the execution of data tab for Rule driven cells?


Thanks in advance.

Hi , I would like to follow up on this thread as I just came up with the same question. I am still looking for a way of assigning multi-dimensional access with really hiding the elements in the Contributor. Did you find a way to solve this "problem"? I have tried using dynamic subset for n...

Hi All, I have a TI process which has a data source as "File1.csv" file. I have a requirement to use other file say "File2.csv" in the same TI process. I Google it and searched to get some function to get this approach. Is there any TM1 function which can import a file within a T...

Thanks for your quick response. I agree moving the column as row in an active form and suppress to zero will work. Unfortunately, its not possible to move the column to row as per business. So, i tried looking into your another option to hide column using conditional formatting. I Google it and foun...

Hi experts, I tried to hide the columns dynamically using below VBA code. Private Sub Worksheet_Calculate() If Range("E23").Value = 0 Then Columns("E").EntireColumn.Hidden = True Else Columns("E").EntireColumn.Hidden = False End If End Sub I found out that VBA code does...

Thanks for your precious advice.

It's working

Executecommand(); in TI process can be used to execute command line commands. I want to use "copy" command to merge two files into one file. Can you please help me with the code. I am using below code in my TI Process. Its not throwing me an error but its not appending the content of files...

Thanks all for you precious suggestion and being so kind. Looks like TI is a better option. Will try to implement it.


Thanks again !!

I have a cube in Instance 1 which should be dynamically associated to a cube which is residing in Instance 2. I went through lot of documents but was not able to find an approach to write a rule between two cubes residing on different instance. Is there any approach through which we can write a rule...

The code copies the value from one intersection to another intersection.

When the process is executed by myself using tm1 web , it takes less than 10 seconds. When the same process is executed by other user, it takes around 2 minutes and some time "Operation failed" message is received. The process runs in background and gets executed. I searched a lot in Googl...

Thanks Gabor,

Will be waiting for FP1.

Hi Experts, I read a lot of article regarding this issue and searched in Google too. Environment is upgraded from TM1 10.1 to 10.2 . In TM1 web , When using "Windows Authentication" option , i am not able to log in. I am getting an error stating " A server error has occurred". If...

HI All, I am having similar issue and i have looked into for a lot of time in different angels. I am getting correct data in TM1 Perspective in an active for for rule based column. When i publish it in TM1 web , the column does not show correct data. Please give your precious suggestions. I know the...