Hi Ig,Ok, I understand your approach, I am also at the start of the study, I'll try to keep you up to date on the possible infrastructures I'll try to set up.Concerning IFS analysis model prepackage, it would allow for the transfer of data from IFS App to datawarehouse and hosted by MS SQL Server thus it will create a datamarts and OLAP Cubes predifined for 11 departments (I don't know which ones). After this, you can connect directly to it via Power BI.I give you the links of the different documentations about it:Analysis Model Prepackage Presentation :https://docs.ifs.com/techdocs/Foundation1/010_overview/255_br_and_a/020_Analysis_Models/default.htm#Configuration_Tool Details of the package :https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/007_br_and_a/008_Analysis_Models/060_AnamodComponentStructureAndPackaging.htmAnalysis Models Setup :https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/007_br_and_a/008_Analysis_Mo
Hi ig_,Thank you so much for your answer !In order to have well understood, can you tell me if the architecture below is suitable :IFS Application - Database ↓ IFS Middleware Server (For planification and extract from IFS Database to SQL Server) ↓ MS SQL Express (With SSIS package) - It's my ETL for create OLAP Cube ↓ POWER BI connected to the SQL Server In your opinion, it's ok ?Moreover, do You know prepackage analysis model in IFS ? according to my research, it could help me a lot in my OLAP Cubes, if you can tell me more that would be greatThanksKinds regards
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.