UserGuidePDFPages

Print me

• Front Page
• Introduction
• Getting Started Summary
• XLCubed Excel Edition Prerequisites
• XLCubed Web Edition Prerequisites
• Web Browsers
• XLCubed In-Cell Excel Edition Prerequisites
• PdfBookPages/XLCubed Web Edition Installation Guide
• XLCubed Excel Edition Silent Installation
• Grid Reporting Overview
• Formula Reporting Overview
• Grid vs. Formula-based Reporting Key Differences
• Creating Connections
• Managing Connections
• Report Designer
• Hierarchy Editor
• Hierarchy Information
• Grid Properties
• Dimension Slicers
• Excel Range Slicers
• Format Sheet
• Formatting Grids
• Drilling in Grids
• Calculations Overview
• Task Pane
• Asymmetric Grids
• Keep Only
• Drilling Multiple Selections
• Dragging and Dropping in Grids
• Ranking, Sorting and Filtering
• Axis Ranking
• Breakout Value
• Propagate Across Sheets
• Grid Calculations
• Grid Charts
• Driving Grids from an Excel Range
• Drillthrough
• In-Cell Charts in Grids
• Level based formatting
• Linking Grids
• Small Multiple Charts
• Removing Zeros from a Grid Report
• Member Properties in Grids
• Maps
• IPad/iPhone app
• Advanced Row/Column selections
• Writeback
• Relational Writeback
• Treemaps
• MDX Calculations
• Subtotals
• Copying Grids
• Deleting Grids
• XLCubed Options
• Auto refresh
• Managing Favourites
• Grid Templates
• Using Grids with Protected Worksheets
• Convert to Formula
• Convert to Values
• Set Searching
• Drilling in Formula Reports
• SparkIcon Chart Designer
• SparkIcon Chart Icon Sets
• Formula Reference
• Insert Value
• Insert Members
• Insert Member Property
• XL3Link
• XL3Lookup
• XL3LookupRW
• XL3Member
• XL3MemberLookup
• XL3MemberChildLookup
• XL3MemberLevelLookup
• XL3Address
• XL3MemberAlias
• XL3MemberSet
• XL3SetProperty
• XL3MemberNavigate
• XL3DynamicPicture
• XL3DoWriteback
• XL3QueryTableSetConnectionString
• XL3QueryTableSetParam
• XL3RunSQL
• XL3QueryTableSetSQL
• XL3RefreshObjectsNamed
• XL3MdxMemberLookup
• XL3DataSeries
• XL3SparkBar
• XL3PropertyLookup
• XL3SparkBullet
• XL3SparkLine
• XL3SparkLineM
• XL3SparkColumnsM
• XL3SparkWinLose
• XL3SparkWinLoseM
• XL3ColumnVisible
• XL3RowVisible
• XL3MdxDataSeries
• XL3MdxLookup
• XL3SparkIcon
• XL3SparkBox
• XL3SparkColumns
• XL3SparkHorizon
• XL3SparkPie
• XL3ValueRankLookup
• XL3RankLookup
• XL3KpiPropertyLookup
• XL3RefreshObjects
• XL3DataSeriesLookup
• XL3WebReportLink
• XL3LookupTabular
• XL3KpiLookup
• XL3HierarchyLookup
• XL3LastCubeUpdate
• Insert Ranking
• In-Cell Chart Designer
• SparkLine Chart Designer
• SparkBar Chart Designer
• SparkBox Chart Designer
• SparkHorizon Chart Designer
• DotPlot Chart Designer
• SparkColumns Chart Designer
• SparkWinLose Chart Designer
• Expanding Large Hierarchies
• Macros
• Web Edition
• Web Publishing
• Web HomePage
• Pie Charts in Web Edition
• Browsing the XLCubed Web Repository
• Using SQL Parameters
• SQL
• SQL Server 2012
• SQL Administrators
• Standard SQL Users
• SQL Data Tables (Administrators)
• SQL Data Tables (Standard Users)
• SQL Slicers (Administrators)
• SQL Slicers (Standard Users)
• Tables
• Table Properties
• Table Pager Properties
• Tabular
• Tabular Designer
• Reporting Services
• Web Development
• Web Parameters
• Web Repository
• Connection Mapping
• SharePoint
• Creating Reports in Web Edition
• Scheduling
• Scheduling Installation
• Controlling Scheduling with a SQL Query
• Sending A Scheduled Report Using Integration Services
• Adding Round Corners to Excel
• Converting a Workbook from XLCubed V5
• Publishing SQL Queries
• Publishing Connections
• Publishing Troubleshooting
• XLCubed Excel Edition Troubleshooting
• Checking The Web Edition .NET Framework
• FAQ
• Enable Ribbon Other Options
• Example of connecting to a relational database - Adventure Works
• ManagementBook