Feeder Help

[mattgoff]

OK, I'm raising the white flag on this one. What am I missing that's causing this cell to be unfed? (Yes, I know there are some performance issues with ATTRS and ELISANC-- cleaning up performance is on my to-do list.)

Cube: FPA
Dims: Scenario, Cost_Center, Project, Account_Business, Period, Year, Measures

Rule:

Code: Select all

[Scenario:'Cash Flow Forecast',Measures:'$fx'] = N:

	IF ( ELISANC ( 'Account_Business' , 'BS Movements' , !Account_Business ) = 1,

		DB('FPA',!Scenario,!Cost_Center,!Project,SUBST(!Account_Business,1,4),!Period,!Year,'$') -
		DB('FPA',!Scenario,!Cost_Center,!Project,SUBST(!Account_Business,1,4),ATTRS('Period',!Period,'PeriodLast'),IF(!Period@='Jan',ATTRS('Year',!Year,'-1'),!Year),'$') -
		DB('FPA',!Scenario,!Cost_Center,!Project,!Account_Business,!Period,!Year,'$')
		 ,								
		CONTINUE

	);

Feeder:

Code: Select all

['Scenario':'Cash Flow Forecast','Measures':'$'] => DB('FPA','Cash Flow Forecast',!Cost_Center,!Project,!Account_Business|'M',!Period,!Year,'$fx');

Cube Viewer and Rules Tracer:

a.jpg (161.23 KiB) Viewed 6510 times

[macsir]

['Scenario':'Cash Flow Forecast','Measures':'$'] => DB('FPA','Cash Flow Forecast',!Cost_Center,!Project,!Account_Business|'M',!Period,!Year,'$fx');

What I suggested is to use that specific cell on the left part to see if it can feed it properly?

[mattgoff]

['Scenario':'Cash Flow Forecast','Measures':'$'] => DB('FPA','Cash Flow Forecast',!Cost_Center,!Project,!Account_Business|'M',!Period,!Year,'$fx');

What I suggested is to use that specific cell on the left part to see if it can feed it properly?

Good idea, I hadn't explicitly checked that but that feeder source (Cash Flow Forecast,33.000.0000,000,1111,Apr,2013,$) is indeed fed.

[Steve Rowe]

The 1111 on the base account, the end of it is greyed out, is the base element name or descriptive?

I.e. if the element is really 1111 - Directors Pay and when you add the M you get "1111 - Directors Pay M"

The only manipulation you are doing in the feeder is ,!Account_Business|'M' so I'd be looking here everything looks so simple it can't go wrong. (famous last words)!

[Duncan P]

But the rule works, and that is looking for SUBST(!Account_Business,1,4) - so unless there is an alias called "1111" ...

[mattgoff]

The 1111 on the base account, the end of it is greyed out, is the base element name or descriptive?

I.e. if the element is really 1111 - Directors Pay and when you add the M you get "1111 - Directors Pay M"

The only manipulation you are doing in the feeder is ,!Account_Business|'M' so I'd be looking here everything looks so simple it can't go wrong. (famous last words)!

It's descriptive. I accidentally took the screenshot with aliases enabled, and revealing the specific account name and amount was more than I wanted to share, so I took the easy way out and cut out the name. The element names for Account_Business are all four character alphanumerics (no spaces, symbols, etc).

Matt

[mattgoff]

Had a window to restart the server this morning, and the cell is now feeding properly. So I guess it was a hiccup. Which is awesome. Thanks all.

[Duncan P]

Sounds like you've got a bad case of the Zebras.

[macsir]

Better to use function to fire all feeders next time after updating a rule rather than rebooting. This is my own best practice. Just FYR.

[mattgoff]

Better to use function to fire all feeders next time after updating a rule rather than rebooting. This is my own best practice. Just FYR.

Except that feeders are supposed to fire automatically after saving a rule. If it happens again I'll do a rule save to see if that clears it before I try a restart.