XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "User Manual"
Line 24: | Line 24: | ||
</ul> | </ul> | ||
</li> | </li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | |||
+ | <li class="toggle"> | ||
+ | Quickstart | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Managing Connections]]</li> | ||
+ | <li class="toggle"> | ||
+ | [[Managing Connections#Connecting to your data|Connecting to your data]] | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Managing Connections#Connection Manager|Connection Manager]]</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | |||
+ | <li class="toggle"> | ||
+ | Grids | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Grid Reporting Overview]]</li> | ||
+ | <li>[[Grid_Reporting_Overview#Grid_Components|Grid Components]]</li> | ||
+ | <li class="toggle"> | ||
+ | [[Grid_Reporting_Overview#Basic_Navigation|Basic Navigation]] | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Grid_Reporting_Overview#Edit_Grid|Edit Grid]]</li> | ||
+ | <li>[[Grid_Reporting_Overview#Grid_Task_Pane_.282007.2F2010_only.29|Grid Task Pane (2007 onwards)]]</li> | ||
+ | <li>[[Grid_Reporting_Overview#Saved_Grid_Reports|Saved Grid Report]]</li> | ||
+ | <li>[[Grid_Reporting_Overview#Refresh_Grids|Refresh Grid]]</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | <li class="toggle"> | ||
+ | [[Report Designer]] | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Report Designer#General_Layout|General Layout]]</li> | ||
+ | <li>[[Report Designer#Moving_Hierarchies|Moving Hierarchies]]</li> | ||
+ | <li>[[Report Designer#Toolbar|Toolbar]]</li> | ||
+ | <li>[[Grid Properties]]</li> | ||
+ | <li>[[Formatting Grids]]</li> | ||
+ | <li>[[Drilling in Grids]]</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | <li class="toggle"> | ||
+ | [[Calculations Overview]] | ||
+ | <ul class="collapsed"> | ||
+ | <li>[[Calculations Overview#Grid Calculation Columns and Rows|Grid Calculation Columns and Rows]]</li> | ||
+ | <li>[[Calculations Overview#MDX Calculated Members|MDX Calculated Members]]</li> | ||
+ | <li>[[Calculations Overview#XLCubed OLAP Formulae|XLCubed OLAP Formulae]]</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | <li class="toggle"> | ||
+ | [[Grid Calculations]] | ||
+ | <ul class="collapsed"> | ||
+ | <li>***[[Grid Calculations#Member Selector and Adhoc Groupings|Member Selector and Adhoc Groupings]]</li> | ||
+ | <li>***[[Grid Calculations#Share to Base: Calculated Value on Measure|Share to Base: Calculated Value on Measure]]</li> | ||
+ | <li>***[[Grid Calculations#Pareto Columns (new in v7.2)|Pareto Columns]]</li> | ||
+ | </ul> | ||
+ | </li> | ||
+ | |||
</ul> | </ul> | ||
</li> | </li> | ||
</ul> | </ul> | ||
− | |||
*[[Introduction|Introduction & Overview]] | *[[Introduction|Introduction & Overview]] |
Revision as of 15:50, 28 November 2018
- Introduction & Overview
- Quickstart
- 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