Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

analysis services in excel

Open Document

Below is a free excerpt of "analysis services in excel" from Anti Essays, your source for free research papers, essays, and term paper examples.

Contents
Introduction 3
Excel 2007 PivotTables 4
Measure Groups 5
Display Folders 11
Attribute Hierarchy Display Folders 11
User Hierarchy Display Folders 13
Measure Display Folders 14
Named Sets and Calculated Measure Display Folders 16
KPI Display Folders 19
Multilevel Display Folders 21
Adding an Entity in Multiple Display Folders 23
Adding Attribute Hierarchies to the Root Dimension Folder 24
Named Sets 26
Perspectives 28
Time Dimensions 30
Placing Time Information in Columns 30
Exposing Date-Specific Filtering Options 31
Member Properties 35
Member Properties in Tooltips 37
Member Properties in the Report 40
Filtering by Member Properties 43
Actions 43
Measure Formatting 47
Currency Formatting 51
Key Performance Indicators 53
Calculated Members 56
Translations 57
Conclusion 62
Related Links 63

Introduction
Microsoft® Office Excel® 2007 takes advantage of most of the features in Microsoft SQL Server™ 2005 Analysis Services. To take full advantage of these features, it is important to consider the end-user experience in Office Excel 2007 when you are designing cubes. This document outlines how to make the end-user experience great by optimizing the cube design for Office Excel 2007 PivotTable® dynamic views.
Note that the features described in this document are applicable not only to SQL Server 2005 Analysis Services cubes; Excel exposes the features described with any OLAP (online analytical processing) server that supports the required functionality.

Excel 2007 PivotTables
PivotTables in Office Excel 2007 have been greatly enhanced to make them easier to use. Many new capabilities have been added, and the improved appearance is beneficial for creating professional-looking business reports. Figure 1 shows an Office Excel 2007 PivotTable and PivotTable Field List. It also illustrates the Ribbon, which is part of the new Microsoft Office Fluent™ user interface (UI). The PivotTable Field List is readily available from a tab...

Show More


Citations

MLA Citation

"analysis services in excel". Anti Essays. 15 Dec. 2018

<http://cassandralynndesignllc.com/free-essays/Analysis-Services-Excel-26312.html>

APA Citation

analysis services in excel. Anti Essays. Retrieved December 15, 2018, from the World Wide Web: http://cassandralynndesignllc.com/free-essays/Analysis-Services-Excel-26312.html