In warehouse all tables as conformed dimension only. Degenerate dimension in obiee a degenerate dimension dd acts as a dimension key in the fact table, however does not join to a corresponding dimension table because all its interesting attributes have already been placed in other analytic dimensions. Conformed dimensions allow facts and measures to be categorized and described in the same way across multiple facts andor data marts, ensuring consistent reporting across the enterprise. In obiee rpd getting an errorthe content filter of a source for logical table. Information from separate fact tables can be combined in a single report by using conformed dimension attributes that are associated with each fact table. Below is a basic sample of the model im working with. Conformed rollup is a subset of data from a dimension table and the subset of data share the same structure and content. Dimension only reports with implicit fact column does not work in obiee 11g doc id 1554438. Unlike most of our other dimensions, we can build the date dimension. National jeff day on hr analytics at wells fargo the best of 2014 a on minimalist design for the crit obiee 100 ob on build your own time hiera summer loving on minimalist design for the crit. Non conformed dimensions with fact 11g hi all, i am on 11.
A non conformed dimension is where you add an attribute to an analysis which does not logically relate to all the facts. Obiee same dimension different value measures obiee. How to show totals of a measure if the dimension is not. They are used to compare the measures from each star schema 3. To use them on a particular dimension, you have to designate the dimension as a time dimension and set one or more keys at one or more levels as chronological keys. How to show totals of a measure if the dimension is not part of the fact table in obiee. We can then use these aliases in our bmm to form one or more roleplaying dimension tables for our facts. The measures of the fact were set to the total level of the non confromed d. Conformed dimension in obiee the best definition about conformed dimension is that it is dimension which is consistent across the whole business and can be linked with all the facts to which it relates.
In data warehousing,conformed dimension is a dimension that has exactly the same meaning and content when being referred from different fact tables. Today id like to extend that discussion with the importance of conformed dimensions. Conformed dimensions kimball dimensional modeling techniques. After you associate logical columns with a dimension level, the tables in which these columns exist appear in the tables tab of the dimension dialog. I have 2 dimensions say date and product and 2 fact tables say sales and returns. Obiee 11g create a logical dimension for product 1. I think this would be a good place to talk about what kimball refers to as the bus architecture. And that is the idea of conformed dimensions in a nutshell cross process analysis. In most cases, the requirement is for combining these metrics with conformed and non conformed dimension attributes. This obiee 11g video training tutorial demonstrates how to create dimension hierarchies in the business model and mapping layer bmm.
A nonconformed dimension is where you add an attribute to an analysis which does not logically relate to all the facts. The date dimension is the one dimension nearly guaranteed to be in every data mart because virtually every data mart is a time series. When you have a requirement like multiple fact tables are being used in your reports on dimensions those are not conforming to all those fact tables. Shared dimension when a fact table shares the same logical dimension as another fact table in another star or data mart. Unable to create multiple subject area analysis in obiee 12c with a. In obiee, while defining the business model and mapping, we can define the aggregation rule on fact columnstables. Yesterday i talked about the differences in dimensions versus facts. The problem that remains though is that prompting a report on a nonconforming dimension will have obiee at a loss on how to aggregate a metric along a dimension it is not linked to. Suppose i have two facts f1 and f2 and three dimensions d1 and d2. Obiee how to work with logical dimension objects in bmm. Obiee 11g dimension hierarchies obiee online training. Obiee 11g conformed dimensions and alias tables i figured out that most of the newbies in obiee struggle with basic concepts of data warehousing and how to deal with them. Obiee 11g cross subject area reporting with enable.
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. We have two options for producing the nonexistent date dimension. Business intelligence server enterprise edition version 11. Content tab, dimensions, hierachies, hierarchy, level based metrics, levels, non conformed dimensions, obiee. Bidirectional filter on conformed dimension microsoft. For example, a customer dimension appears in a revenue data store, but not in an inventory data store. Date is a common conformed dimension because its attributes day, week, month, quarter, year, etc. This is a levelbased hierarchy and will be used to show. Your second example is a nonconformed dimension, as long as a company is a company. Dimension hierarchy levels are used to perform aggregate navigation, configure levelbased measure calculations, and determine which attributes appear when oracle bi users drill down in their data requests. For two dimension tables to be considered as conformed, they must either be identical or one must be a subset of another.
How do you create a dsn in obiee 11g datawarehouse architect. Browse other questions tagged repository dimension obiee measure calculation or ask your own question. The conformed dimension is consistent across an enterprise and has the same meaning to every fact with which it relates. This is only possible if all star schemas that should be analyzed in crossbusiness process analysis use exactly the same dimension, with. In the first screenshot you can see that both dimensions have relationships to both fact tables in a 1many format. Non conformed dimension in obiee 11g oracle community. A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts.
Aggregation based on dimensions in obiee beyond blog. One of the major advantages of a data warehouse is the ability to combine data from various, and sometimes vastly different, systems. The date dimension is an example of a shared dimension. In obiee rpd getting an errorthe content filter of a. You have to put the content level for the nonconformed dimension to the grand total level. Every dimension logical table should have a corresponding dimension hierarchy with total as a grand total level, and detail at the lowest level number of elements each level of a dimension hierarchy should have its number of elements appropriately set there is a utility in tools that can do this automatically. Obiee prompting on nonconformed dimensions perficient blogs. Obiee dimension logical table gerardnico the data blog. For two dimension tables to be considered as conformed, they must either be identical or one must be a subset. Non conformed dimension filter hi, i have two fact tables and some confromed and non conformed dimensions between the fact tabels.
In fact, date is usually the first dimension in the underlying sort order of the database so that the successive loading of time intervals of data is placed into virgin territory on the disk. Of course conformed is a fancy word meaning can be used across multiple facts, also known as shared. Conformed dimension an overview sciencedirect topics. Dimensions are conformed when they are either exactly the same including keys or.
A conformed dimension is a dimension that have relationships with many fact tables not only one. Lets take the example below of the 2 stars for timecard and capacity with their corresponding dimensions. Obiee application server helps to work on client components and oracle provides oracle10g application server with obiee suite. Handling nonconformed dimensions a great feature with. There cannot be any other type of difference between the two tables. Now that we understand how to build a dimensional model based on star schemas built upon fact tables and conformed dimensions, lets walk through an example of how to create a crossprocess metric.
In dimensional modeling, conformed dimensions are common and repeatedly used dimensions that relate and are joined to multiple facts. Dimensions that appear in multiple data stores are conformed if their structure is identical for all of the following. Why conformed dimension is so important data warehouse. We can build a date dimension in our transactional database, or in our foundation layer, and create aliases for this physical table in the obiee physical layer.
Conformed dimension ensures that the facts and measures are the same across all facts and data marts so that reporting is consistent. The hiearchies being built and proper levels were set for the fact tables. The business model in obiee allows for measures to be aggregated using a variety of different functions. A conformed dimension is important because it allows to drill across. Can anyone tell me how to handle non conformed dimension with multiple fact tables in obiee 11g. Conformed dimensions dimension tables conform when attributes in separate dimension tables have the same column names and domain contents. We will discuss about what is conformed dimension and its advantages in data warehouse. In 11g, you can add that hierarchy to the presentation level. Ive used it before in customer presentations as a tool to explain exactly what a conformed dimension was and why they were important. Conformed dimensions are dimensions that are shared by multiple stars. Among them is conformed dimensions and alias tables what are they and when to use these concepts. Non conformed dimension filter vinodh nk jan 4, 2012 12. In the bmm layer, rightclick the sample sales business model and select new object logical dimension dimension with levelbased hierarchy to open the logical dimension dialog box.
Data warehouse design techniques conformed dimensions. There is a great new feature introduced with oracle bi 11. Great bi with oracle bi oracle bi obiee best practices by jeff mcquigg. Lets restate the problem a bit using good bi language. We might implement this as three views on the calendar dimension, it is still a conformed dimension, but it might appear to the user as three separate dimensions. Business intelligence suite enterprise edition version 11. A conformed dimension is a dimension that has exactly the same meaning and content when being referred from different fact tables. However, the products dimension and the time dimension appear in both data stores. Ago and todate they are supported for all relational database and for use with essbase.
In obiee, we typically solve this by making levelbased measures lbms for the fact measures to the non conformed dimensions at the totalall level. It is responsible to schedule jobs in obiee repository. A conformed dimension can refer to multiple tables in multiple data marts within the same organization. Typically, a conformed dimension exists as a single dimension table and relates to multiple. Take this example, here we have an analysis with 2 facts and 1 conformed. The following picture shows how sales fact table is joined in a onet0many relationships with other dimension tables. Dimension only reports with implicit fact column does not. Oracle bi server ships time series conversion functions. For example, if we are recording sales by month, then sumsales will allow us to report on those amounts at a higher level such as year.
This is easy when the analysis is using all conformed dimensional attributes. After creating a dimension, each dimension can be associated with attributes columns from one or more logical dimension tables and levelbased measures from logical fact tables. Obiee 10g11g how to set up the time dimension for time. When i try to fetch data from all the 4 tables then i am not getting data for f2 and also i. The reuse of conformed dimensions is very common in order to support true, crossbusiness process analysis 6.
622 27 722 1025 923 1119 309 1292 1136 446 1266 1213 170 176 277 1348 1506 1178 1502 506 1327 864 1158 1069 1012 272 1345 853 930 326 1465 1346