Question - creating a dimensional model for facility management

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

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

Data Warehouse for survey data

Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

Multiple measures in a fact table- modelling question

Hi all, First, sorry for what may be the super easy question for you... There are around 100 different metrics with the same grain to be analyzed against the same set of dimensions. The initial idea was to build one big table ~100columns wide with a

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

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

Blender 2.55 Creating A Racing Game - Setting Up the Car Part 1

By TheAdminjr

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

MC creating multilple AVI files

Hi, Im new to MC and trying to get it to work. I downloaded the lastest version from these forums. So far with reasonable success. The issue I have now is that MC is creating a duplicate (empty) file for each

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

[ Credits Management ] ~ Buy More HTML Pages

Hello, I would like to suggest that forum owners should have the right to purchase more html pages for their forum. This could be done Via Credits Management. Administration Panel=>Misc Tab=>Credits Management=>Spend Credits=> From

When Reseting Passwords add a Security Question(s)

Hello, I suggest that we add a security question(s) in case you forgot your password. You can add up to three questions and have to get 2 out of the three to be able to reset your password. When we click on Forgot password we have to enter are email

New Update: JavaScript Code Management

Important AnnouncementNew Update: JavaScript Code Management Hello, In an effort to continuously improve our services, and in response to numerous requests from our members and the difficulties they have had to host their Javascripts files on an