dimension model for many indicators field

Time Dimension vs Measures in Minutes

Hi All, I would like to design the time in a multidimensional model. The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute. More specifically, let's suppose I have 10.000

Date Dimension or DateTime Field

Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best

star data model and reporting with different dimension groupings

Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,

Indicator Dimension or Fact Table

Sorry, this is a long explanation but I wanted to document the entire case. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a

Need to join dimension tables

Hi, I have a requirement to build canned reports in WEBI XI R3. The requirements are such that most of the reports are on the dimension tables and needs dimension tables to be joined. From a starschema prospective we cannot join dimension tables. My

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

Offers oil companies wishing to develop the field of Nasiriyah to the Council of Ministers

Offers oil companies wishing to develop the field of Nasiriyah to the Council of Ministers ---------------------- The Ministry of oil hits the world's oil companies wishing to develop the field of Nasiriyah to the Council of Ministers. The spokesman sai

Iraq signs contract to develope Gharaf oil field

Iraq signs final contract to develop Gharaf oil field Aswat Aliraq 18 January 2010 BAGHDAD: Iraq's Oil Ministry signed on Monday the final contract to develop Gharaf oilfield with Malaysian state oil firm Petronas [PETR.UL] and Japan

Battery For Sportdog Field Trainer SD-400 Reciever, MH120AAAL4GC

Part Number: DC-17 Type: NiMH Voltage: 4.8V Capacity: 170mAh UPC: 152423400017

CubeField

Prismaphobia; the fear of cubes. -Extracted from the dictionary of Fuji Planet Requested by Super. Post your highscores. Name of Game: Cubefield Rank Given: Objective: Get 100,000 as a score.

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from