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 ?
dynamic feeders
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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...
It seems a good idea, but if there is a way to avoid a consolidation,
my dimension is the Phase dimension so...
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
Ok. tyvm Jim