DIFFERENCE between Dimensional Modeling and Cube ?

Difference between a Cube and a Star

Hello, I have a very basic question. Can anyone please, explain the difference between a cube and a star schema? I studied about Star schema. When I implement it in Oracle Warehouse Builder 11g, I have to create a cube. Am I doing right? regards,

Ad Hoc Reports Against Cube or Dimensional Model

I am building a data warehouse on the Microsoft BI Platform. The architecture will include a dimensional model database residing on SQL Server 2008 that is updated nightly from a daily snapshot of a production database. The architecture will also includ

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

Migration to Dimensional Modeling - Testing

Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the

Modeling help on dimension with many boolean value

Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

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

Big Data - Big Math and Enabling Customer Intimacy at Scale

Engagement Leader Job Opening If building and growing an early stage company is in your career plan... If you bring a comprehensive leadership and management playbook for how to deliver large-scale data-intensive solutions If you have an excellent

Difference between Call Centre and BPO?

Hello, everyone! I am an higher secondary passsed student and want to make my carrier in Call Center just because that is the only way out for me. Actually yesterday I gave an interview they asked me one question that what is the difference between a Call

Firefox Add-on: NoScript

https://addons.mozilla.org/en-US/firefox/addon/722 Who here uses NoScript for Firefox? I haven't mentioned it in my security setup/approach, but I have been using NoScript for several years. It almost feels wrong to surf the internet without

Who has daily pain

And what is its cause? I have pain most days and I believe it is trigger points. Its not the same as migraine, but it isnt totally different either. Today has been a frustrating day. I woke reasonable and was doing ok until I ate my lunch. I have

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.