| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "UserGuidePDFPages"
| Line 48: | Line 48: | ||
* [[Copying Grids]] | * [[Copying Grids]] | ||
* [[Deleting Grids]] | * [[Deleting Grids]] | ||
| − | |||
| − | |||
* [[Propagate Across Sheets]] | * [[Propagate Across Sheets]] | ||
* [[Formula Reporting Overview]] | * [[Formula Reporting Overview]] | ||
* [[Drilling in Formula Reports]] | * [[Drilling in Formula Reports]] | ||
| − | |||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[Insert Value]] | * [[Insert Value]] | ||
* [[Insert Members]] | * [[Insert Members]] | ||
* [[Insert Member Property]] | * [[Insert Member Property]] | ||
| − | |||
* [[XL3Member]] | * [[XL3Member]] | ||
* [[XL3MemberLookup]] | * [[XL3MemberLookup]] | ||
* [[XL3MemberChildLookup]] | * [[XL3MemberChildLookup]] | ||
* [[XL3MemberLevelLookup]] | * [[XL3MemberLevelLookup]] | ||
| − | |||
* [[XL3Lookup]] | * [[XL3Lookup]] | ||
* [[XL3LookupRW]] | * [[XL3LookupRW]] | ||
| − | |||
* [[XL3RankLookup]] | * [[XL3RankLookup]] | ||
* [[XL3ValueRankLookup]] | * [[XL3ValueRankLookup]] | ||
| − | |||
* [[XL3PropertyLookup]] | * [[XL3PropertyLookup]] | ||
* [[XL3KpiPropertyLookup]] | * [[XL3KpiPropertyLookup]] | ||
| − | |||
* [[XL3DataSeriesLookup]] | * [[XL3DataSeriesLookup]] | ||
| − | |||
* [[XL3MemberNavigate]] | * [[XL3MemberNavigate]] | ||
| − | |||
* [[XL3Link]] | * [[XL3Link]] | ||
| − | |||
* [[XL3RowVisible]] | * [[XL3RowVisible]] | ||
* [[XL3ColumnVisible]] | * [[XL3ColumnVisible]] | ||
| − | |||
* [[XL3SparkWinLoseM]] | * [[XL3SparkWinLoseM]] | ||
* [[XL3SparkIcon]] | * [[XL3SparkIcon]] | ||
| Line 88: | Line 76: | ||
* [[XL3SparkHorizon]] | * [[XL3SparkHorizon]] | ||
* [[XL3SparkPie]] | * [[XL3SparkPie]] | ||
| − | |||
* [[XL3RefreshObjects]] | * [[XL3RefreshObjects]] | ||
* [[XL3WebReportLink]] | * [[XL3WebReportLink]] | ||
| Line 94: | Line 81: | ||
* [[XL3HierarchyLookup]] | * [[XL3HierarchyLookup]] | ||
* [[XL3LastCubeUpdate]] | * [[XL3LastCubeUpdate]] | ||
| − | |||
* [[Insert Ranking]] | * [[Insert Ranking]] | ||
* [[Adding Round Corners to Excel]] | * [[Adding Round Corners to Excel]] | ||
* [[Writeback]] | * [[Writeback]] | ||
* [[Relational Writeback]] | * [[Relational Writeback]] | ||
| − | |||
* [[XLCubed Options]] | * [[XLCubed Options]] | ||
| − | |||
* [[Web Edition]] | * [[Web Edition]] | ||
* [[Web Publishing]] | * [[Web Publishing]] | ||
| Line 109: | Line 93: | ||
* [[Pie Charts in Web Edition]] | * [[Pie Charts in Web Edition]] | ||
* [[Browsing the XLCubed Web Repository]] | * [[Browsing the XLCubed Web Repository]] | ||
| − | |||
* [[IPad/iPhone app]] | * [[IPad/iPhone app]] | ||
* [[Maps]] | * [[Maps]] | ||
* [[Treemaps]] | * [[Treemaps]] | ||
| − | |||
* [[Using Grids with Protected Worksheets]] | * [[Using Grids with Protected Worksheets]] | ||
* [[Convert to Formula]] | * [[Convert to Formula]] | ||
Revision as of 11:53, 31 August 2012
- Introduction
- Getting Started Summary
- Web Browsers
- 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
- 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
- Removing Zeros from a Grid Report
- Drillthrough
- Breakout Value
- Actions
- MDX Calculations
- Linking Grids
- In-Cell Charts in Grids
- Small Multiple Charts
- Dimension Slicers
- Advanced Row/Column selections
- Expanding Large Hierarchies
- Copying Grids
- Deleting Grids
- Propagate Across Sheets
- Formula Reporting Overview
- Drilling in Formula Reports
- Formula Reference
- Insert Value
- Insert Members
- Insert Member Property
- XL3Member
- XL3MemberLookup
- XL3MemberChildLookup
- XL3MemberLevelLookup
- XL3Lookup
- XL3LookupRW
- XL3RankLookup
- XL3ValueRankLookup
- XL3PropertyLookup
- XL3KpiPropertyLookup
- XL3DataSeriesLookup
- XL3MemberNavigate
- XL3Link
- XL3RowVisible
- XL3ColumnVisible
- XL3SparkWinLoseM
- XL3SparkIcon
- XL3SparkBox
- XL3SparkColumns
- XL3SparkHorizon
- XL3SparkPie
- XL3RefreshObjects
- XL3WebReportLink
- XL3LookupTabular
- XL3HierarchyLookup
- XL3LastCubeUpdate
- Insert Ranking
- Adding Round Corners to Excel
- Writeback
- Relational Writeback
- XLCubed Options
- Web Edition
- Web Publishing
- Web HomePage
- Creating Reports in Web Edition
- Auto refresh
- Pie Charts in Web Edition
- Browsing the XLCubed Web Repository
- IPad/iPhone app
- Maps
- Treemaps
- Using Grids with Protected Worksheets
- Convert to Formula
- Convert to Values
- Set Searching
- Macros
- In-Cell Chart Designer
- SparkIcon Chart Designer
- SparkIcon Chart Icon Sets
- SparkLine Chart Designer
- SparkBar Chart Designer
- SparkBox Chart Designer
- SparkHorizon Chart Designer
- DotPlot Chart Designer
- SparkColumns Chart Designer
- SparkWinLose 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
- Web Parameters
- Web Repository
- Connection Mapping
- SharePoint
- Scheduling
- Controlling Scheduling with a SQL Query
- Sending A Scheduled Report Using Integration Services
- Converting a Workbook from XLCubed V5
- Publishing SQL Queries
- Publishing Connections
- Example of connecting to a relational database - Adventure Works
- ManagementBook
