Question

LoV not shown from IFS/Order report, but in Business Reporter for Selection Group (HR)

  • 21 March 2020
  • 1 reply
  • 228 views

Badge +5

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

 

 


1 reply

Userlevel 7
Badge +24

Hi @disnam 

I was able to get a similar requirement working this week.  But I used a QFACT and QDIM (quick fact and quick dimension).

Are you still stuck with this?

If so please post a picture of your Dimension

Reply