XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "User Manual"
 
(12 intermediate revisions by the same user not shown)
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 class="collapsed">
+
                 <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 class="collapsed">
+
                 <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>
 +
            </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>
 
                 </ul>
 
             </li>
 
             </li>
 
         </ul>
 
         </ul>
 
     </li>
 
     </li>
−
</ul>
 
  
 +
    <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>
  
−
*[[Introduction|Introduction & Overview]]
+
    <li class="toggle">
−
** [[Introduction#What is XLCubed.3F|What is XLCubed]]
+
        [[Dimension Slicers|Slicers]]
−
** [[Introduction#Data Sources|Data Sources]]
+
        <ul class="collapsed">
−
** [[Introduction#How is it used.3F|How is it used]]
+
            <li>[[Member Selector Slicer]]</li>
−
** [[Introduction#XLCubed_and_Cube_Terminology|XLCubed and Cube Terminology]]
+
            <li>[[Date Slicer]]</li>
−
*** [[Introduction#Measures|Measures]]
+
            <li>[[Excel Range Slicers]]</li>
−
*** [[Introduction#Dimensions.2C_Hierarchies_and_Levels|Dimensions, Hierarchies and Levels]]
+
        </ul>
−
*** [[Introduction#Members|Members]]
+
    </li>
−
**[[Introduction#Ways to retrieve data in XLCubed|Ways to retrieve data in XLCubed]]
 
−
***[[Introduction#Grids|Grids]]
 
−
***[[Introduction#Formulae|Formulae]]
 
−
***[[Introduction#Grids or Formulae?|Grids or Formulae?]]
 
−
***[[Introduction#Tables|Tables]]
 
−
***[[Introduction#Tables or Grids?|Tables or Grids?]]
 
−
*QuickStart
 
−
**[[Managing Connections]]
 
−
**[[Managing Connections#Connecting to your data|Connecting to your data]]
 
−
***[[Managing Connections#Connection Manager|Connection Manager]]
 
−
*Grids
 
−
** [[Grid Reporting Overview]]
 
−
** [[Grid_Reporting_Overview#Grid_Components|Grid Components]]
 
−
** [[Grid_Reporting_Overview#Basic_Navigation|Basic Navigation]]
 
−
*** [[Grid_Reporting_Overview#Edit_Grid|Edit Grid]]
 
−
*** [[Grid_Reporting_Overview#Grid_Task_Pane_.282007.2F2010_only.29|Grid Task Pane (2007 onwards)]]
 
−
*** [[Grid_Reporting_Overview#Saved_Grid_Reports|Saved Grid Report]]
 
−
*** [[Grid_Reporting_Overview#Refresh_Grids|Refresh Grid]]
 
−
** [[Report Designer]]
 
−
*** [[Report Designer#General_Layout|General Layout]]
 
−
*** [[Report Designer#Moving_Hierarchies|Moving Hierarchies]]
 
−
*** [[Report Designer#Toolbar|Toolbar]]
 
−
*** [[Grid Properties]]
 
−
*** [[Formatting Grids]]
 
−
*** [[Drilling in Grids]]
 
−
** [[Calculations Overview]]
 
−
*** [[Calculations Overview#Grid Calculation Columns and Rows|Grid Calculation Columns and Rows]]
 
−
*** [[Calculations Overview#MDX Calculated Members|MDX Calculated Members]]
 
−
*** [[Calculations Overview#XLCubed OLAP Formulae|XLCubed OLAP Formulae]]
 
−
** [[Grid Calculations]]
 
−
***[[Grid Calculations#Member Selector and Adhoc Groupings|Member Selector and Adhoc Groupings]]
 
−
***[[Grid Calculations#Share to Base: Calculated Value on Measure|Share to Base: Calculated Value on Measure]]
 
−
***[[Grid Calculations#Pareto Columns (new in v7.2)|Pareto Columns]]
 
−
**[[Subtotals]]
 
−
***[[Subtotals#Cube vs Excel mode|Cube vs Excel Mode]]
 
−
**[[Actions]]
 
−
**[[Outlier Grouping]]
 
−
**[[Linking Grids]]
 
−
**[[Member Properties in Grids]]
 
−
***[[Member Properties in Grids#Examples (using the Internet Sales cube)|Examples (using the Internet Sales cube)]]
 
−
**[[Active Cell Grid Selections]]
 
−
***[[Active Cell Grid Selections#Example|Example]]
 
−
***[[Active Cell Grid Selections#Additional Options|Additional Options]]
 
−
**[[Propagate Across Sheets]]
 
−
***[[Propagate Across Sheets#Advanced Propagate|Advanced Propagate]]
 
−
***[[Propagate Across Sheets#Create new Workbook|Create new Workbook]]
 
−
**[[Breakout Value]]
 
−
***[[Breakout Value#Track Active Cell|Track Active Cell]]
 
−
**Converting Grid Reports
 
−
***[[Convert to Formula]]
 
−
***[[Convert to Values]]
 
−
**[[Copying Grids]]
 
−
**[[Deleting Grids]]
 
−
**[[Drillthrough]]
 
−
**[[Expanding Large Hierarchies]]
 
−
**[[Grid Charts]]
 
−
***[[Grid Charts#Chart Types|Chart Types]]
 
−
***[[Grid Charts#Configuring Existing Charts|Configuring Existing Charts]]
 
−
*Formulae Reporting
 
−
**[[Grid vs. Formula-based Reporting Key Differences]]
 
−
**[[Drilling in Formula Reports]]
 
−
**[[Insert Value]]
 
−
***[[Insert Value#Additional Options|Additional Options]]
 
−
**[[Insert Members]]
 
−
***[[Insert Members#Additional Options|Additional Options]]
 
−
**[[Insert Member Property]]
 
−
**Formula wizards
 
  
−
**Formula Reference
+
    <li class="toggle">
−
***OLAP Formulae
+
        [[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>
  
−
***In-Cell Chart Formulae
+
    <li class="toggle">
 +
        [[Calculations Overview|Custom Calculations]]
 +
        <ul class="collapsed">
 +
            <li>[[Grid Calculations]]</li>
 +
            <li>[[MDX Calculations]]</li>
 +
            <li>[[DAX Calculations]]</li>
 +
        </ul>
 +
    </li>
  
−
***Report Management Formulae‎
+
    <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>
  
−
***Query Table Formulae
+
    <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>
  
−
***Tabular Formulae
+
    <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>
  
−
*[[Charting and Dashboards|Charting & Data Visualisation]]
+
    <li class="toggle">
−
**[[Charting and Dashboards#Standard Excel Charts|Standard Excel Charts]]
+
        [[SharePoint]]
−
**[[Charting and Dashboards#XLCubed Grid Charts|XLCubed Grid Charts]]
+
        <ul class="collapsed">
−
**[[Charting and Dashboards#In-cell Charts|In-Cell Charts]]
+
            <li>[[SharePoint#Installing|Installing]]</li>
−
**[[Charting and Dashboards#Small Multiples|Small Multiples]]
+
            <li>[[SharePoint#Uninstalling|Uninstalling]]</li>
−
**[[Charting and Dashboards#TreeMaps|Treemaps]]
+
            <li>[[SharePoint#Using WebPart|Using WebPart]]</li>
−
**[[Charting and Dashboards#Mapping|Mapping]]
+
            <li>[[SharePoint#Configuring|Configuring]]</li>
−
**[[In-Cell Charts in Grids]]
+
            <li>[[SharePoint#Troubleshooting|Troubleshooting]]</li>
−
***[[In-Cell Charts in Grids#Visual Grids for Time Series Analysis|Visual Grids for Time Series Analysis]]
+
            <li>[[SharePoint Integration]]</li>
−
***[[In-Cell Charts in Grids#Visual Grids for Performance Analysis|Visual Grids for Performance Analysis]]
+
        </ul>
−
**[[Small Multiple Charts]]
+
    </li>
−
***[[Small Multiple Charts#UI|User Interface]]
 
−
***[[Small Multiple Charts#Small Multiple Charts based on other data sources|Small Multiple Charts based on other data sources]]
 
−
**[[Interactive Charting]]
 
−
***[[Interactive Charting#Chart Selections|Chart Selections]]
 
−
***[[Interactive Charting#Chart Formatting|Chart Formatting]]
 
−
***[[Interactive Charting#SQL and Excel sourced Charts|SQL and Excel sourced Charts]]
 
−
**[[In-Cell Chart Designer]]
 
  
−
**[[Maps]]
+
</ul>
−
***[[Maps#UI|User Interface]]
 
−
**[[Treemaps]]
 
−
***[[Treemaps#Data sources|Data sources]]
 
−
***[[Treemaps#Common Options|Common Options]]
 
−
*[[Web Edition]]
 
−
**[[Web Edition#Step 1. Design your report|Step 1. Design your report]]
 
−
**[[Web Edition#Step 2. Publish your report|Step 2. Publish your report]]
 
−
**[[Web Edition#Step 3. View the report in a browser|Step 3. View the report in a browser]]
 
−
**[[Web Edition#Step 4. Enjoy OLAP in a browser|Step 4. Enjoy OLAP in a browser]]
 
−
**[[Web Publishing]]
 
−
***[[Web Publishing#Publication Process|Publication Process]]
 
−
***[[Web Publishing#Manage Repository|Manage Repository]]
 
−
***[[Web HomePage|Web Edition]]
 
−
***[[Web HomePage#Toolbar|Toolbar]]
 
−
***[[Web HomePage#Report Tabs|Report Tabs]]
 
−
***[[Web HomePage#Report Area|Report Area]]
 
−
***[[Creating Reports in Web Edition]]
 
−
**[[Analytics books]]
 
−
***[[Analytics books#Creating a new book|Creating a new book]]
 
−
***[[Analytics books#Standard UI|Standard UI]]
 
−
***[[Analytics books#Report Header|Report Header]]
 
−
***[[Analytics books#Report Types|Report Types]]
 
−
**[[Auto refresh]]
 
−
**[[Browsing the XLCubed Web Repository]]
 
−
**[[Reporting Services]]
 
−
**[[Web Development]]
 
−
***[[Web Development#Direct report linking|Direct report linking]]
 
−
***[[Web Development#Embedding Workbooks|Embedding Workbooks]]
 
−
***[[Web Development#Embedding Repository|Embedding Repository]]
 
−
***[[Web Development#Customising HTML|Customising HTML]]
 
−
**[[HTML:]]
 
−
**[[IPad/iPhone app|Mobile app]]
 
−
***[[IPad/iPhone app#Report Navigation|Report Navigation]]
 
−
***[[Mobile analytics]]
 
−
**[[Publishing Connections]]
 
−
**[[Customising web config]]
 
−
**[[Web Parameters]]
 
−
***[[Web Parameters#Using Web Parameters Example|Using Web Parameters Example]]
 
−
**[[Connection Mapping]]
 
−
***[[Connection Mapping#Example XML file|Example XML file]]
 
−
**[[Dual Authentication]]
 
−
**[[Scheduling]]
 
−
***[[Scheduling#Concepts|Concepts]]
 
−
***[[Sending A Scheduled Report Using A SQL Query]]
 
−
***[[Sending A Scheduled Report Using Integration Services]]
 
−
***[[Scheduling Installation with a File-based Repository|Installation]]
 
−
***[[Scheduling Installation with a SQL Repository|Installation]]
 
−
*[[Dimension Slicers]]
 
−
**[[Dimension Slicers#Grid Slicers|Grid Slicers]]
 
−
**[[Dimension Slicers#Standalone Slicers|Standalone Slicers]]
 
−
**[[Member Selector Slicer]]
 
−
**[[Date Slicer]]
 
−
**[[Dimension Slicers#Updating Excel Ranges|Updating Excel Ranges]]
 
−
**[[Dimension Slicers#Excel Range Slicers|Excel Range Slicers]]
 
−
**[[Dimension Slicers#Members with no data / Non empty|Members with no data / Non empty]]
 
−
**[[Dimension Slicers#Cascading and Advanced Slicers|Cascading and Advanced Slicers]]
 
−
**[[Dimension Slicers#Initial Value|Initial Value]]
 
−
**[[Dimension Slicers#Disabling Slicers|Disabling Slicers]]
 
−
**[[Dimension Slicers#Wait for Submit on Web|Wait for Submit on Web]]
 
−
*[[Ranking, Sorting and Filtering]]
 
−
**[[Ranking, Sorting and Filtering#Simple Filtering|Simple Filtering]]
 
−
**[[Ranking, Sorting and Filtering#Sorting on a different dimension|Sorting on a different dimension]]
 
−
**[[Ranking, Sorting and Filtering#Combining Ranking, Filtering and Sorting|Combining Ranking, Filtering and Sorting]]
 
−
**[[Ranking, Sorting and Filtering#Sorting slicer elements|Sorting slicer elements]]
 
−
**[[Ranking, Sorting and Filtering#Sorting by sub-category within category|Sorting by sub-category within category]]
 
−
**[[Ranking, Sorting and Filtering#Driving Reports from Excel|Driving Reports from Excel]]
 
−
**[[Set Searching]]
 
−
***[[Set Searching#Member Search|Member Search]]
 
−
**[[Axis Ranking]]
 
−
***[[Axis Ranking#Axis Ranking, Filtering and Sorting|Axis Ranking, Filtering and Sorting]]
 
−
**[[Outlier Grouping]]
 
−
***[[Outlier Grouping#Ranking|Ranking]]
 
−
***[[Outlier Grouping#User driven grouping|User driven grouping]]
 
−
*[[SQL]]
 
−
**[[SQL Server 2012]]
 
−
***[[SQL Administrators]]
 
−
***[[Standard SQL Users]]
 
−
**[[SQL Data Tables (Administrators)]]
 
−
***[[SQL Data Tables (Administrators)#Inserting a SQL Data Table|Inserting a SQL Data Table]]
 
−
***[[SQL Data Tables (Administrators)#Using Parameters|Using Parameters]]
 
−
***[[SQL Data Tables (Administrators)#Using Stored Procedures|Using Stored Procedures]]
 
−
***[[SQL Data Tables (Administrators)#Publishing Queries|Publishing Queries]]
 
−
**[[SQL Data Tables (Standard Users)]]
 
−
***[[SQL Data Tables (Standard Users)#Inserting a SQL Data Table|Inserting a SQL Data Table]]
 
−
***[[SQL Data Tables (Standard Users)#Using Parameters|Using Parameters]]
 
−
**[[SQL Slicers (Administrators)]]
 
−
***[[SQL Slicers (Administrators)#Introduction|Introduction]]
 
−
***[[SQL Slicers (Administrators)#Using Slicers for Table Parameters|Using Slicers for Table Parameters]]
 
−
***[[SQL Slicers (Administrators)#Standalone Slicers|Standalone Slicers]]
 
−
**[[SQL Slicers (Standard Users)]]
 
−
***[[SQL Slicers (Standard Users)#Introduction|Introduction]]
 
−
***[[SQL Slicers (Standard Users)#Standalone Slicers|Standalone Slicers]]
 
−
**[[Using SQL Parameters]]
 
−
***[[Using SQL Parameters#Creating SQL Parameters|Creating SQL Parameters]]
 
−
***[[Using SQL Parameters#Static Values|Static Values]]
 
−
***[[Using SQL Parameters#Values from an Excel range|Values from an Excel range]]
 
−
***[[Using SQL Parameters#Values from a Slicer|Values from a Slicer]]
 
−
*[[Tables]]
 
−
**[[SQL]]
 
−
**[[Multidimensional Table Designer]]
 
−
***[[Multidimensional Table Designer#Designer|Designer]]
 
−
**[[Tabular]]
 
−
***[[Tabular#Grids|Grids]]
 
−
***[[Tabular#Tables|Tables]]
 
−
***[[Tabular#Slicers|Slicers]]
 
−
***[[Tabular#Calculations|Calculations]]
 
−
**[[Tabular Designer]]
 
−
***[[Tabular Designer#Report layout|Report layout]]
 
−
***[[Tabular Designer#Member filters|Member filters]]
 
−
***[[Tabular Designer#Measure filters|Measure filters]]
 
−
***[[Table Properties]]
 
−
**[[Formatting Tables]]
 
−
***[[Tables#Formatting Columns|Formatting Columns]]
 
−
***[[Tables#Formatting Values|Formatting Values]]
 
−
**[[Tables#Calculations|Calculations]]
 
−
**[[Tables#Paging|Paging]]
 
−
**[[Tables#Sorting|Sorting]]
 
−
**[[Tables#Sections and Pivoting|Sections and Pivoting]]
 
−
**[[Tables#Pivoting|Pivoting]]
 
−
*[[SharePoint]]
 
−
**[[SharePoint#Installing|Installing]]
 
−
**[[SharePoint#Uninstalling|Uninstalling]]
 
−
**[[SharePoint#Using WebPart|Using WebPart]]
 
−
**[[SharePoint#Configuring|Configuring]]
 
−
**[[SharePoint#Troubleshooting|Troubleshooting]]
 
−
**[[SharePoint Integration]]
 
−
***[[SharePoint Integration#Installing|Installing]]
 
−
***[[SharePoint Integration#Custom Handler|Custom Handler]]
 
−
***[[SharePoint Integration#Set icon file type|Set icon file type]]
 
−
***[[SharePoint Integration#Custom Report Page (Optional)|Custom Report Page]]
 
−
***[[SharePoint Integration#Configure redirect|Configure redirect]]
 
−
***[[SharePoint Integration#Searching|Searching]]
 
−
***[[SharePoint Integration#Sharepoint on different server|Sharepoint on different server]]
 
−
***[[SharePoint Integration#Using|Using]]
 
−
*Miscellaneous
 
−
**[[XLCubed Options]]
 
−
***[[XLCubed Options#Main|Main]]
 
−
***[[XLCubed Options#Web Publication|Web Publication]]
 
−
***[[XLCubed Options#Workbook Defaults|Workbook Defaults]]
 
−
**[[MDX Calculations]]
 
−
***[[MDX Calculations#Creating Calculated Members (based on the Bicycle Sales cube)|Creating Calculated Members]]
 
−
***[[MDX Calculations#Creating Named Sets|Creating Named Sets]]
 
−
***[[MDX Calculations#Show with Captions|Show with Captions]]
 
−
**[[Writeback]]
 
−
***[[Writeback#Writeback in XLCubed Grids|Writeback in XLCubed Grids]]
 
−
***[[Writeback#Formula Writeback|Formula Writeback]]
 
−
***[[Relational Writeback]]
 
−
**[[Converting ProClarity Reports]]
 
−
***[[Converting ProClarity Reports#Importing a Briefing Book|Importing a Briefing Book]]
 
−
**[[Publishing PowerPivot Reports]]
 
−
***[[Publishing PowerPivot Reports#Requirements|Requirements]]
 
−
***[[Publishing PowerPivot Reports#Overview|Overview]]
 
−
***[[Publishing PowerPivot Reports#Configuration|Configuration]]
 
−
**[[Using Grids with Protected Worksheets]]
 
−
***[[Using Grids with Protected Worksheets#Set the XLCubed Workbook Options to use your password|Set the XLCubed Workbook Options to use your password]]
 
−
***[[Using Grids with Protected Worksheets#Placing the Grid on a non-protected worksheet|Placing the Grid on a non-protected worksheet]]
 
−
***[[Using Grids with Protected Worksheets#Alternatives|Alternatives]]
 
−
**[[Copy Sheet]]
 
−
**[[Macros]]
 
−
**[[Adding Round Corners to Excel]]
 
−
***[[Adding Round Corners to Excel#Adding Round Corners|Adding Round Corners]]
 
−
***[[Adding Round Corners to Excel#Editing Existing Corners|Editing Existing Corners]]
 
−
***[[Adding Round Corners to Excel#Resizing Columns/Rows|Resizing Columns/Rows]]
 
−
**[[Pie Charts in Web Edition]]
 
−
**[[Removing Zeros from a Grid Report]]
 
−
***[[Removing Zeros from a Grid Report#Example|Example]]
 
−
***[[Removing Zeros from a Grid Report#Editing the filter|Editing the filter]]
 
−
**[[Mdx:]]
 
−
***[[Mdx:#Description|Description]]
 
−
***[[Mdx:#Syntax|Syntax]]
 
−
***[[Mdx:#Examples|Examples]]
 
−
**[[Managing Favourites]]
 
−
***[[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 for my own use]]
 
−
***[[Managing Favourites#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 Excel Edition users]]
 
−
***[[Managing Favourites#Create a grid report which I want to save as a favourite and share with other Web Edition users|Create a grid report which I want to save as a favourite and share with other Web Edition users]]
 
−
***[[Managing Favourites#Create a workbook template that I can save as a favourite and share with other Excel Edition users|Create a workbook template that I can save as a favourite and share with other Excel Edition users]]
 

Latest revision as of 15:03, 29 April 2019

Retrieved from ‘https://help.xlcubed.com/index.php?title=User_Manual&oldid=9527’