This content has been marked as final. Show 2 replies
The dimension members have to be unique in OLAP.
You can concatenate level id with the dimension member to make dimension members unique at each level of OLAP dimension. This is a common practice.
Lets say one row in your relational TIME dimension table is:
year_id = 1
year_desc = '2011'
quarter_id = 1
quarter_desc = 'Q1-2011'
month_id = 1
month_desc = 'Jan-2011'
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.