Hi All,
This question is related to BR version 5.0.9.0.
Please see attached word document for related screen shots.
Attempt 1:
I added a customer attribute ‘SELECTION_GRP’ to FACT_TIME_TRANSACTION (source type - Function Call) and used it as a BR report parameter .
The report will show LoV for ‘Selection Group’ when it runs from BR .But when I run it from IFS/Order Report LoV is not displayed.
I think the reason for missing LoV in IFS may be ‘SELECTION_GRP’ is not a primary key item
Attempt 2:
I did not see a standard dimension for ‘Selection Group’ , So I created a Quick Dimension for Selection Group. And tried to create a Relation for Fact using Quick Dimension. but was unable to do so because I could not find a fact item id from FACT_TIME_TRANSACTION to the ‘selection_group’ source reference.
The customer requirement is to see LoV for ‘Selection Group’ in IFS.
I would like to know how do I achieve this. Can someone please help?
Thank you!
Disna