Dimension Hierarchy - Facts by various levels
Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level

Large Dimension table compared to fact table?
I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing

Audit dimension for a dimension?
The books describe how to create a useful audit dimension for the fact table rows, but what about the dimension table rows? Why isn't that mentioned in the books? Isn't the data quality and lineage also important for dimensions? Would you create a

Bus Matrix in SAP suite
Has anyone implemented the BUS Matrix using the SAP suite? I got a customer where SAP is their core BI element at the moment, so I would like to know any tips about how to implement the BUS Matrix in SAP BI suite Thanks, kpsota

MDX(or something else) for getting history based on last dimension characteristic for SCD.
Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

Business Objects and joins across two (large) fact tables
In a business objects universe, I have several fact tables which are related by various dimensions. If I want to select facts from two of the fact tables, business objects will generate two separate queries, run the SQL and join the two results sets in th

Large number of snowflake code tables per dimension
Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Best Practices for SCD Dimension Tables for a Banking Data Warehouse
Hello, I am looking for a list of dimension tables to track historical changes on for a banking data warehouse, based on "best practices". Customer is a prime candidate. Are there others? Thanks, Ike

Architecture questions : implement historical data view without SCD?
Hello ! I need some fresh points of view of an architecture I’ve just encountered. This solution was designed by a consulting firm specialized in the HR IT field. The DWH in this case is supposed to handle 100’000 employees for an organization of

Dimensional table design dilemma, Aditional column or Xref table
Here is my situation. We have a currency dimension table which stores the ISO currency codes (e.g. USD for US Dollar) and a surrogate key, currency description along with some maintenance columns (insert date, update date etc..). We are trying to

Staging > ODS > EDW
I have a basic query on Staging > ODS > EDW architecture. how the incremental data would be populated in EDW? Assume i have a "Customer Addess" Staging table which selects the delta from source system, then it updates the "Custome

Multi valued dimension attributes, weighting factor and cognos
Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Partitioning Strategy for Fact and Dims in Oracle/DB2/Sybase
Please specify the partition strategy you follow in your organization for facts and dims in Ora/Sybase/Db2 Thanks, bi_at_nj

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Type 3 Slowly Changing Dimension
I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2. If anybody has used type 3 dimension instead of type 2, please let me know the scenario an