dynamic feeders

Post Reply
rozef
Posts: 74
Joined: Thu Jun 17, 2010 10:35 am
OLAP Product: TM1
Version: 9.4 9.5.1
Excel Version: 2003 - 2007

dynamic feeders

Post by rozef »

Hi everyone,

my problem of fedders is:

I have the dimesion "Dim" with the elements S, A1, A2, A3...
I have a rule like: []=N: IF( SUBST(!Dim, 1, 1) @= 'A' , S, CONTINUE);

This feeder wont works:
[S]=>DB( ... IF( SUBST(!Dim, 1, 1) @= 'A' , !Dim, 'nofeed'), ...);

If I write every member individually, it will works, but I search a dynamic one because some A* elements can be added.
Is it possible ?
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: dynamic feeders

Post by jim wood »

It might be easier if you create a consolidation for the A1, A2, A3. From what I understand of your rule is that all 3 become S. If you add a consolidation and feed the consolidation it will work. When you get new A elements just make sure they are added to consolidation,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
rozef
Posts: 74
Joined: Thu Jun 17, 2010 10:35 am
OLAP Product: TM1
Version: 9.4 9.5.1
Excel Version: 2003 - 2007

Re: dynamic feeders

Post by rozef »

Thank you Jim.

It seems a good idea, but if there is a way to avoid a consolidation,
my dimension is the Phase dimension so...
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: dynamic feeders

Post by jim wood »

Variable feeders can be detrimental to performance. If you set the weighting to 0 on the consolidation and block access to it using security you shouldn't have a problem. Also if you need to you can exclude it from any other rules by using stet,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
rozef
Posts: 74
Joined: Thu Jun 17, 2010 10:35 am
OLAP Product: TM1
Version: 9.4 9.5.1
Excel Version: 2003 - 2007

Re: dynamic feeders

Post by rozef »

Ok. tyvm Jim
Post Reply