What is degenerated Dimension?

The fact table in below contains two additional attributes, order_id and order_line_id, which are neither facts nor foreign keys. These columns reference a specific order and the line number within an order respectively. They are dimensional attributes that have been placed in the fact table rather than a dimension table. Although they could have been placed in the order_type table, doing so would have dramatically increased the number of rows in the table. When a dimensional attribute is located in the fact table, it is known as a  degenerate dimension. - By Christopher Adamson

Multiple Datasource

I have two data source in physical layer one is Oracle another one is Essbase, In BMM layer Fact referring both data source tables,
My Question : Is it affect performance?.

I assume the grain is same, so no performance problem

Oracle by Example Link for Hyperion and Essbase

Installation
http://gerardnico.com/wiki/epm/epm_installation


Here is the Oracle By Example for Hyperion and Essbase

Hyprion Planning OBE
http://www.oracle.com/technetwork/middleware/planning/tutorials/index.html

Essbase
http://www.oracle.com/technetwork/middleware/essbase/tutorials/index.html

http://www.oracle.com/technetwork/middleware/essbase/tutorials/ess11-088612.html

Essbase Overview
http://essbase.ru/archives/4368

Sample application setup

http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/frameset.htm?apb.htm

 

OBIEE Discussions

When does new LTS (Logical Table Source ) gets created?

1. If aggregate tables available for same Logical Fact, create a new LTS and set the level appropriately.
2. If fact tables contains various level of data, each level can be filtered and create as new LTS.
3. If a dimension is snow flaked, then if report requires one of the snowflake. Then create a new LTS.

Good link for Column Hiding
http://nerdsofobiee.wordpress.com/tag/column-level-security/