Skip to Content
Oct 19, 2012 at 11:13 AM

How to model relative time characteristics



I have a datasource with following columns

Project, Date, Days2Project, Char1, Char2,..., Revenue

Project is a Project code

Date is a calendar date

Days2Project is nuber of days relative to the project start date - integer (can be both negative and positive)

Revenue - total revenue - Life to day

In my reports (and charts) I want to sum up the revenue over different combinations of project and other characteristics (char1, char2...) and show the values along the time dimension Days2Project.

I am stuck how to model this. I found out that I cannot create a new Z time characteristics. Non time characteristics cannot be type integer.

Can you please recommend how to model this cube?