Author: Chuan Shi Purpose and Audience This article explains how to configure an ETL source file for time dimension from PeopleSoft (PSFT) adaptors, i.e.,...
Author: Chuan Shi Purpose and Audience This article explains how to configure an ETL source file for time dimension from PeopleSoft (PSFT) adaptors, i.e., file_summary_calendar.csv. This file is needed to populate the fiscal quarter information for fiscal calendars sourced from PSFT. It applies to all Oracle BI Apps customers who use PSFT sources. Oracle BI Apps supports calendars of different natures, including Gregorian calendar, fiscal calendar, and enterprise calendar....
Author: Chuan Shi Purpose and Audience This article explains how to configure an ETL source file for time dimension from PeopleSoft (PSFT) adaptors, i.e., file_summary_calendar.csv. This file...
Author: Akshay Satyendranath BI Apps 11.1.1.7.1 supports 26 chartfields with 3 of them considered to be mandatory chartfields and are mapped to specific...
Author: Akshay Satyendranath BI Apps 11.1.1.7.1 supports 26 chartfields with 3 of them considered to be mandatory chartfields and are mapped to specific dimensions as shown below. Department – Cost Center Dimension Fund – Balancing Segment Dimension Account – Natural Account Dimension All the remaining chartfields are mapped to one specific dimension which is GL Segment Dimension. The physical table is shared for all chartfields but there are multiple logical dimensions in...
Author: Akshay Satyendranath BI Apps 11.1.1.7.1 supports 26 chartfields with 3 of them considered to be mandatory chartfields and are mapped to specific dimensions as shown below. Department – Cost...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted for in a system. A data warehouse that stores and analyzes Items or Products must have a UOM standard defined. This post describes OBIA requirements, design and implementation of UOM What is UOM Conversion Let’s start with an example: Let’s say on 15th Jan, 2013 100 Ea of Mont Blanc pens were sold. Here Ea is Each which...
Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted for in a system. A data warehouse...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store various numerical information including amounts. Example; Order Amount, Invoice Amount etc. With the true global nature of business now-a-days, the end-users want to view the reports in their own currency or in global/common currency as defined by their business. This presents a unique opportunity in BI to provide the...
Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store various numerical information including...