Feeders without Skipcheck

Post Reply
User avatar
Michel Zijlema
Site Admin
Posts: 712
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 »

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: 3951
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: Feeders without Skipcheck

Post by jim wood »

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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Michel Zijlema
Site Admin
Posts: 712
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 »

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: 3951
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: Feeders without Skipcheck

Post by jim wood »

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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Michel Zijlema
Site Admin
Posts: 712
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 »

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: 3951
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: Feeders without Skipcheck

Post by jim wood »

Good luck.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Feeders without Skipcheck

Post by MarenC »

Hi,

sorry to raise a very old post from the dead but I have 2 questions:

1) Is it still the case that feeding to another cube without skipcheck will result in no feeding?
2) Is there any scenario where having skipcheck off but feeders on makes any sense?

Maren
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Feeders without Skipcheck

Post by lotsaram »

MarenC wrote: Mon Jul 20, 2020 10:27 am Hi,

sorry to raise a very old post from the dead but I have 2 questions:

1) Is it still the case that feeding to another cube without skipcheck will result in no feeding?
2) Is there any scenario where having skipcheck off but feeders on makes any sense?

Maren
I don't think that #1 has ever been the case. You can have Feeders without SkipCheck.

Whether it makes sense it harder to say. Plenty of times I have Feeders in a cube that otherwise doesn't have rules. You could have a case of a cube with rules but no SkipCheck (say the cube had ony 2 or 3 dimensions so sparsity isn't an issue and so there's no need for feeders) and thi scube did have feeders to some other cube that did contain SkipCheck (becasue maybe that cube has > 3 dimensions and so sparse consilidation is required.)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply