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"> | <ul class="tree"> | ||
<li class="toggle"> | <li class="toggle"> | ||
− | Introduction & Overview | + | [[Introduction|Introduction & Overview]] |
<ul class="collapsed"> | <ul class="collapsed"> | ||
− | <li>What is XLCubed</li> | + | <li>[[Introduction#What is XLCubed.3F|What is XLCubed]]</li> |
− | <li>Data Sources</li> | + | <li>[[Introduction#Data Sources|Data Sources]]</li> |
− | <li>How is it used</li> | + | <li>[[Introduction#How is it used.3F|How is it used]]</li> |
<li class="toggle"> | <li class="toggle"> | ||
− | XLCubed and Cube Terminology | + | [[Introduction#XLCubed_and_Cube_Terminology|XLCubed and Cube Terminology]] |
− | <ul | + | <ul class="collapsed"> |
− | <li>Measures</li> | + | <li>[[Introduction#Measures|Measures]]</li> |
− | <li>Dimensions, Hierarchies and Levels</li> | + | <li>[[Introduction#Dimensions.2C_Hierarchies_and_Levels|Dimensions, Hierarchies and Levels]]</li> |
− | <li>Members</li> | + | <li>[[Introduction#Members|Members]]</li> |
</ul> | </ul> | ||
</li> | </li> | ||
<li class="toggle"> | <li class="toggle"> | ||
− | Ways to retrieve data in XLCubed | + | [[Introduction#Ways to retrieve data in XLCubed|Ways to retrieve data in XLCubed]] |
− | <ul | + | <ul class="collapsed"> |
− | <li>Grids</li> | + | <li>[[Introduction#Grids|Grids]]</li> |
− | <li>Formulae</li> | + | <li>[[Introduction#Formulae|Formulae]]</li> |
− | <li>Grids or Formulae?</li> | + | <li>[[Introduction#Grids or Formulae?|Grids or Formulae?]]</li> |
− | <li>Tables</li> | + | <li>[[Introduction#Tables|Tables]]</li> |
− | <li>Tables or Grids?</li> | + | <li>[[Introduction#Tables or Grids?|Tables or Grids?]]</li> |
</ul> | </ul> | ||
</li> | </li> |
Revision as of 15:43, 28 November 2018
- 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