| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "UserGuidePDFPages"
| Line 3: | Line 3: | ||
* [[XLCubed Excel Edition Prerequisites]] | * [[XLCubed Excel Edition Prerequisites]] | ||
* [[XLCubed Web Edition Prerequisites]] | * [[XLCubed Web Edition Prerequisites]] | ||
| + | * [[XLCubed In-Cell Excel Edition Prerequisites]] | ||
* [[XLCubed Web Edition Installation Guide]] | * [[XLCubed Web Edition Installation Guide]] | ||
| + | * [[XLCubed Excel Edition Silent Installation]] | ||
* [[Grid Reporting Overview]] | * [[Grid Reporting Overview]] | ||
* [[Formula Reporting Overview]] | * [[Formula Reporting Overview]] | ||
* [[Grid vs. Formula-based Reporting Key Differences]] | * [[Grid vs. Formula-based Reporting Key Differences]] | ||
| + | * [[Creating Connections]] | ||
* [[Report Designer]] | * [[Report Designer]] | ||
* [[Hierarchy Editor]] | * [[Hierarchy Editor]] | ||
| + | * [[Hierarchy Information]] | ||
* [[Grid Properties]] | * [[Grid Properties]] | ||
* [[Dimension Slicers]] | * [[Dimension Slicers]] | ||
* [[Excel Range Slicers]] | * [[Excel Range Slicers]] | ||
| + | * [[Formatting Grids]] | ||
* [[Drilling in Grids]] | * [[Drilling in Grids]] | ||
| + | * [[Calculations Overview]] | ||
| + | * [[Task Pane]] | ||
| + | * [[Asymmetric Grids]] | ||
* [[Drilling Multiple Selections]] | * [[Drilling Multiple Selections]] | ||
* [[Dragging and Dropping in Grids]] | * [[Dragging and Dropping in Grids]] | ||
| Line 18: | Line 26: | ||
* [[Axis Ranking]] | * [[Axis Ranking]] | ||
* [[Breakout Value]] | * [[Breakout Value]] | ||
| + | * [[Propagate Across Sheets]] | ||
* [[Grid Calculations]] | * [[Grid Calculations]] | ||
* [[Grid Charts]] | * [[Grid Charts]] | ||
| Line 23: | Line 32: | ||
* [[Drillthrough]] | * [[Drillthrough]] | ||
* [[In-Cell Charts in Grids]] | * [[In-Cell Charts in Grids]] | ||
| + | * [[Drilling Multiple Selections]] | ||
| + | * [[Level based Formatting]] | ||
| + | * [[Linking Grids]] | ||
* [[Small Multiple Charts]] | * [[Small Multiple Charts]] | ||
| + | * [[Removing Zeros from a Grid Report]] | ||
| + | * [[Member Properties in Grids]] | ||
* [[Maps]] | * [[Maps]] | ||
* [[IPad/iPhone app]] | * [[IPad/iPhone app]] | ||
| Line 31: | Line 45: | ||
* [[Treemaps]] | * [[Treemaps]] | ||
* [[MDX Calculations]] | * [[MDX Calculations]] | ||
| + | * [[Subtotals]] | ||
* [[XLCubed Options]] | * [[XLCubed Options]] | ||
* [[Managing Favourites]] | * [[Managing Favourites]] | ||
* [[Using Grids with Protected Worksheets]] | * [[Using Grids with Protected Worksheets]] | ||
| + | * [[Convert to Formula]] | ||
| + | * [[Set Searching]] | ||
* [[Drilling in Formula Reports]] | * [[Drilling in Formula Reports]] | ||
* [[SparkIcon Chart Designer]] | * [[SparkIcon Chart Designer]] | ||
| + | * [[SparkIcon Chart Icon Sets]] | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[Insert Value]] | * [[Insert Value]] | ||
* [[Insert Members]] | * [[Insert Members]] | ||
| + | * [[Insert Member Property]] | ||
* [[XL3Link]] | * [[XL3Link]] | ||
* [[XL3Lookup]] | * [[XL3Lookup]] | ||
| Line 50: | Line 69: | ||
* [[XL3SetProperty]] | * [[XL3SetProperty]] | ||
* [[XL3MemberNavigate]] | * [[XL3MemberNavigate]] | ||
| + | * [[XL3DynamicPicture]] | ||
* [[XL3DoWriteback]] | * [[XL3DoWriteback]] | ||
* [[XL3QueryTableSetConnectionString]] | * [[XL3QueryTableSetConnectionString]] | ||
| Line 63: | Line 83: | ||
* [[XL3Sparkline]] | * [[XL3Sparkline]] | ||
* [[XL3SparklineM]] | * [[XL3SparklineM]] | ||
| + | * [[XL3SparkColumnsM]] | ||
* [[XL3SparkWinLose]] | * [[XL3SparkWinLose]] | ||
| + | * [[XL3ColumnVisible]] | ||
| + | * [[XL3RowVisible]] | ||
* [[XL3MdxDataSeries]] | * [[XL3MdxDataSeries]] | ||
* [[XL3MdxLookup]] | * [[XL3MdxLookup]] | ||
| Line 77: | Line 100: | ||
* [[XL3DataSeriesLookup]] | * [[XL3DataSeriesLookup]] | ||
* [[XL3WebReportLink]] | * [[XL3WebReportLink]] | ||
| + | * [[XL3LookupTabular]] | ||
| + | * [[XL3KpiLookup]] | ||
| + | * [[XL3HierarchyLookup]] | ||
| + | * [[Insert Members]] | ||
| + | * [[Insert Ranking]] | ||
| + | * [[In-Cell Chart Designer]] | ||
* [[Sparkline Chart Designer]] | * [[Sparkline Chart Designer]] | ||
* [[Sparkbar Chart Designer]] | * [[Sparkbar Chart Designer]] | ||
* [[Sparkbox Chart Designer]] | * [[Sparkbox Chart Designer]] | ||
| + | * [[SparkHorizon Chart Designer]] | ||
* [[DotPlot Chart Designer]] | * [[DotPlot Chart Designer]] | ||
* [[SparkColumns Chart Designer]] | * [[SparkColumns Chart Designer]] | ||
| + | * [[Web Edition]] | ||
* [[Web Publishing]] | * [[Web Publishing]] | ||
* [[Web HomePage]] | * [[Web HomePage]] | ||
| + | * [[Pie Charts in Web Edition]] | ||
* [[Using SQL Parameters]] | * [[Using SQL Parameters]] | ||
* [[SQL]] | * [[SQL]] | ||
| + | * [[SQL Server 2012]] | ||
* [[SQL Administrators]] | * [[SQL Administrators]] | ||
* [[SQL Data Tables (Administrators)]] | * [[SQL Data Tables (Administrators)]] | ||
| Line 97: | Line 130: | ||
* [[Tabular]] | * [[Tabular]] | ||
* [[Tabular Designer]] | * [[Tabular Designer]] | ||
| + | * [[Reporting Services]] | ||
* [[Web Development]] | * [[Web Development]] | ||
| + | * [[Web Parameters]] | ||
* [[Connection Mapping]] | * [[Connection Mapping]] | ||
* [[SharePoint]] | * [[SharePoint]] | ||
| Line 105: | Line 140: | ||
* [[Controlling Scheduling with a SQL Query]] | * [[Controlling Scheduling with a SQL Query]] | ||
* [[Sending A Scheduled Report Using Integration Services]] | * [[Sending A Scheduled Report Using Integration Services]] | ||
| + | * [[Adding Round Corners to Excel]] | ||
| + | * [[Converting a Workbook from XLCubed V5]] | ||
| + | * [[Publishing SQL Queries]] | ||
* [[Publishing Connections]] | * [[Publishing Connections]] | ||
* [[Publishing Troubleshooting]] | * [[Publishing Troubleshooting]] | ||
* [[XLCubed Excel Edition Troubleshooting]] | * [[XLCubed Excel Edition Troubleshooting]] | ||
| + | * [[Checking The Web Edition .NET Framework]] | ||
* [[FAQ]] | * [[FAQ]] | ||
* [[Enable Ribbon Other Options]] | * [[Enable Ribbon Other Options]] | ||
* [[Example of connecting to a relational database - Adventure Works]] | * [[Example of connecting to a relational database - Adventure Works]] | ||
* [[ManagementBook]] | * [[ManagementBook]] | ||
Revision as of 16:06, 22 August 2012
- Front Page
- Introduction
- XLCubed Excel Edition Prerequisites
- XLCubed Web Edition Prerequisites
- XLCubed In-Cell Excel Edition Prerequisites
- 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
- Report Designer
- Hierarchy Editor
- Hierarchy Information
- Grid Properties
- Dimension Slicers
- Excel Range Slicers
- Formatting Grids
- Drilling in Grids
- Calculations Overview
- Task Pane
- Asymmetric Grids
- 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
- Drilling Multiple Selections
- 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
- XLCubed Options
- Managing Favourites
- Using Grids with Protected Worksheets
- Convert to Formula
- 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
- XL3MemberAlias
- XL3MemberSet
- XL3SetProperty
- XL3MemberNavigate
- XL3DynamicPicture
- XL3DoWriteback
- XL3QueryTableSetConnectionString
- XL3QueryTableSetParam
- XL3RunSQL
- XL3QueryTableSetSQL
- XL3RefreshObjectsNamed
- XL3MdxMemberLookup
- XL3DataSeries
- XL3SparkBar
- XL3PropertyLookup
- XL3SparkBullet
- XL3Sparkline
- XL3SparklineM
- XL3SparkColumnsM
- XL3SparkWinLose
- XL3ColumnVisible
- XL3RowVisible
- XL3MdxDataSeries
- XL3MdxLookup
- XL3SparkIcon
- XL3SparkBox
- XL3SparkColumns
- XL3SparkHorizon
- XL3SparkPie
- XL3ValueRankLookup
- XL3RankLookup
- XL3KpiPropertyLookup
- XL3RefreshObjects
- XL3DataSeriesLookup
- XL3WebReportLink
- XL3LookupTabular
- XL3KpiLookup
- XL3HierarchyLookup
- Insert Members
- Insert Ranking
- In-Cell Chart Designer
- Sparkline Chart Designer
- Sparkbar Chart Designer
- Sparkbox Chart Designer
- SparkHorizon Chart Designer
- DotPlot Chart Designer
- SparkColumns Chart Designer
- Web Edition
- Web Publishing
- Web HomePage
- Pie Charts in Web Edition
- Using SQL Parameters
- SQL
- SQL Server 2012
- SQL Administrators
- SQL Data Tables (Administrators)
- SQL Slicers (Administrators)
- Standard SQL Users
- SQL Data Tables (Standard Users)
- SQL Slicers (Standard Users)
- Tables
- Table Properties
- Table Pager Properties
- Tabular
- Tabular Designer
- Reporting Services
- Web Development
- Web Parameters
- 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
