Multivalue attributes

Dimension with multivalue attributes

I can't seem to wrap my brain around this one, need some help. Data model is simplified for the example given here: fact: Interview dimension: applicant The grain is obviously interviews, however the users want to be able to report interview

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

Modeling multiple multivalued dimensions and other design questions

Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in

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

Compound key attributes

Hi all I am struggling with following design issue: in our organization, a number of attributes (such as account executive, flagship store) are defined by the combination of customer and brand, where brand is a rollup of a product. Our sales fact tabl

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).

"Previous" attributes

I am working on a HR Enterprise datawarehouse. I have a requirement for a number of "previous" attributes. For example, an employee's previous business unit, supervisor, last name. Business Unit, Manager already have their own Type 2 SCD

Topic attributes?

Would you like Topic attributes? They are just extra but I want them, instead of making the pictures, like making the text color what you want, what text you want etc. here is a screen shot of the examples: The 'Waiting' and 'In Progress'. It

dimension attribute denormalisation in fact table

Hello, in our data warehouse, we have a fact table containing about 100 million rows per month joined to a customer dimension containing about 10 million customers. The customer dimension contains 30 attributes. Two of these attributes are very