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

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

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

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

DIFFERENCE between Dimensional Modeling and Cube ?

Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?

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

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

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

I Will Build Your Downline

Hi, Are you the kind of Network Marketer that feels they can't build a downline? That it doesn't matter what the opportunity is you just don't seem to get anyone to join your team. You join a business and 30 to 60 days later you quit because

Guy Garvey on this week's Big Issue

I just bought my Big Issue copy this week and was quite pleased to read a short but sweet interview with Guy about the Jodrell Bank show and sending music to outer space! Another good excuse to get a copy from your local vendor until tomorrow. I am

The Night will Always Win

Okay then - this is my favourite track on the album (at the moment!). They do seem to have a real tear jerker on every album - SBAW, Switching Off, Great Expectations, Friend of Ours and this one on BARB. The emotion Guy put into singing this is

build a rocket boys!

The new album, 'build a rocket boys!', will be released on March 7th. 1. Lippy Kids 2. The Birds 3. With Love 4. Neat Little Rows 5. Jesus Is A Rochdale Girl 6. The Night Will Always Win 7. High Ideals 8. The River 9. Open Arms 10. The Birds

McT's long term HTPC build :D

Some of you may already know i am looking at making a HTPC. This was original planned last year but for one thing or another it got put back due to other things. Now this year i want to complete it. Going to be using a few second hand items ( as its only