You could maybe create a new field which is the concatenation of promotion_id, promo start date and promo end date and use it in your hierarchy event -> new field (promotion_id + promo_start_date + promo_end_date) -> item_no
Thanks a lot for prompt reply .But still i have a doubt .In order to concatenate (promotion_id + promo_start_date + promo_end_date) in event hierarchy These three levels should be part of one dimension as far as i know . In my case one dimension contain levels event ->promotion_id ->item_no
another dimension contain promotion_id ->promo_start_date ->promo_end_date .
what shall i do . Do i need to create one dimension contain all values or is there any another possible of creating hierarchy using two dimension .Even i googled for creating one hierarchy using two dimension but went in vain.
You have two possibilities :
- You create a new field which is the concatenation of promotion_id + promo_start_date + promo_end_date and after you change the hierarchy event --> promo_id --> item no : you add the new concatenate field at the second level (now promo_id) and you remove the promo_id. So you change the hierarchy event.
- otherwise you could test to add the promo_start_date and promo_end_date at the second level of the hierarchy event. So you will have 3 fields at the level promo_id.