Datasecurity within Business Intelligence

Business Requirements Document

Does anyone have a sample or template business requirements document for a DW/BI project? I was looking to see what sections others are including and how they are structuring the document as I am just starting a new project. Thanks!

null values best practice digest

Hi all, i read all the post and design tips about null values management. Can you tell m if the following statements are right or wrong for you : Dimension attributes null values management : For string dimension attributes, use : "Not

Looking for a Data Architect

My company is seeking a Senior Data Architect. We are a Kimball shop, but we also build & support ODSes as well. Please send my a PM if interested! Here is description: As a member of our technology team, you will contribute to the

Kimballs design Tip#51 - Time Dimension

This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou

Ralph Kimball and associates to review the questions asked

Hi All, This is a really nice forum,though there might be few forums on BI,but what seperates it out is that it comes under the umbrella of "Ralph Kimball" philosophy so any reviewer under this ensures that they are on the same page when it

Seeking Senior BI Developer for global capital markets firm in downtown Boston

The Business Systems/Business Intelligence Developer reports to the Applications Development Manager and works within a Global IT team to deliver new custom applications, to maintain and support existing applications and to integrate packaged applications

General Rules and Guidelines

This forum provides data warehousing and business intelligence professionals with recommendations, answers, suggestions and experiences related to Kimball-oriented DW/BI best practices. Note: There may be modifications to these rules and guidelines

Converting Columns into Rows.

I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

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

Openings for SAP Trainee in Hages Business Solutions Pvt ltd

Industry: Computers / IT Education: B.Com / B.Sc / B.Tech/B.E. / BCA / MBA/PGDM Location: Ahmedabad Experience: 0 Years Job Details Fresher - Six months class room plus on the job training, Exposure of dealing with various clients across India

Primary Key of Dimension and Fact Tables

I've seen several people give presentations which purport to represent the Kimball Method and I've seen this done two ways. What is the current position on what should be the primary key of a dimension table? I was under the impression that we

Bridge tables versus massive junk dimensions

I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are

Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?

Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?