Skip to main content
Question

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

  • March 21, 2020
  • 1 reply
  • 268 views

Forum|alt.badge.img+5
  • Do Gooder (Partner)
  • 10 replies

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

paul harland
Superhero (Employee)
Forum|alt.badge.img+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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings