Search found 21 matches
- Tue Oct 11, 2011 9:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx Interval definition
- Replies: 3
- Views: 2822
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...
- Mon Oct 10, 2011 11:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx Interval definition
- Replies: 3
- Views: 2822
Re: Mdx Interval definition
many thanks Lotsarm,
I am going to test it with the strings '000 -' to '999 -'
I am going to test it with the strings '000 -' to '999 -'
- Mon Oct 10, 2011 10:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx Interval definition
- Replies: 3
- Views: 2822
Mdx Interval definition
Hello everybody,
how can I define in MDX a subset with the interval 000 -* to 999 -* ?
Thanks
how can I define in MDX a subset with the interval 000 -* to 999 -* ?
Thanks
- Wed May 11, 2011 12:21 pm
- Forum: Useful code, tips and tricks
- Topic: Indirect variables in TI.
- Replies: 13
- Views: 39005
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...
- 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: 5234
Re: Using datasource as parameter for ZeroOut
you can not read the Datasource in prolog.
- 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: 2826
Re: Using 2 datasources in TI process
Hello,
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
you need only a Viewcreate Cost-Cube if you can use CellgetN from your Rates-Cube.
- 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: 7542
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
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
- 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: 7542
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
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
- 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: 7542
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
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
- 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: 7542
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...
- 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: 7542
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 ?
Short question:
how can I read data within a three loop from an input ?
- 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: 7542
Re: Avoid copying code á la Wim Gielis
where are our Gurus?
On vacation?
On vacation?
- 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: 7542
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 ...
- Thu Jul 15, 2010 6:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display Element Attribute in Worksheet
- Replies: 6
- Views: 6708
Re: Display Element Attribute in Worksheet
You can also use DBRA("server:store",Text($A$1,"@"),"EST DATE")
- Wed Nov 25, 2009 7:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mdx Tm1FilterbyPattern
- Replies: 1
- Views: 2274
Mdx Tm1FilterbyPattern
How can i use 2 Strings in Tm1FilterbyPattern ? only with Union ?
I am near 255 Characters.
Thanks
I am near 255 Characters.
Thanks
- Wed Oct 21, 2009 10:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Understanding ViewExtract TI commands
- Replies: 8
- Views: 6540
Re: Understanding ViewExtract TI commands
I always use all three commands at once. But how can i generate Subsets with Elements<>0 ?
- Tue Dec 02, 2008 1:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculating the Number of Populated Cells within a Cube?
- Replies: 6
- Views: 5346
- Tue Dec 02, 2008 11:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculating the Number of Populated Cells within a Cube?
- Replies: 6
- Views: 5346
Re: Calculating the Number of Populated Cells within a Cube?
How kann i Enable the Performance Monitor ?
- Mon Aug 18, 2008 12:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules-Editor
- Replies: 15
- Views: 11498
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
Who knows more?
Brahim Skalli
- Fri Jul 04, 2008 10:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Primer
- Replies: 18
- Views: 16149
Re: MDX Primer
I discovered the primer one year ago, and set that use I it eagerly. Thank you Philip