Skip to main content
Question

Reporting and Data Warehouse

  • October 16, 2024
  • 7 replies
  • 142 views

Forum|alt.badge.img+11

Afternoon,

We are in the midst of upgrading to IFS Cloud 23R2 from Apps 10, and in parallel the business are reviewing our BI strategy. Currently we use IFS Lobbies, Quick Reports and Business Reporter within IFS, and externally use tools such as PowerBI and Qlik. All our reporting is based on the production IFS Oracle database through ODBC connections. 

We plan on using PowerBI as the primary tool for management reporting, whilst continuing to use Quick reports and Lobbies for operational reporting within IFS.

We are therefore considering options for data warehouse solutions such as Microsoft Fabric and PowerBI.

 

We are looking for information on what other IFS customer's are using for their BI strategy and data warehousing solution, along with some pros and cons.

 

Thanks in advance

7 replies

Forum|alt.badge.img
  • Do Gooder (Customer)
  • 1 reply
  • February 13, 2025

Hi ​@SHAUN_KERSLAKE ,

We are in the midst of upgrading to IFS Cloud too (but to IFS 24R2) and we plan to use Power BI and maybe Microsoft Fabric. Have you found any information or solution to your situation?

 

Thanks and regards

 


Forum|alt.badge.img+11
  • Author
  • Hero (Customer)
  • 115 replies
  • February 13, 2025

Hello

Our BI team are currently conducting proof of concept with MS Fabric which will use PowerBI as the end reporting product on top of Fabric for business KPIs.

We will still continue to use Lobbies, Quick Reports for operational reporting.

I believe the BI team are working with an vendor in the UK to help with the implementation of Fabric.

Regards

Shaun


Forum|alt.badge.img+4
  • 7 replies
  • February 26, 2025

Hello Shaun,

Is it possible for you to share th UK vendor name ? Thank you !


Forum|alt.badge.img+11
  • Author
  • Hero (Customer)
  • 115 replies
  • February 28, 2025

@ANMMOUNIR  - company called Climber www.climberbi.co.uk


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 17 replies
  • February 28, 2025
SHAUN_KERSLAKE wrote:

Afternoon,

We are in the midst of upgrading to IFS Cloud 23R2 from Apps 10, and in parallel the business are reviewing our BI strategy. Currently we use IFS Lobbies, Quick Reports and Business Reporter within IFS, and externally use tools such as PowerBI and Qlik. All our reporting is based on the production IFS Oracle database through ODBC connections. 

We plan on using PowerBI as the primary tool for management reporting, whilst continuing to use Quick reports and Lobbies for operational reporting within IFS.

We are therefore considering options for data warehouse solutions such as Microsoft Fabric and PowerBI.

 

We are looking for information on what other IFS customer's are using for their BI strategy and data warehousing solution, along with some pros and cons.

 

Thanks in advance



Hi, 

We are using Data Factory, in our azure tenant, to push data from IFS Cloud (directly from the oracle database) to Snowflake as a centralized, cost effective, warehouse/datalake. Visualizations/ligt analyzis for end users we are using Power BI.

This setup works generally well, altough we have stumbled upon core bugs now and then after upgrades of IFS Cloud.

Kind regards,
/Magnus


Forum|alt.badge.img+11
  • Author
  • Hero (Customer)
  • 115 replies
  • February 28, 2025

@TIVMAGFRI Thanks for providing your feedback. 

Are you able to provide any details about the use and implementation of Data Factory and Snowflake please? What made you choose this over other products in the market?

The core bugs are these related to IFS Cloud or the 3rd party products? 

Thanks


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 17 replies
  • February 28, 2025

Snowflake was a decision we made before IFS Cloud, based on previous experience and cost. It’s a powerful solution, completly cloudbased and cost efficient (you mainly pay for computing power, not storage).

When we started our BI journey with IFS we initially went with the “Self hosted BI” solution. It turned out to not match our need, and is quite costly, but DataFactory is an important part of it. Therefore we simpy continued to use it when we shifted away from the “Self hosted BI” solution and decommissioned all other parts. In my experience it’s an efficient solution to push data between systems, nothing fancy but works fine. For transformation of data we rely on DBT.

The core bug is within IFS Cloud and currently impacts a specific view that’s not working using incremental load. It’s planned to be fixed in SU4 and the bug was introduced in 24R2.

If theres one thing I really lack it is proper documentation of how all entities are connected within IFS. This is something we do not have access to which mean that it require a significant amount of investigation to figure out what data, from where, you need to do specific analysis. This you need to be aware of when going outside IFS provided models.


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