Conformance of Dimension for facts aggregated at different levels |...

Dimension Hierarchy - Facts by various levels

Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level

Facts at different levels of hierarchy

Let's say I have an empoyee dimension consisting of the usual attributes describing a person, but also these two: Department and Company. Let's also say I have budget numbers for the three levels (Employee, Department, and Company). I would think tha

Aggregated Date Dimension

In my dimensional model, I have a Date dimension that plays many different roles in multiple fact tables. I will also have a fact table that store metrics aggregated at the Month level and one that stores metrics aggregated at the Quarter level. How

Aggregated Measure

Gurus, I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an

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

Have You Scrutinized The Facts About Juicing, Healthy Diet, Juicing For Better Health

By David Wellsford We are all very aware today the benefits of good nutrition, and the vitamins, and minerals that are necessary for our health. What do we know about juicing, healthy diet, juicing for better health? What does juicing mean? Making

Interesting science facts - 50 amazing science facts

1. Word "Science" derives from Latin word scientia meaning knowledge. 2. Human need approximately 12 hours in order to entirely digest the food. 3. Brain cells are the longest living cells in our body, they can last for an entire lifetime. 4. Som

16 Amazing Science Facts

1. Fingernails grow four times faster than toenails 2. Right handed people live, on average, nine years longer than left-handed people 3. If you rub an onion on your foot within 30 60 minutes you will be able to taste it this is because it

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

PTC With 7 Referral levels deep

Hi , Do you know the answer to this question? "Which would you rather have, $1,000,000 CASH or a penny that doubles every day for 30 days? Did you pick the cash? BIG Mistake!!! a penny that doubles every day for 30 days >> =

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

10 Random Unknown Facts

Lets all get to know each other a little better! Write ten facts about yourself that others probably don't know, and lets get to know the person BEHIND the YouTube name! 1. Im very insecure about myself in real life. Whenever I appear confident it is

Different Levels of access to the Admin panel

I trust some people to do as i tell them, provided there isn't anything they can mess with and break so when i want a certain person to create a forum for me when i'm busy it can only be an admin instead of a mod, There should be maybe two or three