Page 130 - DCAP606_BUSINESS_INTELLIGENCE

Unit 8: Advanced Measures and Calculations

Notes
No Executive Involvement
This form of support is especially critical for business intelligence projects that require
collaboration between different organizational groups. This is because you are changing
the way the business users do their work. The business users become hesitant, maybe even
hostile toward the new technology and application. You must have a C-level executive
who is willing to be the first guinea pig, to be the first person to adopt the new environment.
This executive will make your application the only way they receive such information;
which will create incentives for others to adopt the new system and replace workers who
flatly refuse to play. A clear list of benefits, along with the metrics that will be used to
measure the benefits, will go a long way. Thus, the executive will become comfortable
and want to get on board with the project.
Lack of Communication to Consultants
Make sure that you and your consultants understand who is doing what. Agree on specific
roles, responsibilities, costs and estimated time frames before you initiate the project. If
things get off track, do not wait to call a meeting to determine the problems and potential
solutions. A scope document for the project and another for the consultants’ roles and
responsibilities will eliminate a large heartache later. Specific deliverables assigned to
each person on the project, as well as their time frames, will benefit you greatly.
Assuming the Project is finished
The report successfully points out that a project is not over simply because the application
has been deployed. It should end when it is being effectively used by the business. This is
especially true of business intelligence applications. It may take a while before the business
community actually uses the new application. It may be because other processes must be
implemented before the analytics can be fully utilized. It is important to understand how
the application fits into the business user’s workflow before declaring that the project is
completed. Your project may not truly end for several months, perhaps even years, after
it has been organized.
Question:
Add your own comments about these in terms of specific business intelligence projects.

Source: http://www.b-eye-network.com/view/1519
8.6 Summary

The focus of this is the utilization of advanced methods of exploring and surfacing OLAP
cube data using Multidimensional Expression Language (MDX), both in the Enterprise
Guide viewer and via the PROC SQL interface to OLAP.
Once the groundwork has been laid, MDX queries and the use of several MDX and SAS
functions within those queries will be demonstrated.

It is very common to sum measures when you aggregate values along dimension
hierarchies, but sometimes you need to apply a different aggregation method.

If a measure’s Aggregate Function property value is Sum, the measure value for a cube
cell is calculated by adding the values in the measure’s source column from only the rows
for the combination of members that defines the cell and the descendants of those members.

To use facts and figures from an analysis Services cube in your report, you should define
an Analysis Services data source and create one or more report datasets.

LOVELY PROFESSIONAL UNIVERSITY 125