I am attempting to incorporate budget data into a cube and would like advice.
To simplify the question I will present this as thought the cube had two dimensions, time & product.
The time dimension consists of Year--->Qtr--->Month
The dimension is derived from a dd-mmm-yyyy field called transaciton_date in an .iqd called sales.
The Product dimension consists of Division-->Group-->Category. The categories are also derived from sales.iqd.
Also in the sales.iqd are measures for quantity and value.
I have a separate datasource that contains a budget value for each division in the product dimension for each month in the year.
The source data is structured as
Month Division Budget_value
200201 Division_1 $500
200201 Division_2 $500
etc..
200202 Division_1 $100
200202 Division_2 $100
etc...
I need to know the what step need to be taken when creating my .pyi in order to have the budget data
accurately reflected for each combination of period/product division
Any assistance would be greatly appreciated
To simplify the question I will present this as thought the cube had two dimensions, time & product.
The time dimension consists of Year--->Qtr--->Month
The dimension is derived from a dd-mmm-yyyy field called transaciton_date in an .iqd called sales.
The Product dimension consists of Division-->Group-->Category. The categories are also derived from sales.iqd.
Also in the sales.iqd are measures for quantity and value.
I have a separate datasource that contains a budget value for each division in the product dimension for each month in the year.
The source data is structured as
Month Division Budget_value
200201 Division_1 $500
200201 Division_2 $500
etc..
200202 Division_1 $100
200202 Division_2 $100
etc...
I need to know the what step need to be taken when creating my .pyi in order to have the budget data
accurately reflected for each combination of period/product division
Any assistance would be greatly appreciated