Feeders without Skipcheck

Post Reply
User avatar
Michel Zijlema
Site Admin
Posts: 706
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Feeders without Skipcheck

Post by Michel Zijlema » Tue Jun 03, 2008 9:57 am

It appears that Feeders in a rulessheet will only be triggered (processed) when in the same rulessheet the Skipcheck is actived. If not, defined (external) Feeders will not work.

Yesterday I ran into a situation where I had a cube where the Skipcheck statement was hashed out, but the Feeders statement was still in place. The Feeders section contained (correct) feeder statements to another cube, but apparantly these are not feeding. If I activate the Skipcheck the external feeders are working correctly (but then the numbers aren't correct - I guess that's why Skipcheck was hashed out). I'm currently revising the internal feeders of the cube and expect that everything will be okay after this. But I thought it was worth mentioning this behaviour here.

Michel

User avatar
jim wood
Site Admin
Posts: 3762
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Feeders without Skipcheck

Post by jim wood » Tue Jun 03, 2008 10:26 am

If skipcheck is removed or commented out then the need for feeders is removed as all calculated values will have a flag on it to let the system know they are there. Th eproblem is that the flag will be in place regardless of whether data is there. Memory usage potentially goes up and supress zeros will not work. Switching skipcheck off removes all flags. You therefore need feeders to put relevant flags in place.

Having skipcheck on is the only reason for feeders, thats why they don't work work.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Michel Zijlema
Site Admin
Posts: 706
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Feeders without Skipcheck

Post by Michel Zijlema » Tue Jun 03, 2008 11:04 am

Hi Jim,

I know how feeders work :ugeek: . The cube with the hashed out Skipcheck statement does not need the Feeders (well, it does from a performance perspective, but that's beside the issue here). This cube is calculating correctly without using Skipcheck/Feeders. The key thing for me was that if I have a cube without Skipcheck I can never feed to another cube from this cube. If I want to create an external feeder I need to implement Skipcheck on the source cube first.

Michel

User avatar
jim wood
Site Admin
Posts: 3762
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Feeders without Skipcheck

Post by jim wood » Tue Jun 03, 2008 1:08 pm

Apologies for teaching you to suck eggs. I'm not sure your first email was clear about the external cube bit. Nevermind. Anyway I now know what you mean and yes you are right you can't feed to another cube without switching skipcheck on. A bit of a pain. Have you thought of creating say a feeder cube? Take the data from the first cube via TI and load it into a another. Then create the feeders in this cube with skipcheck switched on. ot the nicest of solutions but it is one I guess,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Michel Zijlema
Site Admin
Posts: 706
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Feeders without Skipcheck

Post by Michel Zijlema » Tue Jun 03, 2008 2:02 pm

No worries. I was confronted with an old model that needs to be revised thoroughly. I was going for a quick win but found I had to go all the way implementing S&F bottom-up in the cascade of interlinked cubes. As writing S&F on all cubes was one of the things on my list it will be my first action now.

Michel

User avatar
jim wood
Site Admin
Posts: 3762
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Feeders without Skipcheck

Post by jim wood » Tue Jun 03, 2008 2:06 pm

Good luck.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply