User Manual

• Introduction & Overview
  • What is XLCubed
  • Data Sources
  • How is it used
  • XLCubed and Cube Terminology
    • Measures
    • Dimensions, Hierarchies and Levels
    • Members
  • Ways to retrieve data in XLCubed
    • Grids
    • Formulae
    • Grids or Formulae?
    • Tables
    • Tables or Grids?
• QuickStart
  • Managing Connections
  • Connecting to your data
    • Connection Manager
• Grids
  • Grid Reporting Overview
  • Grid Components
  • Basic Navigation
    • Edit Grid
    • Grid Task Pane (2007 onwards)
    • Saved Grid Report
    • Refresh Grid
  • Report Designer
    • General Layout
    • Moving Hierarchies
    • Toolbar
    • Grid Properties
    • Formatting Grids
    • Drilling in Grids
  • Calculations Overview
    • Grid Calculation Columns and Rows
    • MDX Calculated Members
    • XLCubed OLAP Formulae
  • Grid Calculations
    • Member Selector and Adhoc Groupings
    • Share to Base: Calculated Value on Measure
    • Pareto Columns
  • Subtotals
    • Cube vs Excel Mode
  • Actions
  • Outlier Grouping
  • Linking Grids
  • Member Properties in Grids
    • Examples (using the Internet Sales cube)
  • Active Cell Grid Selections
    • Example
    • Additional Options
  • Propagate Across Sheets
    • Advanced Propagate
    • Create new Workbook
  • Breakout Value
    • Track Active Cell
  • Converting Grid Reports
    • Convert to Formula
    • Convert to Values
  • Copying Grids
  • Deleting Grids
  • Drillthrough
  • Expanding Large Hierarchies
  • Grid Charts
    • Chart Types
    • Configuring Existing Charts
• Formulae Reporting
  • Grid vs. Formula-based Reporting Key Differences
  • Drilling in Formula Reports
  • Insert Value
    • Additional Options
  • Insert Members
    • Additional Options
  • Insert Member Property
  • Formula wizards
  • Formula Reference
    • OLAP Formulae
    • In-Cell Chart Formulae
    • Report Management Formulae‎
    • Query Table Formulae
    • Tabular Formulae
• Charting & Data Visualisation
  • Standard Excel Charts
  • XLCubed Grid Charts
  • In-Cell Charts
  • Small Multiples
  • Treemaps
  • Mapping
  • In-Cell Charts in Grids
    • Visual Grids for Time Series Analysis
    • Visual Grids for Performance Analysis
  • Small Multiple Charts
    • User Interface
    • Small Multiple Charts based on other data sources
  • Interactive Charting
    • Chart Selections
    • Chart Formatting
    • SQL and Excel sourced Charts
  • In-Cell Chart Designer
  • Maps
    • User Interface
  • Treemaps
    • Data sources
    • Common Options
• Web Edition
  • Step 1. Design your report
  • Step 2. Publish your report
  • Step 3. View the report in a browser
  • Step 4. Enjoy OLAP in a browser
  • Web Publishing
    • Publication Process
    • Manage Repository
    • Web Edition
    • Toolbar
    • Report Tabs
    • Report Area
    • Creating Reports in Web Edition
  • Analytics books
    • Creating a new book
    • Standard UI
    • Report Header
    • Report Types
  • Auto refresh
  • Browsing the XLCubed Web Repository
  • Reporting Services
  • Web Development
    • Direct report linking
    • Embedding Workbooks
    • Embedding Repository
    • Customising HTML
  • HTML:
  • Mobile app
    • Report Navigation
    • Mobile analytics
  • Publishing Connections
  • Customising web config
  • Web Parameters
    • Using Web Parameters Example
  • Connection Mapping
    • Example XML file
  • Dual Authentication
  • Scheduling
    • Concepts
    • Sending A Scheduled Report Using A SQL Query
    • Sending A Scheduled Report Using Integration Services
    • Installation
    • Installation
• Dimension Slicers
  • Grid Slicers
  • Standalone Slicers
  • Member Selector Slicer
  • Date Slicer
  • Updating Excel Ranges
  • Excel Range Slicers
  • Members with no data / Non empty
  • Cascading and Advanced Slicers
  • Initial Value
  • Disabling Slicers
  • Wait for Submit on Web
• Ranking, Sorting and Filtering
  • Simple Filtering
  • Sorting on a different dimension
  • Combining Ranking, Filtering and Sorting
  • Sorting slicer elements
  • Sorting by sub-category within category
  • Driving Reports from Excel
  • Set Searching
    • Member Search
  • Axis Ranking
    • Axis Ranking, Filtering and Sorting
  • Outlier Grouping
    • Ranking
    • User driven grouping
• SQL
  • SQL Server 2012
    • SQL Administrators
    • Standard SQL Users
  • SQL Data Tables (Administrators)
    • Inserting a SQL Data Table
    • Using Parameters
    • Using Stored Procedures
    • Publishing Queries
  • SQL Data Tables (Standard Users)
    • Inserting a SQL Data Table
    • Using Parameters
  • SQL Slicers (Administrators)
    • Introduction
    • Using Slicers for Table Parameters
    • Standalone Slicers
  • SQL Slicers (Standard Users)
    • Introduction
    • Standalone Slicers
  • Using SQL Parameters
    • Creating SQL Parameters
    • Static Values
    • Values from an Excel range
    • Values from a Slicer
• Tables
  • SQL
  • Multidimensional Table Designer
    • Designer
  • Tabular
    • Grids
    • Tables
    • Slicers
    • Calculations
  • Tabular Designer
    • Report layout
    • Member filters
    • Measure filters
    • Table Properties
  • Formatting Tables
    • Formatting Columns
    • Formatting Values
  • Calculations
  • Paging
  • Sorting
  • Sections and Pivoting
  • Pivoting
• SharePoint
  • Installing
  • Uninstalling
  • Using WebPart
  • Configuring
  • Troubleshooting
  • SharePoint Integration
    • Installing
    • Custom Handler
    • Set icon file type
    • Custom Report Page
    • Configure redirect
    • Searching
    • Sharepoint on different server
    • Using
• Miscellaneous
  • XLCubed Options
    • Main
    • Web Publication
    • Workbook Defaults
  • MDX Calculations
    • Creating Calculated Members
    • Creating Named Sets
    • Show with Captions
  • Writeback
    • Writeback in XLCubed Grids
    • Formula Writeback
    • Relational Writeback
  • Converting ProClarity Reports
    • Importing a Briefing Book
  • Publishing PowerPivot Reports
    • Requirements
    • Overview
    • Configuration
  • Using Grids with Protected Worksheets
    • Set the XLCubed Workbook Options to use your password
    • Placing the Grid on a non-protected worksheet
    • Alternatives
  • Copy Sheet
  • Macros
  • Adding Round Corners to Excel
    • Adding Round Corners
    • Editing Existing Corners
    • Resizing Columns/Rows
  • Pie Charts in Web Edition
  • Removing Zeros from a Grid Report
    • Example
    • Editing the filter
  • Mdx:
    • Description
    • Syntax
    • Examples
  • Managing Favourites
    • Create a grid report which I want to save as a favourite for my own use
    • Create a grid report which I want to save as a favourite and share with other Excel Edition users
    • Create a grid report which I want to save as a favourite and share with other Web Edition users
    • Create a workbook template that I can save as a favourite and share with other Excel Edition users