Compound key attributes

Big dimensional attributes

in the customer dimension, there are a lot of descriptive column, information field by the customer etc ie in the relational database, many big column, like nvarchar(200), nvarchar(200) ,nvarchar(1020) (around 50 fields or even more). I simply cannot ad

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

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

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

Dimensional Attributes

Hello, I have a requirement where a dimension can have potentially hundreds of attributes that can change over a period of time. The end reporting requirement is that we should be able to run the report where we select a combination of attributes. A

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

SET2/ Q 3. What are the characteristics of a good research design?

Q 3. What are the characteristics of a good research design? Explain how the research design for exploratory studies is different from the research design for descriptive and diagnostic studies.( 10 marks).

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

Fct clarification

Hi all, For an insurance company, I am trying to come up with the dimensional model for claims. A claim has attributes like Date of Loss Date Reported Status Date Cause of loss Authority Contacted Claimant Reported by..... etc I can see tha

How to Handle Data that serves as both a dimension and attributes of another dimension

I have a invoicing warehouse with two fact tables. First is an invoice header fact table which reports on invoice totals and includes a surrogate key for a stat code that was assigned to the invoice. The grain is one row per invoice. Next is a part