In the previous post we created the physical model by importing the table schema from the database. Next we will create the logical model for the inventory_fact_1997 table and connected dimensions.1. Select the following tables from the physical layer and drag them to the logical model layer.inventory_fact_1997productstoretime_by_daywarehousemake sure that you drag all the tables at … Read more

OBIEE stores its physical and logical schema in a repository. The repository is a file with an extension of .rpd In this post we look at creating a new repository and importing the physical schema metadata from the foodmart datasource created in the previous post.1. Open the Oracle BI server Administration page. Go to Start-> … Read more

We will be using the sample food mart database for all tutorials. Please look into the introduction blog to obtain the link for this database.In this post we look at creating a datasource to the foodmart database in MySql. The screenshots are from a windows XP machine.Steps to create the data source.1. Goto Start -> … Read more

In this series of post we will look at Oracle Business Intelligence Enterprise Edition.The source database for the examples is the foodmart database which can be downloaded from here . Look at this blog from more details on this database.The blogs will cover the following: Creating a repository. Using Answers Creating Dashboards Using BI publisher … Read more

Performance management is critical to an organization’s success. The top management spends a lot of time in making sure that the company’s day to day activity is aligned with its long term goals. The facets of performance management are :1 Alignment – The top management needs to align the business processes of a company to … Read more

Problem : We wish to determine whether or not four different tips produce different readings on a hardness testing machine. An experiment such as these might be part of a gauge capability study. The machine operates by pressingthe tip into a metal test coupon, and frm the depth of the resulting depression, the hardness of … Read more

Problem: A product development engineer is interested in investigating the tensile strength of a new synthetic fiber that will be used t omake cloth for men’s shirts. The engineer knows from previous experience that the strength is affected by he weight percent of cotton used in the blend of materials for the fiber. Furthermore, she … Read more

Problem : The tension bond strangth of portland cement mortar is an important characteristic of the product. An engineer in interested in comparing the strength of a modified formulation in which polymer latex emulsions have been added during mixing to the strength of the unmodified mortar. The experimanter has collected 10 observations on strength for … Read more

Experiments are performed in various fields to understand the behaviour of a system. In this post we will analyse the common terms used during an experiment design. Experiment : An experiment can be defined as a test or a group of test wherein changes are made to the input variables and the effect of that … Read more