Reporting and Data Warehouse

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

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

Hello Shaun,

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

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

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

​@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

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.