Search found 21 matches

by bskalli
Tue Oct 11, 2011 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx Interval definition
Replies: 3
Views: 2769

Re: Mdx Interval definition

The complete solution looks like : {FILTER( {TM1SUBSETALL( [RLS_Tarif] )}, [RLS_Tarif].CurrentMember.Name >= "000" AND [RLS_Tarif].CurrentMember.Name <= "999" )} {TM1FILTERBYPATTERN( {TM1SUBSETALL( [RLS_Tarif] )}, "??? - *")} It´s the first time i use CurrentMember. Tha...
by bskalli
Mon Oct 10, 2011 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx Interval definition
Replies: 3
Views: 2769

Re: Mdx Interval definition

many thanks Lotsarm,

I am going to test it with the strings '000 -' to '999 -'
by bskalli
Mon Oct 10, 2011 10:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx Interval definition
Replies: 3
Views: 2769

Mdx Interval definition

Hello everybody,

how can I define in MDX a subset with the interval 000 -* to 999 -* ?

Thanks
by bskalli
Wed May 11, 2011 12:21 pm
Forum: Useful code, tips and tricks
Topic: Indirect variables in TI.
Replies: 13
Views: 37236

Re: Indirect variables in TI.

Hi Steve, we must be patient in our forum. I have a similar question one year ago. Unfortunately, I have used the word Activation This Word can still be found in other Programming languages ​​(APL, PL1 ..). Within a week I see your solution under 2 topics. In my case I have a ascii-file with 60 vari...
by bskalli
Thu Dec 02, 2010 9:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using datasource as parameter for ZeroOut
Replies: 7
Views: 5153

Re: Using datasource as parameter for ZeroOut

you can not read the Datasource in prolog.
by bskalli
Tue Nov 16, 2010 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using 2 datasources in TI process
Replies: 3
Views: 2796

Re: Using 2 datasources in TI process

Hello,
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
by bskalli
Fri Sep 10, 2010 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

Hi Wim,
in order to avoid defining a dimension for every TI_Process , I have implemented a single dimension ,
which elements are as follows: PGMnn.Elemnn.Valuenn and some attributes.

And my former Request deals with : Valuenn.

bskalli
by bskalli
Fri Sep 10, 2010 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

Hello Wim, here is an example of your method without loop,
rather than one dimension to be defined with attributes.

CompanyCode='00301';

T_I='&00011&00013&00301&00338&';
T_O='&58012&58043&56002&56061&';
Firma=Subst(T_O,Scan(CompanyCode,T_I),5);


bskalli
by bskalli
Fri Sep 10, 2010 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

Hello Wim, I know your code and I use it too.
You're the first who told me that there is no activation in TI.
I have my answer.
Hello Michel,
Of course there are a lot of code inside the loop,
Read attributes, arithmetic, writing in a cube ...
Thank you for your patience
by bskalli
Fri Sep 10, 2010 7:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

Hello Alan, I have a text-file as Data-Source with three variables. I want to transfer the value of this variable within a loop. I know that the last line is wrong: MyDims='Column01§Column13§Column27§'; WHILE(LONG(MyDims)>0); Column=SUBST(MyDims,1,SCAN('§',MyDims)-1); x=+Column+; the only soluti...
by bskalli
Fri Sep 10, 2010 6:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

Thanks Drbot und David.
Short question:
how can I read data within a three loop from an input ?
by bskalli
Thu Sep 09, 2010 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Re: Avoid copying code á la Wim Gielis

where are our Gurus?

On vacation?
by bskalli
Mon Sep 06, 2010 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoid copying code á la Wim Gielis
Replies: 12
Views: 7441

Avoid copying code á la Wim Gielis

I use very much the method Wim Gielis, Avoid copying code. But I still have not found any possibility that the n-fund on the shows of the n-variable inputs, it would be an art activation. I do not want to know how the variable is called but its content I speak about a text input in a ti Process Any ...
by bskalli
Thu Jul 15, 2010 6:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display Element Attribute in Worksheet
Replies: 6
Views: 6563

Re: Display Element Attribute in Worksheet

You can also use DBRA("server:store",Text($A$1,"@"),"EST DATE")
by bskalli
Wed Nov 25, 2009 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx Tm1FilterbyPattern
Replies: 1
Views: 2237

Mdx Tm1FilterbyPattern

How can i use 2 Strings in Tm1FilterbyPattern ? only with Union ?
I am near 255 Characters.

Thanks
by bskalli
Wed Oct 21, 2009 10:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding ViewExtract TI commands
Replies: 8
Views: 6417

Re: Understanding ViewExtract TI commands

I always use all three commands at once. But how can i generate Subsets with Elements<>0 ?
by bskalli
Mon Aug 18, 2008 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules-Editor
Replies: 15
Views: 11301

Rules-Editor

After one week with Tm1 9.1 SP3, I straight noticed that the Rules editor dimension elements with "Umlaut "(ex. März) did not accept.
Who knows more?

Brahim Skalli
by bskalli
Fri Jul 04, 2008 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Primer
Replies: 18
Views: 15902

Re: MDX Primer

I discovered the primer one year ago, and set that use I it eagerly. Thank you Philip