User contributions
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 17:28, 4 October 2010 (diff | hist) . . (+532) . . N Subtotals (Created page with 'Subtotalling by hierarchy is an option in Grid based reports where a crossjoin has been used. Subtotalling can use any one of the {{Code|Sum}}, {{Code|Avg}}, {{Code|Min}} or {{Co…')
- 14:55, 4 October 2010 (diff | hist) . . (+6) . . Ranking, Sorting and Filtering (Embolden control text)
- 14:53, 4 October 2010 (diff | hist) . . (+599) . . Ranking, Sorting and Filtering (Added ranking step, and edited the rest - more members make a more illuminating demo)
- 14:52, 4 October 2010 (diff | hist) . . (0) . . N File:RankSortFilterDemo9.png
- 13:05, 4 October 2010 (diff | hist) . . (+2,739) . . N Ranking, Sorting and Filtering (Created page with 'The following tutorial shows how to filter, sort and rank using different members of a Cube. It uses the Internet Sales cube. ==Step 1: Simple Filter…')
- 12:58, 4 October 2010 (diff | hist) . . (0) . . N File:SortResultIcon.png
- 12:50, 4 October 2010 (diff | hist) . . (0) . . N File:RankSortFilterDemo7.png
- 12:46, 4 October 2010 (diff | hist) . . (0) . . N File:RankSortFilterDemo6.png
- 12:43, 4 October 2010 (diff | hist) . . (0) . . N File:RankSortFilterDemo5.png
- 12:34, 4 October 2010 (diff | hist) . . (0) . . N File:RankSortFilterDemo3.png
- 11:21, 4 October 2010 (diff | hist) . . (+148) . . Query Tables/Version 6.1 (Added see also (formula reference pages))
- 11:20, 4 October 2010 (diff | hist) . . (+1,162) . . Query Tables/Version 6.1 (Added editing and formulae sections)
- 11:07, 4 October 2010 (diff | hist) . . (+863) . . N Query Tables/Version 6.1 (Created page with 'Query Tables allow you to bring relational data into the Excel environment, while keeping a dynamic link to the data source. This means that when your data changes, your spreadsh…')
- 11:07, 4 October 2010 (diff | hist) . . (0) . . N File:QueryTableWizard4.png
- 10:43, 4 October 2010 (diff | hist) . . (+2,970) . . N Web Publishing (Created page with 'To publish reports from XLCubed you will need to have the XLCubed Web Edition installed on an appropriate server. The publication process is very straightforward and any report t…')
- 11:12, 1 October 2010 (diff | hist) . . (+2) . . m Hierarchy Editor
- 11:10, 1 October 2010 (diff | hist) . . (-26) . . Linking Grids
- 11:09, 1 October 2010 (diff | hist) . . (+68) . . Formula Reference
- 11:05, 1 October 2010 (diff | hist) . . (+304) . . MediaWiki:Common.css
- 17:04, 30 September 2010 (diff | hist) . . (+4) . . Hierarchy Editor
- 17:04, 30 September 2010 (diff | hist) . . (+1,144) . . N Hierarchy Editor (Created page with 'Double-clicking on a Grid's hierarchy label allows you to select the members using the Hierarchy Editor: center The dialog shows the hierarchy…')
- 16:39, 30 September 2010 (diff | hist) . . (0) . . File:GridLinksRibbon.png (uploaded a new version of "File:GridLinksRibbon.png": Changed the file name)
- 16:15, 30 September 2010 (diff | hist) . . (+99) . . Linking Grids
- 16:05, 30 September 2010 (diff | hist) . . (+1,518) . . N Linking Grids (Created page with 'When using Grid reports it is possible to link multiple Grids together to be driven from the same hierarchy. # Insert the two (or more) Grids that you require # Select the {{Men…')
- 16:04, 30 September 2010 (diff | hist) . . (0) . . File:GridLinksRibbon.png (uploaded a new version of "File:GridLinksRibbon.png": Removed smudge in bottom-right corner)
- 15:03, 30 September 2010 (diff | hist) . . (0) . . N File:GridLinksRibbon.png
- 13:00, 30 September 2010 (diff | hist) . . (+1,689) . . N Grid Calculations (Created page with 'The {{Menu|Add Calculation}} option is available on the Grid's right mouse button pop-up menu. For example, if you have the {{Code|Time}} hierarchy on the columns and right clic…')
- 10:57, 30 September 2010 (diff | hist) . . (+12) . . m Grid Charts (→Show All Members)
- 10:56, 30 September 2010 (diff | hist) . . (+1,165) . . N Grid Charts (Created page with 'Grid Charts introduce truly dynamic charting to XLCubed. One or more Grid charts can be tied to each Grid. You have the ability to specify the level being charted (Entire Grid / …')
- 10:31, 30 September 2010 (diff | hist) . . (+9) . . m Driving Grids from an Excel Range (→Further Exercises)
- 10:31, 30 September 2010 (diff | hist) . . (+6) . . m Driving Grids from an Excel Range (→Example (based on the Bicycle Sales cube))
- 17:52, 29 September 2010 (diff | hist) . . (+2,729) . . N Formula Reference (Created page with '==OLAP Formulae== {| | width="200" | XL3Lookup | width="400" | Returns the value for a given cross section of the Cube |- | XL3LookupRW | Returns the value for a given c…')
- 17:08, 29 September 2010 (diff | hist) . . (+2,386) . . N Driving Grids from an Excel Range (Created page with 'For many standard reports, you will want to use data from the Excel workbook to influence your Grids. Driving dimensions from a range provides a simple way to do this, especially…')
- 16:49, 29 September 2010 (diff | hist) . . (0) . . N File:DrivingGridExample5.png
- 16:07, 29 September 2010 (diff | hist) . . (0) . . N File:DrivingGridExample2.png
- 15:34, 29 September 2010 (diff | hist) . . (+71) . . N Deleting Grids (Created page with 'Select the {{Menu|XLCubed|Delete Grid}} menu option to delete the Grid.')
- 15:28, 29 September 2010 (diff | hist) . . (+198) . . N Copying Grids (Created page with 'Selecting the {{Menu|XLCubed|Copy Grid...}} menu option allows you to quickly replicate Grids. Once this option has been selected, select the destination cell and click '''OK'''…')
- 15:26, 29 September 2010 (diff | hist) . . (+8) . . Convert to Values
- 15:25, 29 September 2010 (diff | hist) . . (+91) . . N Convert to Values (Created page with 'The {{Menu|XLCubed|Convert to|Values}} option converts a Grid report into XLCubed formulae.')
- 15:25, 29 September 2010 (diff | hist) . . (-5) . . Convert to Formula
- 15:24, 29 September 2010 (diff | hist) . . (+97) . . N Convert to Formula (Created page with 'The {{Menu|XLCubed|More|Convert to Formula}} option converts a Grid report into XLCubed formulae.')
- 14:45, 29 September 2010 (diff | hist) . . (+1,119) . . N Calculations Overview (Created page with 'XLCubed features three ways to define your own calculations. ==Grid Calculation Columns and Rows== Used only in Grid-based reports, Grid Calculations allow you to define your o…')
- 14:36, 29 September 2010 (diff | hist) . . (+28) . . N InsertRankingForm (Redirected page to Breakout Value)
- 14:33, 29 September 2010 (diff | hist) . . (+1,880) . . N Breakout Value (Created page with 'The Breakout Value option is available on the right mouse button pop-up menu when the currently active cell contains an XL3Lookup function, a XL3ValueRankLookup function, or a Gr…')
- 13:54, 29 September 2010 (diff | hist) . . (+8) . . Actions (List -> bulleted list)
- 13:54, 29 September 2010 (diff | hist) . . (+327) . . N Actions (Created page with 'Actions defined in the Cube can launch applications, perform Drillthroughs, etc. To launch an Action, right-click the cell in the Grid that you want to launch the Action from an…')
- 17:51, 28 September 2010 (diff | hist) . . (+67) . . Licensing Form (Added categories)
- 17:50, 28 September 2010 (diff | hist) . . (-18) . . Licensing Form
- 17:49, 28 September 2010 (diff | hist) . . (0) . . m Licensing Form (moved LicensingForm to Licensing Form)
- 17:49, 28 September 2010 (diff | hist) . . (+77) . . N Licensing Form (Created page with '=Licensing Form= Displays useful information regarding your XLCubed license.')
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
