Question

Business Reporter - New "Information Sources"

  • 11 August 2020
  • 1 reply
  • 495 views

Userlevel 1
Badge +3

Hello - BR comes with a standard list of “information sources”, how do I add additional sources from within IFS?

My current specific example: I am looking to add the source “Inventory Parts Unit Cost” from the Warehouse Management-Financial Control path…

Have few other needs so this would be very helpful!

Thanks


1 reply

Userlevel 7
Badge +24

Hi,

It is possible but it takes a bit of effort.

You go to a screen called Quick Information Sources (IFS EE), then Draft a Quick Information Source (QIS).

You can base it on a standard LU/View, or on an IAL (custom view).

Then click “Create an Information Source from Selected QIS Draft”.  You’ll be able to see it in Information Sources window.

This creates database objects. You will likely have to grant the Information Source to your user before you can use it in a report (search for database objects like QFACT% and QDIM%)

There is a LOT to know about creating the information source, types of attributes (light, measures etc.) and connecting dimensions (you can create Quick Dimensions in much the same way).

There is pretty good documentation in the IFS online help, so I would recommend you review that.

Hope this helps!

Reply