Home
Tour
Download
Purchase
Local Cube Information Center
Samples
Support
About Us
Contact

 

The Local Cube Information Center

www.cubeslice.com


 

Checklist for Using Analysis Services

Analysis Services is a Business Intelligence tool. Everything about Analysis Services relates to Business Intelligence. You may not need to use all of its capabilities, though, to have a successful Business Intelligence system. 

Analysis Services can be used for both OLAP and data mining. You can use it for one or the other, but both OLAP and data mining are essential Business Intelligence capabilities.

We know how to design and build dimensions, including an understanding of:

               + Attributes

               + Levels

               + Attribute relationships..

               + Hierarchies

               + The different types of dimensions

               + Member names and member keys

               + Ordering of members

               + How dimensions are used in measure groups

               + Changing dimensions

We know how to design and build cubes, including an understanding of:

               + Measures

               + Measures Groups

               + How to create calculated members and sets with MDX.

We know how to choose aggregation options to balance concerns for processing speed and browsing speed.

We know how to process cubes and dimensions and understand how the processing of one OLAP object may affect other OLAP objects.

We know how to use partitions to improve processing and browsing speed performance.

We know how to design, build, and process data mining models.

We know how to use data mining prediction queries.

We know how to implement security in Analysis Services.

We know how to use local cube files for multidimensional browsing when disconnected from the network.

We know how to provide access to OLAP cubes across the internet.