Design Tip #25 Modeling Issue
I have some questions related to Design Tip #25 and Design Tip #95. I have a scenario almost near to Order & Order Items scenario but with different issues. 1. We have a system that has multiple parent-child relationships between many tables, sometimes

Modeling Question - Accumulating Snapshot vs. Event Transactions
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different

Schemas ... in the final dimensional models (BI database)
Hi quick question ... We are planning to have 2 or three staging databases. 1) Staging 2) Conforming and then finally the actuall BI database 3) DataWarehouse My question, in this final final database (3) should we use schemas to 'group

Datasecurity within Business Intelligence
Hi! My name is Daniel and i am graduating on the subject datasecurity within Business Intelligence. My main objective is "how to manage confidential information in is business intelligence (data warehouse and reporting)". I am searching for

semantic models / layers
I am looking for recources about semantic models or layers in BI. Such as the Business Objects 'universe' or microsoft's 'BISM'. Do you know any good articles, books or blogposts. Please let me know. Kind regards, Roland

Ithaca College Seeking Business Intelligence Specialist/Data Modeler
BUSINESS INTELLIGENCE SPECIALIST/DATA MODELER ITHACA COLLEGE The department of Enterprise Application Services within Ithaca College’s office of Information Technology Services (ITS) invites applications for a full-time Business

Agile BI - Data Model
In Agile approach in DW, while we are designing Data Models and DB tables, should it cater for entire requirement or for sprint wise requirement? If Sprint wise requirement, how to incorporate it within sprint time?

business intelligence tool
How to work on repository

Intelligence Test's
Note to visitors: We have more exciting topics like this. Register now! Two men play five games of checkers, each man wins the same number of games, they do not tie a match. Explain it. Spoiler:They are not playing each other. How many animals of

Best BI Software for Kimball Method?
I am a financial analyst with an MBA trying to gain a depth in understanding the BI universe. I am currently devouring the DW Toolkit, 2nd edition book, in addition to my own research, and have learned a great deal in only the past few weeks. In my

Geospatial Modeling
Are there any resources I can reference for modeling geospatial data? In our particular case, we are modeling a pipeline as the basic "fact" where the geographic location is of particular importance. In addition we need to model the location

Modelling Loan Fact - Arrears
Hi, I'm in the process of building a loan transaction fact table but was wondering how to handle the requirement to report on loan arrears amounts (could equally apply to other financial products like mortgages, credit cards etc). This would be an

Star schema or using reference tables?
I’m trying to model a data model for a request report process. Some information about a report that can be requested: a report can have different fields (max 30 fields) and different departments (max 20). The DWH should at least answers the

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

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