I have a problem > When i am creating report in bi answers . the presentation hierarchy is event -> promotion_id -> item_no in one dimension
Another dimension having levels promotion_id -> promo_start_date -> promo_end_date .
I need to display -> event
-> promo_id promo_start_date promo_end_date
To get above report i drag event hierarchy from event dimension and promo_start_date ,promo_end_date from promotion_hierarchy .But it displays following way
-> event promo_start_date promo_end_date
-> promotion_id promo_start_date promo_end_date
-> item_no promo_start_date promo_end_date
But i want restrict promo_start_date ,promo_end_date to promotion level only.
Could someone please let me what to do to keep promo_start_date and promo_end_date to display when i drill down to promotion_id only not to event or not at item_no level.
Should i change in RPD file or in BI answers . It is an urgent issue.
Edited by: 977433 on Feb 4, 2013 4:51 AM
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.
please do the needful in this regard.
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.