Cube Rule question

Post Reply
kimmal
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

A
Attachments
TM1 picklist issue.jpg
TM1 picklist issue.jpg (175.61 KiB) Viewed 489 times

Wim Gielis
MVP
Posts: 2278
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

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
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

MarenC
Posts: 54
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….);

Maren

Post Reply