Solved

LOVs not working when ordering BR reports from IFS Enterprise explorer

  • 24 June 2021
  • 1 reply
  • 270 views

Userlevel 4
Badge +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

icon

Best answer by Nishadi Sumanathilake 25 June 2021, 05:56

View original

This topic has been closed for comments

1 reply

Userlevel 4
Badge +7

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