Hi, The implementation was very good.

Hi, The implementation was very good. Even I have a similar requirement. I have three hierarchies namely Team Project Region Location Calendar Month •We have a project which is spread across locations. •In Reports, we will have three filters namely, Team, Geography and Calendar. •For e.g.: If we have the data entered for a metric(% of hours spent) at Resource-Facility level which is one level below project-location and this level will not be available in filters for reporting. Resource is tied to a Project. Facility is tied to a location. •Metric to be seen in report: % of Hours spent = (No. of hours worked/Total No. of Hours reported) * 100 •For this metric, we have the data elements data for No. of hours worked = 10 for every resource and Total No. of Hours reported = 12 for every resource. •Let’s assume we have 10 resources in a project. Project is spread across 2 locations. Location is mapped to a facility. Both the facility has 5 resources each. •So when we see the data for this metric at Project-Location level, it should calculate based on formulae as % of Hours spent = [(10+10+10+10+10)/(12+12+12+12+12)]*100. It should not do aggregation as summation of 5 resources data (10/12)*100. How the same aggregation and calculation will happen at the higher levels in the cube? What are the functions which can be used to achieve this? Also the formulae for each metric is stored in the table. I have to write a MDX which will pick up the formulae from the table based on the metric selected in the dimension and it has to do calculation at all the levels. Please help me to find a way for it. Thanks in Advance, Amby