Further reading for Recursive Hierarchy Data Modelling

Issue with modelling a hierarchy so the OLAP cube build is efficent

I am faced with a nasty which seems to have no neat solution within dimensional modelling. (This could well be just me being brain dead and dumb). Background: We are a major commercial bakery company. Having re-developed and released the first two

Organizational hierarchy with employees and SCD

Hi, I have a question on modelling SCDs with my tblDimPosition dimension as depicted in my star schema here: /dimensional-modeling-and-data-architecture-f6/modelling-free-text-comments-t784.htm My tblDimPosition basically contains employee data

multiple hierarchy : single dimension vs multiple

Hi Need to analysis sale revenue by store. We have two separate hierarchy for geographic location 1. Country / County / Council / Store name 2. Country / Region / Area / Store name Need valuable suggestion for how to design dimension for above to

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

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

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

Full reading news permisions

Hi, I suggest [ Full Reading ] in portal news permissions Example: Who can Full read news in portal? [ Members ] [ Guests ]

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Rules and Guidelines for All

RULES FOR MEMBERS It is my humble request to all members who post their palm images for reading, please read the RULES of the forum carefully before posting your palm images for reading. You should spend some time going through the forum before postin

SET1/Q. 3 Explain the different types of reading that you have to engage in as a business executive.

Q. 3 Explain the different types of reading that you have to engage in as a business executive.

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

Reading & Leeds Festival

elbow will be playing before headliners Muse on the Main Stage on Fri 26th August in Leeds and Sunday 28th August in Reading. Well, that's what the announcement tonight will tell you anyway!