Facts at different levels of hierarchy

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

Conformance of Dimension for facts aggregated at different levels

I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files

Facts at different levels.

Hi Everyone, The data I have has no perticular grain statement on which I can base my model.. Can someone suggest a better design for this scenario, Simplified version is,... I have 2 dimensions 1) Property.. Heirarchy is Site -> Building

Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table

Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table

Further reading for Recursive Hierarchy Data Modelling

Hi all I need to research Recursive Hierarchy Data Modelling in depth. I have read: www.dbmsmag.com/9809d05.html Can any readers of this forum point me in the direction of any other _detailed_ material on this subject? With anticipatory

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

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

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 >> =

new ptc 5 referral levels

I am starting a new ptc. www.Goldptc.info It is in beta mode now but you can signup. All signups before Jan 1 will be upgraded to gold member for free. 5 tiers of referrals There are a couple ofd ptc ads and pay to signups on the site now.

Some Practical Challenges

Hi All I am facing some challenges in my dimensional modeling and most of these are covered in many books too.But i have practical limitation for that 1st Challenge :Unbalanced Hierarchy In one of the dimension we are tracking employees and their

KPI Goals and Percentages as Dimensions or Store as Facts?

We are using PPS Monitoring for our Dashboards and we are creating our KPIs within PPS and SSAS. Our client would like to create a dimension with these KPI goals and percentages for each goal per department and measures or add to the fact table. Now

Random Facts October

They grow up so fast! RF: The staff is organising a birthday party for the forum, but don't tell anyone!

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