This is a list of available videos about Visual Stusio 2010/2008 BIDS AddIn:

General

• VS 2010/2008 MDX designer

This is the list of all available videos for CubePlayer and Manager. To see available videos for CubePlayer in structured form please go to How to ... ? section of the web site.

Please note that color and image quality in these presentations are significantly reduced due to video compression settings.

CONTROL PANEL

• Control Panel Styles
• Add Control Panel
  

HOW MANY? Analysis

• How Many Analysis

SHOW ME ... Analysis

• Show Me Analysis

MDX DESIGNER

• Design simple query
• Learn MDX
• Apply inner MDX Functions
• Generate - Top 10 Cities and for each Top 5 Product subcategories
• Top 15 Customers for year 2001 compared with 2000 and percentage difference
• Date Parts - Today, Yesterday, Last Month, Last Quarter ...    

          Inner Query

• Create and use Inner Query

          Create local calculated elements

• Create member
• Create Set
• Create Named Set
• Create Member from Set

          Tuple Generator

• Create tuple

          Time MDX Functions

• FromDate - ToDate member
• LastPeriods member
• PeriodsToDate member

          Date Parts 

• Date Parts - Today, Yesterday, Last Month, Last Quarter ...    

          Member MDX Functions 

• NextMember and PrevMember
• First and LastChilde combined with CHILDREN or Descendants 
• CHILDREN
• Descendants
• Find members and make selection

          Member Properties 

• Use as measure or filter data set       

          Functions

• Contribution function       

         KPIs

• KPIs

          Save and use Designer

• Save and use Designer

MDX EDITOR

• MDX Intellisense
• Edit MDX

         Operations and function keys

• F2 - Insert Format String
• F3 - Bracket test counter
• F4 - Insert MDX function
• F5 - Run MDX command or part of it inside editor
• F6 - Run MDX command or part of it as dynamic document
• F7 - F8 - View captions
• F9 - Split window
• F10 - Folding
• F11 - Comment - Uncomment
• F12 - Structurize MDX command

• MDX Editor - Edit two queries (split window)
• Folding and MDX hierarchical structure
• Insert MDX Function-WITH element-Comment
• Insert from tree view with MDX Function-Intellisense-Syntax Checker
• Run or Edit -Drag-and-Drop    

DASHBOARD

• Create simple dashboard
• Dashboard Parameters

          Panel operations

• Copy and Paste members
• Join (Union) two panels
• What is common for two panels
• What is difference betweeen two panels

          Export to MS Excel

• Export to MS Excel

          Use Dashboard as designer 

• Use dashboard as designer

          Define lineked paramters

• How to define linked parameters? (Dashboard)

TABLE OPERATIONS - Drill, Add, Remove, Isolate ...

• Remove members
• Add or Remove filters
• Add or Remove or Calculate measures
• Add dimension
• Replace dimension

          Isolate

• Isolate member
• Isolate by cell value

          Drills

• DrillDown on level
• DrillDown on member
• DrillDown on set

          OLAP parameters

• How to define parameter?

          MDX functions on row or column axis

• Apply MDX Function to row or column axis  

          Member properties

• Add member properties at the result set

          Calculations on the table (result set)

• Calculate measures at the result set

          Other

• MDX Editor - Edit two queries (split window)
• Compare two queries - (split window)
• Organize members or dimensions at the table

          Hot-Spot (Exception) Analysis and export to Dashboard

• Hot-Spot Analysis

HOW TO CONNECT?

• Connect to Microsoft AS 9.0 - 2005
• Connect to Microsoft AS 8.0 - 2000
• Connect to Local cube

HOW TO DEFINE PARAMETERS?

• How to define parameter?
• How to define linked parameters? (Dashboard)

ABC+ Analysis

• ABC+ Analysis (segmentation) and export to Dashboard

RANGE Analysis

• Range Analysis on any result set

GRAPH AND TABLE STYLES

• Graph and table styles
• Add notes

STATIC REPORTS

• Create static report

REPORTING SERVICES SERVER

• Reporting Server support

RUNING PROCLARITY BRIEFING BOOK

• Run Proclarity BBK