TM1 Forum

Thanks for your Help

Hello Everyone, today, I had a problem with the Dates in TM1. Do somebody knows how to receive the iso week number? Is The function exist? Until now I have been trying to use the following: NumberToStringEx( vDayVal , 'ww', '', '' ); but unfortunately, this function returns me a simple week number, ...

Hello Everyone, today I have one message for You. Our company was inspired by the post by Octan Software Solution and our team went to Work. Here comes the initial effect and our proposal to the TM1 Worldwide community. Please consider this as an invitation to get creative, if you like one of our de...

Hello Everyone, today I have problem with view mdx. I have a 5 Cubes like 001_Cube,002_Cube,003_Cube and every cubes has the same number of dimensions. The differences on structure is between name of first dimension, because the every first dimension has the number prefix like 001_Dim, 002_Dim. The ...

Thanks Ellesar for your answer.

Now i have permission to the Cube and Dimensions using in this Cube. I set a WRITE permission on intersection.

On this server I'm using Dataresrvationmode but for different cube.

Hello Everyone, today I have a problem with mdx. I write a simple MDX. This mdx is bellow: {FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dim Product] )}, 0)}, [Security Type].(StrToMember("[}Clients].["+USERNAME+"]") ,[Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]...

Okey, I apply your method.
thank you for your answer, now I changing the dimix to attrs/}ElementAttributes.

Best Regards
Kamil

Hey Steve,
Now I find the failure line and you are right. I'm feeding the next element in a long dimension. I have a time dimension with days. The items in dimension are days and every element have next and previous days atribute. In feeder code i add line with dimix +1.

Now I conduct your solutions and i have a few conclusion. 1). I don't know what I can to do, because when I comment rules the proces work correctly, 2). When I put manually value the problem isn't happened. 3). When I uncomment rules the proces work correctly but this work last a few minutes. When i...

Hello, Exactly, this statement is from tm1server.log . The full statement is ERROR 2 TM1.Process Process "X": : System stack overflow, process terminated I have two Cubes. First Cube have a data whereas second Cubes doesn't have this data. I build a process and i forward data between this ...

Hello Everyone, I have a problem with my TM1 process. When I want to put value to the cube with CellPutN, I can't to do it. I try remove the rule, and when I do this, the process is working correctly. Unfortunately I need this rules, and I can't remove it. Do you know, how resolve this problem? Must...

Hello Everyone,

today I have a problem with picklist. I set in tm1 cube a picklist with element of dimension and everything is fine, but unfortunately when I add this cube to Cognos Anlytics I can't choose a element. Do you have a similar problem?

Best regards
Kamil

Hello, I have a small problem with data spread. When I want to do a proportional spread. The time of spread is very long. Sometimes I must wait a 3-5 minutes. Do you know , how solve this problem ? I looked for information about it on IBM site but I don't find a particular answer. Thank you Best reg...

Hi,

Thank for you answer PavoGa.

Now everything is okey. The process always entry data when I run a process.

The problem is solve.

Hello Everyone, i have a smal problem with process. When I would like to run the process with ViewZeroOut, I must run the proces one more time. Because the process entry a data every second times. #The bad process Prolog ViewZeroOut('Cube', '_ViewZeroOut Cube'); Epilog dCommand='"C:\Program Fil...

Hello everyone, On the last answer i wrote that i had a solutions.I tried to run a batch file from tm1 process .Unfortunelly, this process doesn't worked. luckly a few days ago i find the solutions. Firstly, i must write a script for tm1 import and tm1 export in SPSS. This code find on this page htt...

Hello everyone, I find a solution about it. You must add this script in the Stream (Tools, Stream Properties, Execution) and run the stream on the end. node = stream.findByID("Id_of_your_node") node.setPropertyValue("admin_host", "admin_host_with_port"); node.setPropert...

Okey,
Thanks for your answer. Now i create a execution but i have a problem with parameter. When I want to add input_credential I must entry a domain, user name and password. Do you know where can I check a domain parameter

Best regards
Kamil

Thank for your answer.
1) I checked your solution and i have one error. SPSS shows me a statement: "NoneType" has no attribute 'setPropertyValue'.

2)My version TM1 Still have PMhub.

Best regards
Palczan

1. I set a IntegratedSecurityMode = 1
2. i have only SPSS Modeler 18.2.1