Archive for "November, 2011"

Dimensional Modeling – Conformed Dimensions

Data Warehousing Nov 18, 2011 No Comments

Conformed DimensionsIn dimensional modeling, conformed dimensions are common and repeatedly used dimensions that relate and are joined to multiple facts. The conformed dimension is consistent across an enterprise and has the same meaning to every fact with which it relates. Typically, a conformed dimension exists as a single dimension table and relates to multiple fact tables within the same data warehouse. But the conformed dimension can also exist as identical dimension tables in separate data marts. In a nutshell, conformed dimensions allow facts and measures to be categorized and described in the same way across dimensional stars and/or data marts, ensuring consistent reporting across an enterprise.

Properties of Conformed Dimensions:
•  Dimensions that are joined to multiple fact tables
•  Exist in multiple star schemas and/or data marts
•  Same meaning with every fact table join
•  Allow various fact tables to be used in the same query
•  Same structure and attributes in every model
Common Conformed Dimensions:
•  Customer
•  Product
•  Date/Time
•  Employee
•  Account
•  Region or Territory
•  Vendor




Business Objects Live Office

Business Intelligence, Business Objects Nov 01, 2011 No Comments

Live Office from SAP Business Objects integrates business intelligence functionality from the Business Objects suite within the commonly-used Microsoft Office environment. Subsequently Live Office enables users are able to embed refreshable information within documents, spreadsheets, and presentations and share them across their organization. Live Office provides users with real-time data that is verifiable and easily refreshed. As Live Office is built directly into Microsoft Office applications, needed information is available at the user’s finger tips and is available in a familiar, easy to use format. In a nutshell, Live Office empowers business users to easily access corporate data from within Microsoft Office Excel, Word, Outlook, and PowerPoint without depending on expertise from the information technology department.

Live Office PowerPoint Sample

Benefits of Business Objects Live Office
•  Access business intelligence (BI) content directly within Microsoft Office.
•  Embed business intelligence directly in your e-mail messages using Microsoft Outlook.
•  Format and perform calculations using familiar features of Excel, PowerPoint, and Word.
•  Increase business user autonomy by exposing corporate data in Microsoft Office documents, spreadsheets, and presentations rather than web applications.
•  Improve timelines of decisions by enabling simpler information consumption.
•  Become less dependent on information technology personnel for generation of reports.



Facebook Like Button for Dummies