Skip to main content
Solved

using custom querries via ifs business reporter

  • March 20, 2024
  • 1 reply
  • 114 views

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

Dear all,

Can we use database querries in ifs business reporter?

How can we use our custom queries in the Business Reporter using this tool? I ‘m currently seeking know-how regarding this matter.

Best answer by SandT

Hi @sevo ,

Yes, It is possible.

By creating IAL based quick information sources, You will be able to create BR reports.

  1. Create an IAL using your DB query.
  2. Draft a quick information source or quick dimension.
  3. Create information source.

Please refer below documentation to get more details about quick information sources and IALs.

 

IAL Object Developer (ifs.com)

 

Overview (ifs.com)

 

Quick Information Source Examples (ifs.com)

 

If you need any further support or information please let me know.

1 reply

SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 31 replies
  • Answer
  • March 22, 2024

Hi @sevo ,

Yes, It is possible.

By creating IAL based quick information sources, You will be able to create BR reports.

  1. Create an IAL using your DB query.
  2. Draft a quick information source or quick dimension.
  3. Create information source.

Please refer below documentation to get more details about quick information sources and IALs.

 

IAL Object Developer (ifs.com)

 

Overview (ifs.com)

 

Quick Information Source Examples (ifs.com)

 

If you need any further support or information please let me know.