| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "UserGuidePDFPages"
| Line 56: | Line 56: | ||
* [[Auto refresh]] | * [[Auto refresh]] | ||
* [[Managing Favourites]] | * [[Managing Favourites]] | ||
| − | * [[Grid | + | * [[Grid Templates]] |
* [[Using Grids with Protected Worksheets]] | * [[Using Grids with Protected Worksheets]] | ||
* [[Convert to Formula]] | * [[Convert to Formula]] | ||
Revision as of 10:14, 29 August 2012
- 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
- 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
