XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "User Manual"
Line 1: | Line 1: | ||
+ | <ul class="tree"> | ||
+ | <li class="toggle"> | ||
+ | Introduction & Overview | ||
+ | <ul class="collapsed"> | ||
+ | <li>What is XLCubed</li> | ||
+ | <li>Data Sources</li> | ||
+ | <li>How is it used</li> | ||
+ | <li class="toggle"> | ||
+ | XLCubed and Cube Terminology | ||
+ | <ul class="collapsed"> | ||
+ | <li>Measures</li> | ||
+ | <li>Dimensions, Hierarchies and Levels</li> | ||
+ | <li>Members</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | <li class="toggle"> | ||
+ | Ways to retrieve data in XLCubed | ||
+ | <ul class="collapsed"> | ||
+ | <li>Grids</li> | ||
+ | <li>Formulae</li> | ||
+ | <li>Grids or Formulae?</li> | ||
+ | <li>Tables</li> | ||
+ | <li>Tables or Grids?</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | </ul> | ||
+ | |||
*[[Introduction|Introduction & Overview]] | *[[Introduction|Introduction & Overview]] |
Revision as of 15:39, 28 November 2018
-
Introduction & Overview
- What is XLCubed
- Data Sources
- How is it used
-
XLCubed and Cube Terminology
- Measures
- Dimensions, Hierarchies and Levels
- Members
-
Ways to retrieve data in XLCubed
- Grids
- Formulae
- Grids or Formulae?
- Tables
- Tables or Grids?
- Introduction & Overview
- QuickStart
- Grids
- Grid Reporting Overview
- Grid Components
- Basic Navigation
- Report Designer
- Calculations Overview
- Grid Calculations
- Subtotals
- Actions
- Outlier Grouping
- Linking Grids
- Member Properties in Grids
- Active Cell Grid Selections
- Propagate Across Sheets
- Breakout Value
- Converting Grid Reports
- Copying Grids
- Deleting Grids
- Drillthrough
- Expanding Large Hierarchies
- Grid Charts
- Formulae Reporting
- Formula Reference
- OLAP Formulae
- Formula Reference
- In-Cell Chart Formulae
- Report Management Formulae
- Query Table Formulae
- Tabular Formulae
- Charting & Data Visualisation
- Web Edition
- Step 1. Design your report
- Step 2. Publish your report
- Step 3. View the report in a browser
- Step 4. Enjoy OLAP in a browser
- Web Publishing
- Analytics books
- Auto refresh
- Browsing the XLCubed Web Repository
- Reporting Services
- Web Development
- HTML:
- Mobile app
- Publishing Connections
- Customising web config
- Web Parameters
- Connection Mapping
- Dual Authentication
- Scheduling
- Dimension Slicers
- Ranking, Sorting and Filtering
- SQL
- Tables
- SharePoint
- Miscellaneous
- XLCubed Options
- MDX Calculations
- Writeback
- Converting ProClarity Reports
- Publishing PowerPivot Reports
- Using Grids with Protected Worksheets
- Copy Sheet
- Macros
- Adding Round Corners to Excel
- Pie Charts in Web Edition
- Removing Zeros from a Grid Report
- Mdx:
- Managing Favourites
- Create a grid report which I want to save as a favourite for my own use
- Create a grid report which I want to save as a favourite and share with other Excel Edition users
- Create a grid report which I want to save as a favourite and share with other Web Edition users
- Create a workbook template that I can save as a favourite and share with other Excel Edition users