|
Introduction to MDX |
|
|
Introduction to MDX Concepts - Tuples, Sets, Axis
Writing simple SELECT Queries |
|
Calculated Members and Named Sets |
|
|
Dimensional Calculations
Calculated Member scopes
Basic Calculation Functions
Introduction to Named Sets
Named Sets scope and Context
Common uses of named Sets |
|
Common Calculations and Selections |
|
|
Metadata Referencing Functions
Ratios and Allocations
Percent Contribution
Simple and Weighted Averages
Time based references and Time Series Calculations
Different Aggregations along different Dimensions
Handling boundary conditions |
|
Query Context and Execution |
|
|
Cell context and resolution order
Execution stages of a query
SubCubes
Cube Context |
|
Sorting and Ranking |
|
|
Top-N Selections
Top-N Percent
Reversing Sets |
|
MDX Scripting |
|
|
|
|
Client Interaction |
|
|
Using Drill Through
Using Actions
Using KPIs |
|
Local Cubes |
|
|
|
For more specialized courses on SQL Server Reporting Services
click here
|
Introduction to Reporting Services |
|
|
Reporting Services Features
Architecture |
|
Designing and Creating Reports |
|
|
Report Design Basics
Grouping
Working with
Parameters
SubReports
Controlling Report Pagination
Publishing Reports |
|
Interactive Reports |
|
|
Hiding Report Items
Linking Reports
Document Maps |
|
Writing Expressions in Reporting Services |
|
|
Manipulating Data with Expressions
Commonly used Expressions
Global Collections
Reporting Services Functions
Writing Custom Code |
|
Viewing Reports |
|
|
Publishing and Printing Reports
“My Reports”
Scheduled / Cached Reports |
|
Integrating Reporting Services into Applications |
|
|
Using URL Access
Using the Web Service API to access reports |
|
Web Service API |
|
|
Web Service Features
Accessing SOAP API
Building .net applications usng the Web service API
Device Infomation Settings
Using Reporting Services SOAP Headers
Exception Handling
Scripting with the rs Utility |
|
Code Access Security |
|
|
Understanding Security Policies
Using Reporting Services Security Policy Files |
|
Working with Ad hoc reports using Report Models |
|
|
Introduction to Report Builder
Introduction to Model Designer
Working with Entities, Folders, Perspectives, Roles, Source Fields and Expressions
Publishing Report Models
Model Designer Object Relationship Diagram
Model Designer Query Properties
Model Designer Object Properties
Generate Models using Report Management Tools |
|
Administering Reporting Services |
|
|
Administration Tools
Administering Report Server Database
Managing Encryption keys
Administering Report Server web service and Windows Service
Managing Log files
Monitoring Performance
|