Cube Rule question

Post Reply
Posts: 6
Joined: Thu Aug 21, 2014 1:19 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Cube Rule question

Post by kimmal » Wed Nov 20, 2019 8:24 pm

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

TM1 picklist issue.jpg
TM1 picklist issue.jpg (175.61 KiB) Viewed 2077 times

Wim Gielis
Posts: 2711
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium

Re: Cube Rule question

Post by Wim Gielis » Wed Nov 20, 2019 8:46 pm

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.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references

Posts: 143
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Cube Rule question

Post by MarenC » Fri Nov 22, 2019 12:21 pm

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….);


Post Reply