Search found 13 matches

by cfm04
Wed Jul 09, 2014 7:03 am
Forum: Useful code, tips and tricks
Topic: Dimension Mapper
Replies: 2
Views: 8023

Re: Dimension Mapper

Hi,
CAM version would be great. 8-)

BR
CFM04
by cfm04
Fri Apr 25, 2014 6:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Search Function for VUE Files
Replies: 10
Views: 9961

Re: Search Function for VUE Files

Hi, A while ago I had exactly this need - to find all .vue files in data model that contain particular string (subset name). All I did, I created a SearchString.bat file with such a code in: @echo off findstr /i /m /s "SubsetName" *.vue > SearchString.txt After you paste this SearchString...
by cfm04
Tue Feb 11, 2014 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

Re: ExecuteProcess - parse string

Harvey wrote: Check out this article on my blog that talks about such issues, perhaps it'll give you some ideas how to achieve what you need.
Nice article right now I also have my processes to write/create temporary dimensions to store array vaiables.
by cfm04
Tue Feb 11, 2014 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

Re: ExecuteProcess - parse string

As far as I can tell with the current information, I *think* that you want to make it too generic and too few hardcoded things in the code. In itself, this is not bad, but first you need to get it working. After that, you can go generic and reduce the maintenance burden of the application. Unless I...
by cfm04
Tue Feb 11, 2014 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

Re: ExecuteProcess - parse string

Wim Gielis wrote:Honestly, I do not understand the way you are working. Do you have the dimension }Processes in the cube?
Well I have the dimension }Processes but this is for an automatic report distribution based on processes and input parameters.
by cfm04
Tue Feb 11, 2014 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

Re: ExecuteProcess - parse string

In terms of your variable; as Wim pointed out, you are (as far as TM1 is concerned) just passing in 1 string, it is not smart enough to know that you want it to split that 1 string every time it hits a comma. As such it is looking for a TI process that is called the name of your whole string (param...
by cfm04
Tue Feb 11, 2014 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

Re: ExecuteProcess - parse string

Hi You should break it down in your cube, and retrieve the process name, parameter names and parameter values from the cube. After that, you can execute your process with the correct parameters. Actually it is broken down in the cube. But the cube has space for up to 10 parameters. The tmpProcessSt...
by cfm04
Tue Feb 11, 2014 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess - parse string
Replies: 13
Views: 9177

ExecuteProcess - parse string

Dear all, I'm trying to parse a string in order to use it with ExecuteProcess(). tmpReturnValue = ExecuteProcess (tmpProcessString); IF (tmpReturnValue = ProcessExitNormal()); tmpReturnValueString = 'OK'; ENDIF; IF (tmpReturnValue = ProcessExitMinorError()); tmpReturnValueString = 'Minor_Error'; END...
by cfm04
Tue Aug 13, 2013 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule: transfer data from input line
Replies: 2
Views: 2619

Rule: transfer data from input line

Hi all, I'm trying to rework some of the existing part of my model. One thing is I want to write a rule which transfer data from an input line to the specific dataline. The user first sekect costcenter and some other data which will be stored in the cube as a string. After all necessary selections a...
by cfm04
Wed Apr 17, 2013 7:20 am
Forum: Useful code, tips and tricks
Topic: Indirect variables in TI.
Replies: 13
Views: 37242

Re: Indirect variables in TI.

thanks for the hint.
by cfm04
Thu Apr 11, 2013 9:50 am
Forum: Useful code, tips and tricks
Topic: Indirect variables in TI.
Replies: 13
Views: 37242

Re: Indirect variables in TI.

During your example you checked values in the If clause.
But did you try to assign values like this?

Code: Select all

ixDim=1;

While ( ixDim<=100);
   Expand ('%sElName' | numbertostring(ixDim) | '%') = numbertostring(ixDim);
     ixDim=ixDim+1;
End;


Thanks
CFM04
by cfm04
Tue Nov 27, 2012 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update versus recreate in TM1 process?
Replies: 9
Views: 7383

Re: Update versus recreate in TM1 process?

hi, I have a TI which is pretty much doing what is discussed. I use a 3 step approach. 1. Unwind the structure 2. Create structure based on Datasource out of a SQL database 3. tidy up all not assigned Elements of the dimension. The 3rd step is where my problems occur. Although I'm almost using the s...