If you are unable to create a new account, please email support@bspsoftware.com

 

Urgent Reqt : - Month wise data.. (Cube doesnt have months dimensions)

Started by cogplan, 28 Feb 2011 01:50:54 AM

Previous topic - Next topic

cogplan

Hi Techies
               I am in a crunch situation.I need your guidance for this reqt.
We have a HR application for which we need to month wise data split  in the cubes. and we dont have months as dimensions.
Current structure:---
Serial no
Cost centres
version
calc dlist
Countries.
     
         I have created a staging layer , where I have added  4 months dimension.. and trying to calculate .. but I am held up here. how to proceed and work on it.

         Please suggest me some tips suggestions and solutions or workaround.


Regards
CogPlan


ericlfg

Hey Cogplan,

If I understand your requirement you need to move data from your cube (defined in your original message: Serial no, Cost Centers, Version, etc), but it needs to be defined into months in the new cube?  Since there is no months dimension in the original cube, there is no definition of values for each of the 12 months in a year.  If this is accurate, the only way I would know of to accomplish this would be to load a single month in the target cube with a summation of the values from the source cube.  Or, you could use an equal weighting in each of the months and spread the total value from the source into the target months.

This would all be done using d-links.  Maybe someone else will have another suggestion.. 

cogplan

Eric
          Thanks for your reply.
           I had requirement where in based on the Date of Joniing the values must be prorated into months.I have transferred data through d links.
     

Regards
Nayan