and you level ids in olap are defined as 'YR_LVL', 'QTR_LVL', MTH_LVL'
This can be loaded into your OLAP time dimension as 3 time dimension members: time = 'YR_LVL_1' time_long_description = '2011' time = 'QTR_LVL_1' time_long_description = 'Q1-2011' time = 'MTH_LVL_1' time_long_description = 'Jan-2011'
You can either do the concatenation setting in OLAP time dimension definition in AWM (without making any change in relational table or view)
or in your source sql view that is "mapped" to OLAP time dimension.
In other words, please correct me if i'm wrong, if the relational table doesn't have year_id, quarter_id, month_id as three different columns or doesn't have any data to define them, I will need to build a Time Dimension with a structure defined by levels and keys for each level ?