Cube Rule question

[kimmal]

I have what should be a simple issue, but can't figure it out with cube rules or even TI, newbie here obviously

I have an input cube tracking project hours by week. I need to move that data to a reporting cube. The issue is that the project in the input cube is a picklist item on the time dimension and is it's own dimension in the reporting cube and I can't figure out how I basically dimensionalize the picklist in order to move the data to the reporting cube. The attached picture shows what I'm trying to accomplish.

Hoping you folks can point me in the right direction

A

[Wim Gielis]

You would use a TI probably.
The source data will be in a view, basically the 12 numeric cells (1, 4, 0, 6 ..., until 0, 0 )
Do a CellGetS to read the Project selection from the picklist. This will be the reference in the Course_Activity dimension.
If the picklist is empty then increment the values on a dummy element, just to match both cubes.
Should be easy to do.

[MarenC]

Hi being a newbie I would create a view of the Input Cube for the relevant week and to get the dimension I would do a cellgets to the Project in the input cube,

so cellputn(vValue, ReportCube, vVersion, vName, CellgetS(inputcube, vVersion….'Project'), vWeek….);

Maren