Feeders for cubes having more dimension than the source cube

[ravi.ahuja21]

Hi,

How do i write a feeder for a target cube which has more dimension than the source cube.
Here are my dimension
Dental Insurance Cube

• Function
  Facility
  Department
  Central Nature
  Employee
  Scenario
  Year
  Months
  Measures (Employee Premium LC, Employer Premium LC,Enrollment Status)

Insurance Driver Cube.

• Year
  Month
  Insurance Type
  Enrollment Status
  Measures(Employee Premium, Employer Premium)

Here is my rule to get the employee premium

Code: Select all

['HR','Employee premium LC']=N:DB('Insurance Drivers',!Year,!Months,'Dental',DB('Dental Insurance',!Function,!Facility,!Department,!Central Nature,!Year,!Months,!Scenario,!Employee,'Enrollment Status'),'Employee Premium');

Here is my feeder for the dental insurance cube in Insurance Driver cube

Code: Select all

['Employee Premium']=>
DB('Dental Insurance','President','Total Facilities','Total Department','4626 - Medical Insurance Shop',!Year,!Months,'Budgeted','Total Employees','Employee premium LC');

Is this the right way to write the feeder for such type of calculation.

Request someone to help me on this

[jim wood]

The general rule is that when you are feeding from a cube to another where the target has dimensions that the cube doing the feeding doesn't have, then you need to select an element from the said dimension in the target cube. This should follow the pattern of the rule. In your rule you specify HR yet you have not set that in your feeder.

Have you searched the forum on this subject? It has been raised many times before and I'm sure you'll find more details.

[jim wood]

Try this for instance......

http://www.tm1forum.com/viewtopic.php?p=1999

[tomok]

Feeding Cubes 101:

What is the determing factor as to whether or not you actualky have any dental insurance premium in the Dental Insurance Cube? Isn't it the Enrollment Status? If so, why would you feed from a lookup cube that just contains the rates by status code???

[ravi.ahuja21]

Feeding Cubes 101:

What is the determing factor as to whether or not you actualky have any dental insurance premium in the Dental Insurance Cube? Isn't it the Enrollment Status? If so, why would you feed from a lookup cube that just contains the rates by status code???

Hi Tom,

Thanks for the reply. The reason for the lookup cube is because the same premium amount would be applied to all the employees based on their enrollment status. The user does not wants to enter data for each employee so I am using a lookup cube to get the premium amount.

[ravi.ahuja21]

In your rule you specify HR yet you have not set that in your feeder.

Hi Jim,

Thanks for the prompt reply.

I have set all dimension which are not in the source cube to there total consolidation level, 'HR' comes under the total consolidation level named 'President'.

[jim wood]

Did you read the thread I linked above? It covers the subject in a lot more detail.

[ravi.ahuja21]

Did you read the thread I linked above? It covers the subject in a lot more detail.

Yes sir, That is excellent and too good for a newbie like me. Thanks a lot.

[Gregor Koch]

I have set all dimension which are not in the source cube to there total consolidation level, 'HR' comes under the total consolidation level named 'President'.

Aaaah! Whyyyy?

Please do another search on this forum for 'overfeeding' or 'feeding consolidations' to understand what you have just done and why it is, well, bad.
Also please follow tomok's advice and use 'Enrollment Status' within the 'Dental Insurance Cube' as the basis for your feeder!

[David Usherwood]

I'm with Gregor on this.
Repeat after me - all together now...
'Rates don't need feeding'

[tomok]

'Rates don't need feeding'

I agree with you that rates don't need feeding but the real issue here is that rates should almost never be used as a source for feeding the calculated value. After all, what is the determining factor as to whether or not I have to pay for dental insurance? Is it because the company has established a price for the insurance or because I have chosen to participate in the insurance program? The answer is obvious, just plain common sense, and covered very clearly in the Rules Guide.