TM1 Forum

Hi All,

I have a below scenario, please help me on understanding how to feed the calculation.

Cube Name: Test
Dimensions
Product
Weeks (All weeks->has 52 weeks and No week element)
Destination(All Destinations->has 72 Destinations and No destination element)

SKIPCHECK;
['Measure',Product:{'Product1,'Product2'}]= ['Measure1',Week:{'No week'}]*['Measure2',Destination:{'No Destination'},Product:{'No Product'}];

FEEDERS;

['Measure1','No week']=>['Measure','All weeks'];

OR

['Measure2','No Product','No destination']=>['Measure','All Destinations','Product1'];
['Measure2','No Product','No destination']=>['Measure','All Destinations','Product2'];

As you can see, in both case of feeders I feed from "No" to "all Hierarchy" which results in making the memory used by the feeders to be more and the time to save goes up to 15 min with large data in the cube.

Please can you suggest any value to restrict the feeders? Can i use conditional feeders( am not very much aware on how to use it)? Please help.

Thanks!

Chuks wrote:Please help.

A couple of points regarding your question:
* In your cube dimensions list you miss out Measure - I guess that was your only omission?
* How many elements are in the Product dimension?
* What is the relationship between Product and Destination?
* You are not using a N: qualifier on your rule for Product1 and Product2; why not?

This smells like a homework question - is that the case?

Hi,

Thanks for the reply.

Please find my comments for the below questions:

* In your cube dimensions list you miss out Measure - I guess that was your only omission?--> Yes, it was my mistake that I missed to include in the list.
* How many elements are in the Product dimension?--> There are around 10 elements, but the rule should be applied only for 2 elements. Product 1and Product2
* What is the relationship between Product and Destination?--> A destination is a place where we sell product.
* You are not using a N: qualifier on your rule for Product1 and Product2; why not?--> the rule should be applied on N: ,again its a typo error that I missed.

No, its not a homework question.We have this implemented in our model.

Sorry for not being clear in the question.

Thanks!