ETL as a source for some attributes of a dimension

Different dimensional attributes in different 'dimension-like' source tables

This is a simplified version of the modeling issue that I am facing. Looking to the experts for advice. The product dimension has three attributes- sku, color and weight. Each attribute is stored in its own table with its own transaction date and

Facts or Dimension Attributes?

My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th

User Defined Dimension Attributes

I have a business requirement that is somewhat stretching my modelling skills. The application is a highly sensitive one so Ill describe the problem using a Sales Datamart template. There are 7 plus fact tables, 1 is updated monthly, the rest

Conformed Dimension Partial Set of Attributes

Hi Just looking for some confirmation that a dimension with partial attributes might still be considered conformed. For eample A dimension of batch ProdBatch PK BatchID Batch Name Product ID Product Name ... at an invoice Fact table

attributes depending on more than 1 dimension (2 dimensions)

suppose you have - a discount code attribute - a status attribute which depend on the combination of the dimension customer & the dimension product. You want to be able to relate these attributes to a fact table invoice details. What are the

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Hello, We are in the process of designing a DW for Games and have run into a business problem : Business users want to add attributes to a dimension and decide its level in the hierarchy on the fly. The new attributes should be availabe in reports

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

OPEN SOURCE CHARACTERS PUBLISHED BY M.K.U.I.I.

UNCLE-SAM OZ DOROTHY GALE TWISTED TIN-MAN OZMA THE BEAST BEAUTY TARZAN Open Source Characters are characters created specifically for, or later made available for, use by anyone. The main difference between "Open

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

how to add down down menu in forumotion

can anybody teach me how to add down down menu like here -->http://www.noupe.com/tutorial/drop-down-menu-jquery-css.html i like it because it really rocks!

Dimension with two hierarchies

I need to design a dimension with two hierarchies 1. Location -> Building -> Room -> Cabin 2. Location ->Building I need the hierarchy 1 to be referenced in one FACT table and hierarchy 2 in other FACT. But my ETL tool allows only the dimension ke