Multi valued dimension attributes, weighting factor and cognos

Multivalue attributes

I am working on a model for use by the fund raising unit of our university. They want to be able to do some CRM type reporting on our alumni / donor data. In creating a constituent dimension I have found that there are a large number of attributes tha

Multi-valued dimension with distinct attributes

In the health care data analysis DW, the grain of one of my fact tables is the episode of care. How can I include procedure codes performed on an episode ? if I create a multi-valued dimension for it and used bridge tables to model this, it will end up

What to do when the weighting factor of a bridge table no longer seems relevant?

I have a fact table that has healthcare claims data. Since a given claim can have multiple diagnoses, I'll use a bridge table that links a bridgekey from the fact table to the bridge table. The bridge table will also have a diagnosiskey that ultimately

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

Multivalued Dimension or Multiple facts w/conformed dimensions

I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level

Cognos 8 Report studio SQL problem

The project is working out the Average Net Selling Price. This is Grouped by Period and Average Net Selling Price(ANSP), and then working out the running total % of volume(KG) by ANSP. You then proportion the ANSP in to case statement buckets and wor

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

Multi Disc Movies and Multi Disc TV Shows

What is the proper way to handle a movie that has multiple DVD's? And what is the proper way to handle Season Compilations of TV shows?

SET1/ Q 4. Briefly explain any two factors that affect the choice of a sampling technique.

Q 4. Briefly explain any two factors that affect the choice of a sampling technique. What are the characteristics of a good sample?(10 marks).

SET2/Q. 3 Explain in brief APT with single factor model.

Q. 3 Explain in brief APT with single factor model.

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

Multiple clickable portions on a Image.

Multiple clickable portions on a Image. Using HTML make Mutliple portions on a image clickable Hello Everyone This is a very simple tutorial to make multiple clickable areas on your image. Enter this code into your HTML Page. Code:<img

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