| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "User Manual"
| (7 intermediate revisions by the same user not shown) | |||
| Line 85: | Line 85: | ||
Formula Reference | Formula Reference | ||
<ul class="collapsed"> | <ul class="collapsed"> | ||
| − | <li> | + | <li>OLAP Formulae</li> |
| − | <li> | + | <li>In-Cell Chart Formulae</li> |
| − | <li> | + | <li>Report Management Formulae</li> |
| − | <li> | + | <li>Query Table Formulae</li> |
| − | <li> | + | <li>Tabular Formulae</li> |
</ul> | </ul> | ||
</li> | </li> | ||
| Line 114: | Line 114: | ||
[[Dimension Slicers|Slicers]] | [[Dimension Slicers|Slicers]] | ||
<ul class="collapsed"> | <ul class="collapsed"> | ||
| − | <li> | + | <li>[[Member Selector Slicer]]</li> |
| − | <li> | + | <li>[[Date Slicer]]</li> |
| + | <li>[[Excel Range Slicers]]</li> | ||
</ul> | </ul> | ||
</li> | </li> | ||
| Line 122: | Line 123: | ||
[[Ranking, Sorting and Filtering]] | [[Ranking, Sorting and Filtering]] | ||
<ul class="collapsed"> | <ul class="collapsed"> | ||
| − | <li> | + | <li>[[Keep Members]]</li> |
| − | <li> | + | <li>[[Set Searching]]</li> |
| − | <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> | </ul> | ||
</li> | </li> | ||
| Line 131: | Line 142: | ||
[[Web Edition]] | [[Web Edition]] | ||
<ul class="collapsed"> | <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 Publishing]]</li> | ||
<li>[[Web HomePage|Web Homepage]]</li> | <li>[[Web HomePage|Web Homepage]]</li> | ||
| Line 143: | Line 168: | ||
<li>[[Customising web config]]</li> | <li>[[Customising web config]]</li> | ||
<li>[[Web Parameters]]</li> | <li>[[Web Parameters]]</li> | ||
| − | <li> | + | <li>[[Connection Mapping]]</li> |
<li class="toggle"> | <li class="toggle"> | ||
| − | + | [[Scheduling]] | |
<ul class="collapsed"> | <ul class="collapsed"> | ||
| − | <li> | + | <li>[[Scheduling Installation with a File-based Repository|Installation]]</li> |
| − | <li> | + | <li>[[Scheduling Installation with a SQL Repository|Installation]]</li> |
</ul> | </ul> | ||
</li> | </li> | ||
| − | <li> | + | <li>[[Dual Authentication]]</li> |
</ul> | </ul> | ||
</li> | </li> | ||
| Line 158: | Line 183: | ||
[[SQL]] | [[SQL]] | ||
<ul class="collapsed"> | <ul class="collapsed"> | ||
| + | <li>[[SQL Server 2012]]</li> | ||
<li class="toggle"> | <li class="toggle"> | ||
| − | [[SQL | + | [[SQL Administrators]] |
<ul class="collapsed"> | <ul class="collapsed"> | ||
| − | <li> | + | <li>[[SQL Data Tables (Administrators)]]</li> |
| − | <li> | + | <li>[[SQL Slicers (Administrators)]]</li> |
</ul> | </ul> | ||
| − | |||
| − | |||
</li> | </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> | </ul> | ||
</li> | </li> | ||
</ul> | </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
