Feeders for Intercube rule with mis-matched dimensions?

[GPC]

Hi All,

We have a rule which uses substrings of elements, to retrieve a value from another cube.

Firstly here are the cubes & dimensions;

Freight Cube
Dimensions; Version, Service, Direction, Customer, Commodity, Origin, POL, POD, Destination, Cargo Type By Ownership,
Year, Month, Freight Measures.

Voyage Variable by Country Cube
Dimensions; Service, Country, Year, Month, Cargo Type Short, Voyage Variable by Country Measures.

here is the Rule in the Freight cube;

[{ 'Scenario 1', 'Scenario 2', 'Working Weekly'}, 'BAF Default'] = N:
DB('Voyage Variable by Country',!Service,SUBST(!Origin,1,2),!Year,!Month,SUBST(!Cargo Type by Ownership,1,2),'BAF');

So an example of Origin in the Freight Cube is "AUDTL". In the Voyage Variable by Country Cube the Country is "AU".
Similarly an example of Cargo Type by Ownership is "40DY C". In the Voyage Variable by Country Cube the Cargo Type Short is "40".

Rule works but I'm unsure how to feed it. At the moment I have;

[ 'BAF' ]=>
DB('Freight', 'Working Weekly', !Service, 'All Directions', 'Dummy Customer', 'Dummy Commodity', 'All Ports',
'POL Dummy', 'POD Dummy', 'Destination Dummy', 'Cargo Type Dummy', !Year, !Month, 'BAF Default');

But the cells are "Not Fed". Any ideas?

thanks,

Gregory

[Gregor Koch]

Hi

Right now you are only feeding the Dummy Elements as you are probably aware of and that is because there is no information in the source cube about the elements out of those dimensions.

With the given information you would have to feed consolidations which include all elements out of all the dimensions you are missing. Or in case of the Version a specific element.
This would be overfeeding, possibly by a lot, and please don't do it.

Whereas with your specific example of the Cargo Type Short and the Cargo Type by Ownership you could do something like

[ 'BAF' ]=>
DB('Freight', 'Working Weekly', !Service, 'All Directions', 'Dummy Customer', 'Dummy Commodity', 'All Ports',
'POL Dummy', 'POD Dummy', 'Destination Dummy', !Cargo Type Short | 'DY C', !Year, !Month, 'BAF Default');

But here you would have to feed all the different Cargo Type by Ownership which (in this example) start with '40' or create a consolidation of them.

Looking at your rule and considering the above option I think this would be a good example where you actually don't feed from the source cube but within the Freight cube.

Is it possible that you only need to bring in the 'BAF' from the source cube if you have a value in the Freight cube, say Freight Cost, to begin with?

In that case try to feed from that value.

Regards

[Martin Ryan]

You could also look at using attributes or aliases to feed and retrieve values instead of using subst, this would be slightly faster than subst, but means that you'd need to keep both dimensions updated with their equivalent in the other dimension. However that could be fairly simply maintained with a TI process that is schedule to run through one of the dimensions.

Cheers,
Martin

[GPC]

Hi Gregor & Martin,

Thankyou both for your ideas.
Gregor, I'm keen to try feeding from the Freight cube but unsure how to construct the feeder. Can you give me a start?

thanks,

Gregory

[Steve Rowe]

Hi Gregory,

What you need to find is a measure in the freight cube which has some form of relationship with BAF and use that to feed BAF from within the freight cube.

For example say you have the measure 'ABC' that is populated in the cube (probably by direct entry rather than a rule), if you can make the following statement about 'ABC'.

"If ABC is populated at the N level of my freight cube then I am always going to need to calculate 'BAF' "

Then you can use it as a feeder.

['ABC']=>['BAF'];

What you use to feed a measure does not have to be referenced in the rule you are feeding, although it normally is. Gregor seems to know more about the details of your model though

HTH

[Gregor Koch]

Hi

I don't know the model other than from the description above and was putting 1 and 1 together. Steve is explaining exactly the approach I recommended.

Now that I know who asked the question, Gregory, drop me a mail or call me.

Cheers

[GPC]

Hi Steve & Gregor,

Thankyou so much for your advice on this. I'm surprised at how simple the solution is. Clearly I was stuck on the idea that the feeder had to come from the rule source.

The only small issue is that consolidated cells still say "not fed", which is correct as not all the members of the consolidation are, so anyone else looking at it might assume that there is a problem. I guess this is something I'll just have to live with.

Once again - a big thankyou.

cheers,

Gregory

[Gregor Koch]

Hi Gregory

You don't have to live with it.
If you add the same condition to your rule it will be just fine and TM1 is not going to have any unfed rule calculated cells.

Say your Feeder now is in the Freight Cube

['ABC']=>['BAF'];

Add this 'condition' to your rule like so:

[{ 'Scenario 1', 'Scenario 2', 'Working Weekly'}, 'BAF Default'] = N:
IF(['ABC']<>0,
DB('Voyage Variable by Country',!Service,SUBST(!Origin,1,2),!Year,!Month,SUBST(!Cargo Type by Ownership,1,2),'BAF'),STET);

Save you from having 'BAF Default' calculated all over the place as well.

Cheers

[GPC]

Gregor,

Brilliant. Now its perfect. Thankyou so much.

Gregory