Amritha FernandoExtracting base level elements in Application Studio using Custom MDXWhile developing a report I received from one of our clients, I came across an instance where it was needed to capture the lowest level…Jan 23, 2020Jan 23, 2020
Amritha FernandoMake your data work harder with Infor M3 Analytics“The world’s most valuable resource is no longer oil, but data.” — The EconomistJan 20, 2020Jan 20, 2020
Amritha FernandoTypes of Data Warehousing ArchitectureA Data Warehouse is referred to as a subject-oriented, integrated, time-variant and non-volatile collection of data which makes a…Oct 10, 2018Oct 10, 2018
Amritha FernandoSolution to SQL Temporary Tables not being supported in Application StudioWhile working on another requirement requested by a client, I came across a scenario where a Stored Procedure which I needed to use to…Sep 18, 2018Sep 18, 2018
Amritha FernandoExecute Package TasksFor an instance lets consider a scenario where we already have two SQL Server Integration Services (SSIS) Packages in SQL Server. These…Jul 20, 2018Jul 20, 2018
Amritha FernandoSUMIF2 Function In Application StudioIn the current project I am working on, I came across a scenario where a Monthly Financial Statistics Report needed to be developed for the…Apr 24, 2018Apr 24, 2018
Amritha FernandoSTAR SCHEMA VS FACT CONSTELLATIONStar Schema is a dimensional model which usually segregates data related to a particular business into dimensions and facts. Usually the…Jan 4, 2018Jan 4, 2018
Amritha FernandoTYPES OF DATA ANALYTICSThere are four main type of analytics and they are as follows :Jan 4, 2018Jan 4, 2018
Amritha FernandoINFOR BI DATA LAYER AND MODELLING PLATFORM COMPONENTSThe “Infor BI Front-End Platform Components” story consists of an overview to three components involved in the front-end platform. Now…Jan 4, 2018Jan 4, 2018
Amritha FernandoINFOR BI FRONT-END PLATFORM COMPONENTSThe “Overview Of Infor Business Intelligence” story consists of an introduction to Business Intelligence, how information flows into a…Jan 4, 2018Jan 4, 2018