Skip to main content
Solved

LOVs not working when ordering BR reports from IFS Enterprise explorer

  • June 24, 2021
  • 1 reply
  • 315 views

Thiwanka Sandaruwan
Hero (Employee)
Forum|alt.badge.img+9

Hi,

 

When creating a BR report the developer has used quick information source which containing the "DIM_ACCOUNT" and “DIM_COMPANY” standard dimensions. Inside the report design, there is a parameter for the account. Since the company is the parent of the account, They have used a company parameter as well.

  • when the user orders that report from IEE, There is no LoV option for the account parameter.
  • When ordering it through the business reporter excel add-on, once click the LoV option of the account parameter it will pop up the company LoV as a prerequisite. (Please note that there is a separate parameter for the company and the user should select the values for the company before selecting the account parameter)

This company and account parameter LoVs properly working for some BR reports. Therefore I have compared the dimension joins of both information sources and there is no considerable changes.

If you have any suggestions or information regarding this matter please let me know.

 

LoV – List of Values

IEE – IFS Enterprise explorer

 

Best Regards,

Thiwanka Sandaruwan

Best answer by Nishadi Sumanathilake

Hi Thiwanka,

   Did you check whether dimension parents are set properly in this scenario? Noted that you have mentioned that when ordering through BR client it will pop up the company LoV as a prerequisite.

Following documentation provide more information on dimension parents and LOV’s. Hope this would be helpful for you.

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/030_configure_information_sources/020_ConfigureISDimensions.htm

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Forum|alt.badge.img+8

Hi Thiwanka,

   Did you check whether dimension parents are set properly in this scenario? Noted that you have mentioned that when ordering through BR client it will pop up the company LoV as a prerequisite.

Following documentation provide more information on dimension parents and LOV’s. Hope this would be helpful for you.

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/030_configure_information_sources/020_ConfigureISDimensions.htm


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