use of degenerate dimension to physically join two logically relate...

Need to join dimension tables

Hi, I have a requirement to build canned reports in WEBI XI R3. The requirements are such that most of the reports are on the dimension tables and needs dimension tables to be joined. From a starschema prospective we cannot join dimension tables. My

two facts that relate via degenerate dimension

Hi, I have a order line fact which look like this: Order Line Fact ------------- Order Line Key (SK) Order Line number (DD) Order Number (DD) Some measure (fact) Now some time later I have another fact which would reference the Order Number

Monster dimension, joining fact tables

I am newbie to the DW. We have document processing OLTP system with the following tables Document table (partitioned table, approx. 1 billion rows) DocId -PK Title DocDate 10 other columns Users table UserId -PK UserName .. 3 other

How do I connect fact tables for drill down

I need some advice on a project I am modeling for a Hospital. We have 2 business process' that I am creating individual fact tables. The big questions is - how do I connect related Fact Tables for drill down ? Details: Reimbursements - the

Snapshot Dimension & Fact tables

We are currently designing a logical multidimensional model from an OLTP tables.Dimension tables have monthly snapshot because some of or all the attributes might change on monthly basis.The same situation for the fact table has monthly snapshot. I kno

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Easy way to deal with MKV files

Okay, so I know a lot of people seem to despise using MKVs when editing because for most people, they most don't want to ever work with a NL video editor, and the people who know how to covert them know of the hassle and the huge amounts of disk space

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from

Post your Omegle/IM/EMAIL chats.

Note- Omegle is a website where you can chat with strangers over a safe and non-invasive chatbox. Post any conversations you have that are post-worthy from either Omegle, Instant Messaging or Email~ Warning - Omegle is uncensored and thus anything

use of degenerate dimension to physically join two logically related fact tables