Page 1 of 1
Feeder Help
Posted: Mon Apr 22, 2013 9:43 pm
by 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
);
Code: Select all
['Scenario':'Cash Flow Forecast','Measures':'$'] => DB('FPA','Cash Flow Forecast',!Cost_Center,!Project,!Account_Business|'M',!Period,!Year,'$fx');
- a.jpg (161.23 KiB) Viewed 6501 times
Re: Feeder Help
Posted: Tue Apr 23, 2013 4:54 am
by 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?
Re: Feeder Help
Posted: Tue Apr 23, 2013 5:40 pm
by mattgoff
macsir wrote:['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.
Re: Feeder Help
Posted: Tue Apr 23, 2013 7:01 pm
by 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)!
Re: Feeder Help
Posted: Tue Apr 23, 2013 7:54 pm
by Duncan P
But the rule works, and that is looking for SUBST(!Account_Business,1,4) - so unless there is an alias called "1111" ...
Re: Feeder Help
Posted: Tue Apr 23, 2013 8:44 pm
by mattgoff
Steve Rowe wrote: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
Re: Feeder Help
Posted: Wed Apr 24, 2013 2:38 pm
by 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.
Re: Feeder Help
Posted: Wed Apr 24, 2013 9:35 pm
by Duncan P
Sounds like you've got a bad case of the Zebras.
Re: Feeder Help
Posted: Thu Apr 25, 2013 10:51 pm
by 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.
Re: Feeder Help
Posted: Fri Apr 26, 2013 9:06 pm
by mattgoff
macsir wrote: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.