Page 143 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes
between day 14 and day 17, resulting in a bell curve distribution of the data. This metric
has proved to be so useful that they will be including it, in its graphical form, as a key
performance indicator (KPI) on their MITS Discover Dashboard, allowing them to instantly
view shifts in the curve and attend to underlying issues. In its beginning stages the response
to MITS within PMP, Inc. has been very positive, with users already providing feedback
for additional Hypercubes. Burns followed up on this by commenting, “To me, this is a
very encouraging sign. It signals that with very little exposure to the tool, end users are
seeing its potential in ways that would benefit them and how it can allow them to produce
the analysis and reports that they require.” He has also found that “[MITS] Discover easily
uncovers inaccuracies and inconsistencies that can exist in the underlying data, sometimes
to the doubt of the user. Verification, however, proves [MITS] Discover to be correct and
our assumptions of the data to be wrong. I like to say that if you shine a flashlight in a
darkened room and the roaches scurry, don’t blame the flashlight!”

Questions:
1. Analyse the case and provide a solution to Preferred Medical Plan, Inc. (PMP).
2. What is Turnaround Hypercube?
Source: http://www.mits.com/solutions/success-stories/healthcare.html

9.4 Summary

In Microsoft® SQL Server™ 2000 Analysis Services, a dimension with multiple hierarchies
is actually two or more distinct dimensions that can share dimension tables and may share
the same aggregations.

Dimensions that have multiple hierarchies can be created in the Dimension Wizard or
Dimension Editor.

The Account dimension and its associated rules enable you to create and maintain a chart
of accounts for various financial models.
You can update the AccountTypeMemberID property of a member of the Account
dimension. You can also add a new dimension member to the Account dimension and
create member hierarchies in the dimension.

The purpose of an Online Analytical Processing (OLAP) application is to supply users with
valuable information to propel business conclusions.
The Cube Designer in Business Intelligence Development Studio (BIDS) includes an activity
tab.
Drillthrough actions supply fast access to lowest grade of details stored in a cube. When
you create a drillthrough action, you choose dimension attributes and assesses that are
returned as columns of data when the action is performed.

9.5 Keywords

AccountTypeMemberID: A selectable option that groups the account member into a type.
Business Intelligence Development Studio (BIDS): Business Intelligence Development Studio
(BIDS) is the IDE from Microsoft used for developing data analysis and Business Intelligence
solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration
Services.

138 LOVELY PROFESSIONAL UNIVERSITY