| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
UserGuidePDFPages
Revision as of 12:43, 11 November 2015 by Antonio.remedios (talk)
- Introduction
- Grid Reporting Overview
- Formula Reporting Overview
- Grid vs. Formula-based Reporting Key Differences
- Creating Connections
- Managing Connections
- Report Designer
- Dragging and Dropping in Grids
- Managing Favourites
- Grid Templates
- Saved Member Lists
- Task Pane
- Hierarchy Editor
- Hierarchy Information
- Member Selector Slicer
- Date Slicer
- PdfBookPages/Excel Range Slicers
- PdfBookPages/Excel Range Slicers Version 6.5
- PdfBookPages/Formatting Grids
- PdfBookPages/Formatting Grids Version 6.5
- Driving Grids from an Excel Range
- Level based formatting
- Calculations Overview
- Grid Calculations
- Asymmetric Grids
- Ranking, Sorting and Filtering
- Axis Ranking
- Subtotals
- Member Properties in Grids
- Grid Charts
- Grid Properties
- Refresh Grids and Formulae
- Drilling in Grids
- Drilling Multiple Selections
- Drill Modes
- Removing Zeros from a Grid Report
- Drillthrough
- PdfBookPages/Breakout Value Version 7.2
- PdfBookPages/Breakout Value Version 6.0 to 7.1
- Active Cell Grid Selections
- Copy Sheet
- Outlier Grouping
- Actions
- MDX Calculations
- Mdx:
- Linking Grids
- In-Cell Charts in Grids
- Small Multiple Charts
- Small Multiple Charts based on SQL
- Small Multiple Charts based on Excel Ranges
- Dimension Slicers
- Advanced Row and Column selections
- Expanding Large Hierarchies
- Copying Grids
- Deleting Grids
- Propagate Across Sheets
- Adding Round Corners to Excel
- Drilling in Formula Reports
- Formula Reference
- Insert Value
- Insert Members
- Insert Member Property
- XL3Member
- XL3MemberLookup
- Publishing PowerPivot Reports
- Interactive Charting
- XL3Lookup
- XL3LookupRW
- XL3RankLookup
- XL3ValueRankLookup
- XL3PropertyLookup
- XL3KpiPropertyLookup
- XL3DataSeriesLookup
- XL3MemberNavigate
- XL3Link
- XL3RowVisible
- XL3ColumnVisible
- Insert Ranking
- InsertPictureLink
- DesignFrameSize
- TrendlineForm
- Writeback
- Relational Writeback
- XLCubed Options
- Web Edition
- Web Publishing
- Web HomePage
- Creating Reports in Web Edition
- Customising web config
- Auto refresh
- Pie Charts in Web Edition
- Browsing the XLCubed Web Repository
- IPad/iPhone app
- Mobile analytics
- Maps
- Treemaps
- Bandlines
- Using Grids with Protected Worksheets
- Convert to Formula
- Convert to Values
- Set Searching
- Macros
- In-Cell Chart Designer
- SparkLine Chart Designer
- SparkColumns Chart Designer
- SparkWinLose Chart Designer
- SparkBar Chart Designer
- SparkBullet Chart Designer
- SparkIcon Chart Designer
- SparkPie Chart Designer
- SparkHorizon Chart Designer
- SparkBox Chart Designer
- DotPlot Chart Designer
- Lollipop Chart Designer
- Bandline Chart Designer
- 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
- HTML:
- Analytics books
- ValidateConnection
- Clear all data values
- Web Parameters
- Web Repository
- Connection Mapping
- Dual Authentication
- SharePoint
- Scheduling with the File-based Repository
- Scheduling with the SQL Repository
- Controlling Scheduling with a SQL Query
- Sending A Scheduled Report Using Integration Services
- Publishing SQL Queries
- Publishing Connections
- Example of connecting to a relational database - Adventure Works
- Converting ProClarity Reports
