Ad Hoc Reports Against Cube or Dimensional Model

DIFFERENCE between Dimensional Modeling and Cube ?

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

Operational Reporting from a Dimensional Model

Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

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,

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

Rule based algorithm to convert an ER model to a dimensional model

I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my

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

anyone use Talend for a production dimensional model build

I'm looking at Talend as they seem to be on a roll with the recent inclusion of Data Quality and Master Data Management components into their suite. Wondering what experiences anyone has had building a standard dimensionally modelled Datamart or Data

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

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

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

Next3 Work-in-progress

Well got to say this is really Electronic Reader out of the box, though it does have some hybrid features of a Tablet. I know what I was getting into. But no matter what I am welling to give a new startup company a try in this crowded Android Tablet marke

Sim Brothel v2.1.2 bug reports

Report here any bug you've found in the v2.1.2.

RP Basketball...The Road Back To World Championship 2010

Yeng Guiao is the best to coach the next National team, I hope he will include these players: the best line-up for me: Lordy Tugade James Yap Gabe Norwood Anthony Washington Kelly Williams Jared Dillinger Jimmy Alapag Jay-jay Helterbrand Asi