XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "User Manual"
(35 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | + | <ul class="tree"> | |
− | + | <li class="toggle"> | |
− | + | [[Introduction|Introduction & Overview]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Introduction#What is XLCubed.3F|What is XLCubed]]</li> | |
− | + | <li>[[Introduction#Data Sources|Data Sources]]</li> | |
− | + | <li>[[Introduction#How is it used.3F|How is it used]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[Introduction#XLCubed_and_Cube_Terminology|XLCubed and Cube Terminology]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Introduction#Measures|Measures]]</li> | |
− | + | <li>[[Introduction#Dimensions.2C_Hierarchies_and_Levels|Dimensions, Hierarchies and Levels]]</li> | |
− | + | <li>[[Introduction#Members|Members]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li class="toggle"> | |
− | + | [[Introduction#Ways to retrieve data in XLCubed|Ways to retrieve data in XLCubed]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Introduction#Grids|Grids]]</li> | |
− | + | <li>[[Introduction#Formulae|Formulae]]</li> | |
− | + | <li>[[Introduction#Grids or Formulae?|Grids or Formulae?]]</li> | |
− | + | <li>[[Introduction#Tables|Tables]]</li> | |
− | + | <li>[[Introduction#Tables or Grids?|Tables or Grids?]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Managing Connections]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Managing Connections#Connecting to your data|Connecting to your data]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Grid Reporting Overview|Grids]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Report Designer|Designing Grids]]</li> | |
− | + | <li>[[Formatting Grids]]</li> | |
− | + | <li>[[Drilling in Grids]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[Grid Calculations]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Subtotals]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Actions]]</li> | |
− | + | <li>[[Outlier Grouping]]</li> | |
− | + | <li>[[Linking Grids]]</li> | |
− | + | <li>[[Member Properties in Grids]]</li> | |
− | + | <li>[[Active Cell Grid Selections]]</li> | |
− | + | <li>[[Propagate Across Sheets]]</li> | |
− | + | <li>[[Breakout Value]]</li> | |
− | + | <li class="toggle"> | |
− | + | Converting Grid Reports | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Convert to Formula]]</li> | |
− | + | <li>[[Convert to Values]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Copying Grids]]</li> | |
− | + | <li>[[Deleting Grids]]</li> | |
− | + | <li>[[Drillthrough]]</li> | |
− | + | <li>[[Expanding Large Hierarchies]]</li> | |
− | + | <li>[[Grid Charts]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Formula Reporting Overview|Formula Reporting]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Grid vs. Formula-based Reporting Key Differences]]</li> | |
− | + | <li>[[Convert to Formula|Formula report from a grid]]</li> | |
− | + | <li class="toggle"> | |
− | + | Inserting formula directly | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Insert Value]]</li> | |
− | + | <li>[[Insert Members]]</li> | |
− | + | <li>[[Insert Member Property]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Drilling in Formula Reports]]</li> | |
− | + | <li class="toggle"> | |
− | + | Formula Reference | |
− | + | <ul class="collapsed"> | |
− | + | <li>OLAP Formulae</li> | |
− | + | <li>In-Cell Chart Formulae</li> | |
− | + | <li>Report Management Formulae</li> | |
− | + | <li>Query Table Formulae</li> | |
− | + | <li>Tabular Formulae</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Charting and Dashboards|Charting & Data Visualisation]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Grid Charts]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[In-Cell Chart Designer|In-Cell Charts]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[In-Cell Charts in Grids]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Small Multiple Charts|Interactive Charting (Small Multiples)]]</li> | |
− | + | <li>[[Maps]]</li> | |
− | + | <li>>[[Treemaps]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Dimension Slicers|Slicers]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Member Selector Slicer]]</li> | |
− | + | <li>[[Date Slicer]]</li> | |
− | + | <li>[[Excel Range Slicers]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Ranking, Sorting and Filtering]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Keep Members]]</li> | |
− | + | <li>[[Set Searching]]</li> | |
− | + | <li>[[Axis Ranking]]</li> | |
− | + | <li>[[Outlier Grouping]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Calculations Overview|Custom Calculations]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Grid Calculations]]</li> | |
− | + | <li>[[MDX Calculations]]</li> | |
− | + | <li>[[DAX Calculations]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Web Edition]] | |
− | + | <ul class="collapsed"> | |
− | + | <li class="toggle"> | |
− | + | Setup | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[XLCubed Web Edition Installation Guide|Installation]]</li> | |
− | + | <li class="toggle"> | |
− | + | Configure XLCubed Web | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Authentication Options with XLCubed Web Edition|Authentication]]</li> | |
− | + | <li>[[SQL Repository|SQL Repository]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Publishing Troubleshooting|Troubleshooting]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Web Publishing]]</li> | |
− | + | <li>[[Web HomePage|Web Homepage]]</li> | |
− | + | <li>[[Creating Reports in Web Edition]]</li> | |
− | + | <li>[[Analytics books]]</li> | |
− | + | <li>[[Auto refresh]]</li> | |
− | + | <li>[[Browsing the XLCubed Web Repository]]</li> | |
− | + | <li>[[Reporting Services]]</li> | |
− | + | <li>[[Web Development]]</li> | |
− | + | <li>[[IPad/iPhone app|Mobile app]]</li> | |
− | + | <li>[[Publishing Connections]]</li> | |
− | + | <li>[[Customising web config]]</li> | |
− | + | <li>[[Web Parameters]]</li> | |
− | + | <li>[[Connection Mapping]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[Scheduling]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Scheduling Installation with a File-based Repository|Installation]]</li> | |
− | + | <li>[[Scheduling Installation with a SQL Repository|Installation]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Dual Authentication]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[SQL]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[SQL Server 2012]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[SQL Administrators]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[SQL Data Tables (Administrators)]]</li> | |
− | + | <li>[[SQL Slicers (Administrators)]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li class="toggle"> | |
− | + | [[Standard SQL Users]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[SQL Slicers (Standard Users)]]</li> | |
− | + | <li>[[SQL Data Tables (Standard Users)]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[Tables]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[SQL]]</li> | |
− | + | <li>[[Multidimensional Table Designer]]</li> | |
− | + | <li class="toggle"> | |
− | + | [[Tabular]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[Tabular Designer]]</li> | |
− | + | <li>[[Table Properties]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | <li>[[Formatting Tables]]</li> | |
− | + | <li>[[Tables#Calculations|Calculations]]</li> | |
− | + | <li>[[Tables#Paging|Paging]]</li> | |
− | + | <li>[[Tables#Sorting|Sorting]]</li> | |
− | + | <li>[[Tables#Sections and Pivoting|Sections and Pivoting]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | <li class="toggle"> | |
− | + | [[SharePoint]] | |
− | + | <ul class="collapsed"> | |
− | + | <li>[[SharePoint#Installing|Installing]]</li> | |
− | + | <li>[[SharePoint#Uninstalling|Uninstalling]]</li> | |
− | + | <li>[[SharePoint#Using WebPart|Using WebPart]]</li> | |
− | + | <li>[[SharePoint#Configuring|Configuring]]</li> | |
− | + | <li>[[SharePoint#Troubleshooting|Troubleshooting]]</li> | |
− | + | <li>[[SharePoint Integration]]</li> | |
− | + | </ul> | |
− | + | </li> | |
− | + | ||
− | + | </ul> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 15:03, 29 April 2019
- Introduction & Overview
- Managing Connections
-
Grids
- Designing Grids
- Formatting Grids
- Drilling in Grids
- Grid Calculations
- 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
-
Formula Reporting
- Grid vs. Formula-based Reporting Key Differences
- Formula report from a grid
- Inserting formula directly
- Drilling in Formula Reports
-
Formula Reference
- OLAP Formulae
- In-Cell Chart Formulae
- Report Management Formulae
- Query Table Formulae
- Tabular Formulae
- Charting & Data Visualisation
- Slicers
- Ranking, Sorting and Filtering
- Custom Calculations
-
Web Edition
-
Setup
- Installation
- Configure XLCubed Web
- Troubleshooting
- Web Publishing
- Web Homepage
- Creating Reports in Web Edition
- Analytics books
- Auto refresh
- Browsing the XLCubed Web Repository
- Reporting Services
- Web Development
- Mobile app
- Publishing Connections
- Customising web config
- Web Parameters
- Connection Mapping
- Scheduling
- Dual Authentication
-
Setup
- SQL
- Tables
- SharePoint