Feeder Year LTD

[damientaylorcreata]

Hi Guys,

I need some feeder assistance. In our P&L cube we have created a series of LTD years in the "Year" dimension which is fed by the following rule (for the 2012 LTD example):

Code: Select all

['2012 LTD'] = ['Year':'2012'] +
['Year':'2011','Full Year'] +
['Year':'2010','Full Year'] +
['Year':'2009','Full Year'] +
['Year':'2008','Full Year']

As you can see, if 2012 LTD is selected, it should include the full years value for years 2008 till 2011 and then the selected months (e.g. Feb YTD) for 2012. This should therefore provide a LTD total up to the end of Feb 2012.

The feeder for this rule is as follows:

Code: Select all

['Year':{'2012','2011','2010','2009','2008'}] =>['2012 LTD'] ;

This works perfectly for all month combinations including "Full Year" and "Feb YTD" in Perspectives. However when viewed in EV, values for "Full Year" showup, but "Feb YTD" only shows up when selected with "Full Year". Therefore this seems very much a feeder issue, as the rule seems to generate the correct values for Feb YTD, but only the rows only show up when viewed with "Full Year".

-------------------------------------------------------------------------------------------------------------------------
Current Cube Dimensions:

Company
Currency
Sales Office
GBU
Customer
Department
Natural Account
Project
Year
Month
-------------------------------------------------------------------------------------------------------------------------

Any ideas on what additional feeders I should create in order to feed the YTD values correctly.

Thanks,
Damien

[tomok]

Therefore this seems very much a feeder issue, as the rule seems to generate the correct values for Feb YTD, but only the rows only show up when viewed with "Full Year".

Highly unlikely that it's a feeder issue if it works correctly in Perspectives. If your feeder was wrong then it wouldn't work in Perspectives either. This must be an EV thing and I can't help you there.

[qml]

Whatever the reason, may I just point out that there is a workaround that will require no rules or feeders and should also perform better.
The solution is to make 2012 LTD a consolidated element in your Year dimension with years 2008 to 2012 being its children (with a similar approach in case of other LTD elements).