Home » Fusion Middleware & Colab Suite » Business Intelligence » Complex Time Dimension (OBIEE 11g)
Complex Time Dimension [message #610508] Thu, 20 March 2014 13:53
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?

Previous Topic: Implement Digital Signature using the BI publisher
Next Topic: OBIEE Web Services
Goto Forum:

Current Time: Sat Jun 19 14:33:00 CDT 2021