Quick feeder question

[davidh]

Hi all.

I wish to feed some data from one cube to another but would like it to only feed data up to the year 2016 and not beyond.

The data is in the 'Asia Sales' and has a feeder to our global cube as follows;
['Local', 'Total Customers excl INTCO']=>DB('GlobalSales', 'Asia', !Year, !Month, !Version, !Values, !Product);

In the global cube the rule has
['ASIA'] =DB('ASIA Sales','AUDYE',!Year,!Month,!Version,!Values,'Total Customers excl INTCO',!Product);

This all seems to work fine. However I would like to limit the data coming through in the Global cube for Asia sales to only be up to the year 2016 and not after. I tried a few things, read some forums, etc, but couldn't get it to work.

Anyone have any thoughts on how to make this work.

Thanks in advance.

David

[Edward Stuart]

Hi David,

If you have got the time then I'd advise checking out Chapter 7 of the Rules Guide "Rules for Time Based Calculations"

This goes over several methods to achieve what you want

- Sequential Monthly Statements or in your case Yearly
- DIMNM/ DIMIX may be relevant but it depends on what you are really looking for
- Using DIMIX for comparisons seems like a good option based on what you have explained but I am loath to hard code anything in rules
- Using a String cube to store a variable is probably your best solution as it is possible at some point you will want to move this rule onto 2017, 2018 etc..

HTH

[davidh]

Thanks Edward.

I think the sequential type thing is all I need, as I can just do the last 5 years easy enough. Thing is, I tried that and couldn't get it to work.

Where in the two lines do I put the year?

The data is in the 'Asia Sales' cube and has a feeder to our global cube as follows;
['Local', 'Total Customers excl INTCO']=>DB('GlobalSales', 'Asia', !Year, !Month, !Version, !Values, !Product);

So do I do it as ['Local', '2016', 'Total Customers excl INTCO']=>DB('GlobalSales', 'Asia', !Year, !Month, !Version, !Values, !Product); as I tried this and it didn't work.

In the global cube the rule has
['ASIA'] =DB('ASIA Sales','AUDYE',!Year,!Month,!Version,!Values,'Total Customers excl INTCO',!Product);

For this one I tried ['ASIA'] =DB('ASIA Sales','AUDYE', '2016',!Month,!Version,!Values,'Total Customers excl INTCO',!Product); This didn't work either.

I'm sure this is all pretty simple but I couldn't make it work.

Thanks in advance to anyone who can help.

Regards

David

[Edward Stuart]

Before you analyse what your feeder should be you need to write your rule.

Existing Rule:
['ASIA'] =DB('ASIA Sales','AUDYE',!Year,!Month,!Version,!Values,'Total Customers excl INTCO',!Product);

This is defined by AREA = FORMULA

So ['Asia'] is the AREA in the cube you are pulling data into

If you want to go sequential then you could define each year

['Asia','2012'] = DB('ASIA Sales','AUDYE','2012',!Month,!Version,!Values,'Total Customers excl INTCO',!Product);

The subsequent Feeder statement in the ASIA Sales cube

['Local', 'Total Customers excl INTCO']=>DB('GlobalSales', 'Asia', !Year, !Month, !Version, !Values, !Product);

This could remain as is but would overfeed, to make it more efficient you could change to reflect the Year

['Local', 'Total Customers excl INTCO', '2012']=>DB('GlobalSales', 'Asia', '2012', !Month, !Version, !Values, !Product);

This is not the most efficient way to fulfil this requirement and includes some maintenance for each Year but is a starting point to be improved.