| Complex Time Dimension [message #610508] |
Thu, 20 March 2014 13:53 |
 |
alesm
Messages: 1
Registered: March 2014
|
Junior Member |
|
|
Hi Everyone,
I have a need to build a report like this:
Culture Campaign Measure Previous_Campaign_Measure
Wheat 2011 100 90
Wheat 2012 150 100
Wheat 2013 200 150
My tables are:
Typical Time dim: Date_id, day, month, year
Culture_campain Dim: Culture, Campaing, Date_From, Date_To
I wanted to be able to build the Previous_Campaign_Measures with the AGO(measure, campaign, 1) Function.
I tried building a complex time dim like this:
Time_Culture_Campaign: Culture, Campaign, Date, Month, Year (PK: date_id, culture_id, campaign_id)
So the same day exists for the different Cultures and campaigns
In my Fact Table I Currently have: date_id, culture_id and campaign_id.
When I tried to model this I got an error in the report:
To use AGO function, the query level ('') must be a static level. (HY000)
Any ideas?
Thanks,
Alejandro
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
