| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "UserGuidePDFPages"
| (34 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [http://www.xlcubed.com/help/index.php?title= | + | [http://www.xlcubed.com/help/index.php?title=UserGuidePDFPages&action=pdfbook Print me] |
| − | |||
* [[Introduction]] | * [[Introduction]] | ||
| − | |||
| − | |||
* [[Grid Reporting Overview]] | * [[Grid Reporting Overview]] | ||
* [[Formula Reporting Overview]] | * [[Formula Reporting Overview]] | ||
| Line 11: | Line 8: | ||
* [[Managing Connections]] | * [[Managing Connections]] | ||
* [[Report Designer]] | * [[Report Designer]] | ||
| + | * [[Dragging and Dropping in Grids]] | ||
| + | * [[Managing Favourites]] | ||
| + | * [[Grid Templates]] | ||
| + | * [[Saved Member Lists]] | ||
| + | * [[Task Pane]] | ||
* [[Hierarchy Editor]] | * [[Hierarchy Editor]] | ||
* [[Hierarchy Information]] | * [[Hierarchy Information]] | ||
| − | * [[ | + | * [[Member Selector Slicer]] |
| − | * [[ | + | * [[Date Slicer]] |
| − | |||
* [[PdfBookPages/Excel Range Slicers]] | * [[PdfBookPages/Excel Range Slicers]] | ||
* [[PdfBookPages/Excel Range Slicers Version 6.5]] | * [[PdfBookPages/Excel Range Slicers Version 6.5]] | ||
* [[PdfBookPages/Formatting Grids]] | * [[PdfBookPages/Formatting Grids]] | ||
* [[PdfBookPages/Formatting Grids Version 6.5]] | * [[PdfBookPages/Formatting Grids Version 6.5]] | ||
| − | * [[ | + | * [[Driving Grids from an Excel Range]] |
| + | * [[Level based formatting]] | ||
* [[Calculations Overview]] | * [[Calculations Overview]] | ||
| − | * [[ | + | * [[Grid Calculations]] |
* [[Asymmetric Grids]] | * [[Asymmetric Grids]] | ||
| − | |||
| − | |||
| − | |||
* [[Ranking, Sorting and Filtering]] | * [[Ranking, Sorting and Filtering]] | ||
* [[Axis Ranking]] | * [[Axis Ranking]] | ||
| − | * [[ | + | * [[Subtotals]] |
| − | * [[ | + | * [[Member Properties in Grids]] |
| − | |||
* [[Grid Charts]] | * [[Grid Charts]] | ||
| − | * [[Grid | + | * [[Grid Properties]] |
| − | * [[ | + | * [[Refresh Grids and Formulae]] |
| − | * [[ | + | * [[Drilling in Grids]] |
| − | * [[Drillthrough]] | + | * [[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]] | * [[In-Cell Charts in Grids]] | ||
| − | |||
| − | |||
* [[Small Multiple Charts]] | * [[Small Multiple Charts]] | ||
| − | * [[ | + | * [[Small Multiple Charts based on SQL]] |
| − | * [[ | + | * [[Small Multiple Charts based on Excel Ranges]] |
| − | * [[ | + | * [[Dimension Slicers]] |
| − | + | ||
| − | * [[Advanced Row | + | * [[Advanced Row and Column selections]] |
| − | * [[ | + | * [[Expanding Large Hierarchies]] |
| − | |||
| − | |||
| − | |||
| − | |||
* [[Copying Grids]] | * [[Copying Grids]] | ||
* [[Deleting Grids]] | * [[Deleting Grids]] | ||
| − | * [[ | + | * [[Propagate Across Sheets]] |
| − | * [[ | + | * [[Adding Round Corners to Excel]] |
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[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]] |
| + | * [[XL3MemberLookup]] | ||
| + | * [[Publishing PowerPivot Reports]] | ||
| + | * [[Interactive Charting]] | ||
* [[XL3Lookup]] | * [[XL3Lookup]] | ||
* [[XL3LookupRW]] | * [[XL3LookupRW]] | ||
| − | * [[ | + | * [[XL3RankLookup]] |
| − | * [[ | + | * [[XL3ValueRankLookup]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[XL3PropertyLookup]] | * [[XL3PropertyLookup]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[XL3KpiPropertyLookup]] | * [[XL3KpiPropertyLookup]] | ||
| − | |||
* [[XL3DataSeriesLookup]] | * [[XL3DataSeriesLookup]] | ||
| − | * [[ | + | * [[XL3MemberNavigate]] |
| − | * [[ | + | * [[XL3Link]] |
| − | * [[ | + | * [[XL3RowVisible]] |
| − | * [[ | + | * [[XL3ColumnVisible]] |
| − | + | ||
* [[Insert Ranking]] | * [[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]] | * [[In-Cell Chart Designer]] | ||
* [[SparkLine Chart Designer]] | * [[SparkLine Chart Designer]] | ||
| + | * [[SparkColumns Chart Designer]] | ||
| + | * [[SparkWinLose Chart Designer]] | ||
* [[SparkBar Chart Designer]] | * [[SparkBar Chart Designer]] | ||
| + | * [[SparkBullet Chart Designer]] | ||
| + | * [[SparkIcon Chart Designer]] | ||
| + | * [[SparkPie Chart Designer]] | ||
| + | * [[SparkHorizon Chart Designer]] | ||
* [[SparkBox Chart Designer]] | * [[SparkBox Chart Designer]] | ||
| − | |||
* [[DotPlot Chart Designer]] | * [[DotPlot Chart Designer]] | ||
| − | * [[ | + | * [[Lollipop Chart Designer]] |
| − | * [[ | + | * [[Bandline Chart Designer]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Using SQL Parameters]] | * [[Using SQL Parameters]] | ||
* [[SQL]] | * [[SQL]] | ||
| Line 148: | Line 135: | ||
* [[Reporting Services]] | * [[Reporting Services]] | ||
* [[Web Development]] | * [[Web Development]] | ||
| + | * [[HTML:]] | ||
| + | * [[Analytics books]] | ||
| + | * [[ValidateConnection]] | ||
| + | * [[Clear all data values]] | ||
* [[Web Parameters]] | * [[Web Parameters]] | ||
| − | |||
* [[Connection Mapping]] | * [[Connection Mapping]] | ||
| + | * [[Dual Authentication]] | ||
* [[SharePoint]] | * [[SharePoint]] | ||
| − | + | * [[Scheduling with the File-based Repository]] | |
| − | * [[Scheduling]] | + | * [[Scheduling with the SQL Repository]] |
| − | * [[Scheduling | ||
* [[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]] | ||
| − | |||
| − | |||
* [[Publishing SQL Queries]] | * [[Publishing SQL Queries]] | ||
* [[Publishing Connections]] | * [[Publishing Connections]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
* [[Example of connecting to a relational database - Adventure Works]] | * [[Example of connecting to a relational database - Adventure Works]] | ||
| − | * [[ | + | * [[Converting ProClarity Reports]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 11:13, 5 February 2018
- 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
- 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
