Page 1 of 1
Feeders for cubes having more dimension than the source cube
Posted: Wed Oct 12, 2011 7:17 pm
by 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
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 7:45 pm
by 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.
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 7:47 pm
by jim wood
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 7:48 pm
by 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???
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 8:20 pm
by ravi.ahuja21
tomok wrote: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.
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 8:23 pm
by ravi.ahuja21
jim wood wrote:
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'.
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 8:29 pm
by jim wood
Did you read the thread I linked above? It covers the subject in a lot more detail.
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 8:34 pm
by ravi.ahuja21
jim wood wrote: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.
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 10:27 pm
by Gregor Koch
ravi.ahuja21 wrote:
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!
Re: Feeders for cubes having more dimension than the source
Posted: Wed Oct 12, 2011 10:48 pm
by David Usherwood
I'm with Gregor on this.
Repeat after me - all together now...
'Rates don't need feeding'
Re: Feeders for cubes having more dimension than the source
Posted: Thu Oct 13, 2011 12:22 pm
by tomok
David Usherwood wrote:'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.