Search found 26 matches
- Mon Jan 16, 2023 1:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ISO Week Number
- Replies: 6
- Views: 1789
Re: ISO Week Number
Thanks for your Help
- Fri Jan 13, 2023 11:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ISO Week Number
- Replies: 6
- Views: 1789
ISO Week Number
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, ...
- Tue Jun 07, 2022 6:20 am
- Forum: Commercial and Events
- Topic: We are all in the same T(ea)M1
- Replies: 0
- Views: 17256
We are all in the same T(ea)M1
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...
- Tue Oct 12, 2021 8:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamically MDX for PAW view
- Replies: 1
- Views: 3233
Dynamically MDX for PAW view
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 ...
- Thu Apr 08, 2021 10:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Error: Get cell value: Cannot get cube cell value
- Replies: 3
- Views: 2023
Re: MDX Error: Get cell value: Cannot get cube cell value
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.
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.
- Thu Apr 08, 2021 9:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Error: Get cell value: Cannot get cube cell value
- Replies: 3
- Views: 2023
MDX Error: Get cell value: Cannot get cube cell value
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]...
- Mon Dec 14, 2020 2:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System stack overflow, process terminated
- Replies: 9
- Views: 3711
Re: System stack overflow, process terminated
Okey, I apply your method.
thank you for your answer, now I changing the dimix to attrs/}ElementAttributes.
Best Regards
Kamil
thank you for your answer, now I changing the dimix to attrs/}ElementAttributes.
Best Regards
Kamil
- Mon Dec 14, 2020 1:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System stack overflow, process terminated
- Replies: 9
- Views: 3711
Re: System stack overflow, process terminated
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 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.
- Mon Dec 14, 2020 12:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System stack overflow, process terminated
- Replies: 9
- Views: 3711
Re: System stack overflow, process terminated
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...
- Mon Dec 14, 2020 10:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System stack overflow, process terminated
- Replies: 9
- Views: 3711
Re: System stack overflow, process terminated
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 ...
- Mon Dec 14, 2020 10:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System stack overflow, process terminated
- Replies: 9
- Views: 3711
System stack overflow, process terminated
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...
- Tue Nov 03, 2020 12:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pick list in Cognos Analytics from Tm1
- Replies: 1
- Views: 1143
Pick list in Cognos Analytics from Tm1
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
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
- Thu Aug 27, 2020 6:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How accelerate a speed of spread of data tm1
- Replies: 3
- Views: 1754
How accelerate a speed of spread of data tm1
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...
- Mon Aug 24, 2020 8:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process with batch entry a value every second times
- Replies: 2
- Views: 1467
Re: Process with batch entry a value every second times
Hi,
Thank for you answer PavoGa.
Now everything is okey. The process always entry data when I run a process.
The problem is solve.
Thank for you answer PavoGa.
Now everything is okey. The process always entry data when I run a process.
The problem is solve.
- Fri Aug 21, 2020 6:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process with batch entry a value every second times
- Replies: 2
- Views: 1467
Process with batch entry a value every second times
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...
- Tue Jul 14, 2020 9:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5194
Re: How run a SPSS Modeler stream from Tm1 process
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...
- Tue Jun 23, 2020 11:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5194
Re: How run a SPSS Modeler stream from Tm1 process
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...
- Tue Jun 23, 2020 8:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5194
Re: How run a SPSS Modeler stream from Tm1 process
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
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
- Mon Jun 22, 2020 11:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5194
Re: How run a SPSS Modeler stream from Tm1 process
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 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
- Mon Jun 22, 2020 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How run a SPSS Modeler stream from Tm1 process
- Replies: 12
- Views: 5194
Re: How run a SPSS Modeler stream from Tm1 process
1. I set a IntegratedSecurityMode = 1
2. i have only SPSS Modeler 18.2.1
2. i have only SPSS Modeler 18.2.1