CubePlayer 2.7 Help Library Introduction What is CubePlayer? Hardware and software requirements Edition differences Master and standard mode license Installing and registering CubePlayer Installation License upgrade Updating CubePlayer Docking windows and tabs Docking windows configuration Move window left or right Opened windows menu Compare two windows Application shortcus MDX Editor shortcuts MDX Designer shortcuts Query and Dashboard shortcuts Registered objects shortcuts Control key Opened windows LocaleID CubePlayer application Main menu Home tab Designer tab Dashboard tab Table tab Graph tab MiniGraph tab Skins menu Tools menu Windows menu View menu Help menu Edit tab Quick Access Toolbar Application menu Tab menu Control Panel menu Designer menu Query menu Editor menu Dashboard menu ABC+ menu Workspace window Workspace generator Dashboard generator Dynamic document generator Static report generator History generator Registered objects window Connection explorer Workspace explorer Dashboard explorer Dynamic documents explorer Static reports explorer Repository explorer Local repository explorer Reporting Services Server explorer CubePlayer objects Registered objects (Favorites) Workspace Solution Designer Queries History Editor Dashboard Dynamic document Static report Tools and configuration Graph color schema CubePlayer configuration LocaleID Change connections Docking windows configuration Master Catalog location MS Excel file path Documentation file path Control Panel Style Create configuration file Import configuration file Control Panel Connection group Create connection to SSAS Create connection to Oracle Create connection to Mondrian Create connection to Local cubes HTTP connection Username and password Connecting Delete connction Move left or right Workspace Add workspace Loading in workspace Remove workspace Move left or right Reports group Add report group Add Objects to the group Remove object from group Move left or right Open with and Brows operations Control panel modes Save Control Panel to Local repository Run (load) Control Panel from Local repository Run (load) from Master Catalog Control panel selector Clear Control panel Redo and Undo changes Control panel and button styles Set new Control panel style Control Panel skins Reset Control panel style Set button style Node size Copy and paste button style Connections Stand alone OLAP server Connect to SSAS Create connection to Oracle Create connection to Mondrian Remove connection Connecting to the server Change connections Connect to Local cubes Local repository Repository Editor MDX Editor Editing area Drag and drop objects Cube and function explorer Fast preview and syntax checker Fast preview Part of MDX Edit tab New window Zoom Info Synatx checker Turn on/off Find error More then one syntax Function keys and shorcuts InBrackets notification Fast help - F1 More then one MDX syntax Break lines Single execution Multiple execution MDX Intellisense MDX functions MDX element functions Cube elements Dimension Hierarchy Level Member Measures Create Local calculated elements Create Member - Ctrl W Create set - Ctrl S Create named set - Ctrl N Create inner query - Ctrl I Create member Create set Create Named set Editing MDX command Edit with - option Edit two MDX - split windows Drag and drop objects Run MDX command Cancel MDX command Redo, Undo Save editor Properties Find MDX structure Folding Create Inner Query Add MDX syntax WITH MEMBER WITH SET MDX Functions MDX Format Solution Create solution Save solution Delete solution Add new designer Add new query Add existing Manager 4 object Copy and paste objects between solutions Designer Understanding OLAP cubes Icons on AS 2000 and AS 2005 OLAP cubes Dimensions Standard dimensions Time dimensions Measures Dimensions with multiple hierarchies Named sets Member properties Understanding the multidimensional data Working with designer object Create designer Save designer Copy-paste deisgner Redo, Undo, First, Last Cancel execution Delete designer Rename designer Making a copy Create query object - New window Create dashboard from designer Graphs Add new designer Running designer Add designer to dynamic documents generator Add designer to static reports generator Designer and cube elements Designer run modes Redo, Undo, First, Last Cancel execution Selecting individual elements Moving along same axis Moving among different axes Swap axes Member filtering Multiple filters from same dimension Find dimension/hierarchy/level Find default members different from all members Find member(s) Find member - load from MS Excel Find member - multiple criteria Find member - ignore case sensitive Find member(s) through entire hierarchy Member properties Cell properties External (set or axis) functions Dimension functions Inner (element) functions Time functions Member functions Inner query Create inner query group Create inner query Edit inner query Delete inner query Use inner query Using more then one inner query Member properties Filtering - load from MS Excel file Member properties filtering Member properties as a measure Member properties as measure - easy way Member properties at the table Measure groups Create Copy and paste measure Delete measure group Delete measure Calculated measures Create measure Delete calculated measure Edit calculated measure Export calculated measure Import calculated measure Local calculated objects Add local calculated objects from master catalog Export to master catalog Import from master catalog Calculated members Create calculated member - easy way Create calculated member Create calculated member from set Create Aggregated member Delete calculated member Edit calculated member Export calculated members Import calculated members Calculated sets Create Set - Easy way Create calculated set Create set from table axis dimensopn Delete calculated set Edit calculated set Export calculated set Import calculated members Calculated named sets Create Named set - Easy way Create a named set group Create calculated named set Delete calculated named set Edit calculated named set Export calculated named set Import calculated named set Local calculated tuple Create tuple Create tuple of three or more dimensions Create tuple set on the fly Create calculated member on the fly Create aggregate for any member or set on the fly Create set on the fly Copy object MDX Functions in designer Function restrictions Axis (Set) functions Apply axis function Edit axis function Delete axis function Dimension functions Apply dimension function Edit dimension function Delete dimension function Element (Inner) functions Apply inner function Edit inner function Delete inner function Best N - TopCount Best in N% - TopPercent Best in sum N - TopSum Remove Isolate Filter Order Order by hierarchy - Hierarchize Order by alphabet First N - Head Last N - Tail Show Visual Total - VisualTotals For each - Generate function Parallel Time Members Drill Down Level Date Elements Create Date Element Unique names Composite names Qualified names Time Functions From:To element (range) Create From:To element Create ParallelPeriod from From:To element PeriodsToDate element Create PeriodsToDate element Create ParallePeriod from PeriodsToDate element LastPeriods element Create LastPeriods element Member Functions NextMember PrevMember CHILDREN Descendants FirstChild LastChild Generate function KPIs Brows KPIS Use KPIs as a measure Local cubes Queries Create query Save query Redo, Undo, First, Last Cancel execution Delete query Delete all queries from folder Delete all not opened queries from folder Rename query Making a copy Create new query object - New window Graphs Add new query Adding parameters to the query Running with parameters Running query Edit MDX inside query Add query to dynamic documents generator Add query to static reports generator Dashboard Create dashboard Save dashboard Redo, Undo, First, Last Cancel execution Delete dashboard Rename dashboard Rename dashboard panel Add-remove groups or panels Graphs Running dashboard Add dashboard to static reports generator Add dashboard panel to dynamic documents generator Add dashboard panel to static reports generator Dashboard panel copy & paste Member copy & paste Union - Join panels (dashboard only) Union on rows Union on columns Union on both (rows and columns) What is common between two panels? (dashboard only) Common on rows What is different between two panels? (dashboard only) Difference on rows Linked parameters Defining linked parameters Using linked parameters DA mode Dynamic documents Save as Dynamic document Collect objects for dynamic document Save content of dynamic document generator Delete dynamic document Rename dynamic document Running dynamic document Static reports Save as static report Collect objects for static report Save content of static report generator Delete Rename Running static report Table data operations Drills Drilldown modes Double-click - Drilldown on member Drilldown on set Drill down on set - select level Drilldown on level Drilldown on level extended Drilldown on member Drilldown on member - select level Drilldown on member extended Drilldown on cell Drill-up modes Drill-up on set Drill-up on member Drill-up on cell Multiple drills Multiple drilldown on set Multiple drilldown on level Multiple drilldown on member Multiple drillup on set Multiple drillup on member Drill-Through Reorder columns Columns filtering Table view Export to MS Excel Hot-Spot analyis Hot-Spot analyis Frozen columns Sort Save Control key and operations Dimension operations Add dimension Add dimension level Remove dimension and push to filter Push to filter Remove dimension Move dimension to oposite axis Move dimension Up, Down, Left, Right Member operations Add-remove member(s) Remove one member Replace member dimension and push it to filter Push member to filter Organize members within axes Isolate member - simple and partial view Isolate member or parent - full view Table operations with measures Add-remove measure(s) Remove one measure Local calculated measure(s) Create calculated measure - Simple calculations Create measure - Custom Predefined MDX calculated measures Ratio to parent Difference Simple difference Percentage difference Index difference Sum Average Percent in set Percent in series Rank Table operations with filter axis Add filter Remove filter Replace filter Push to filter axis Replace dimension and push member to filter axis Show-hide empty rows or columns More then or Less then function Best N or Worst N Best N% or Worst N% Dashboard panel and table operations Member copy & paste (Dashoard only) Union - Join panels (Dashboard only) Union on rows Union on columns Union on both (rows and columns) What is common between two panels? (Dashboard only) Common on rows What is different between two panels? (Dashboard only) Difference on rows Axis functions Apply function to the axis Sort Order Ascending order Descending order Hierarchy ascending order Hierarhy descending order Hierarchize Organize members within axes Create set from axis dimension Move dimension Up, Down, Left, Right Member properties Member properties inside tool-tip Control key and operations CubePlayer built in analysis ABC+ Analysis Create ABC+ Use ABC+ Add segments to ABC+ Save ABC+ Save ABC+ as dynamic document Save ABC+ as dashboard Eksport ABC+ to MS Excel How Many analysis ShowMe analysis Exceptions - Hot-Spot analysis Exceptions - High Exceptions - Middle Exceptions - Low Exceptions - All (export to Dashboard) Result form - Table and graph view Table display type Simple Partial Full Table views Normal Sums Sum - Right for rows Sum - Bottom for columns Sum - Both rows and colums Percents Percents in set Percents in series Minimum-Maximum Difference Average Ranks Dissipation Subtotals Graphs Graph view Display 2D graph 2D gallery 2D graph settings Select measure Zoom Rotate Reset 2D Graph Higlight graph element Remove graph element from pie chart Graph and drills Graph and table filters Graph and measure pairs Graph and trends MiniGraphs MiniGraph types Apply MiniGraph MiniGraph configuration MiniGraph predefined styles Save MiniGraph style Load MiniGraph style Printing Standard printing Printing dashboard, layout and document Print settings Data and graph export Time placeholders (DeltaMaster) MS Excel - Query MS Excel - Dashboard MS Excel - Dashboard panel HTML PDF Result table configuration Number format Row header width Row or column colors Matching unique name Matching criteria Matching criteria - Level Add, delete, reorder entry Analysis Operation permissions Frozen columns Rows and columns autosize level Formatting and styles Row or columns colors Matching unique name Matching criteria Matching criteriaq - Level Add, reorder, delete entry Tables, colors and styles Create new table style Save table style Apply table style Set as default table style Export table style Import table style Table names (length) Set names length Measure styles Define measure style Subtotals styles Define subtotals style Subtotals above or below Graph color schema Create new color schema Save new color schema Apply new colro schema Set as default color schema Delete color schema Export color schema Import color schema Control panel and button styles Set new Control panel style Reset Control panel style Set button style Copy and paste button style Notes - comments Add notes - comments OLAP parameters Add parameter to query Create Parameter Dialog Create parameter Hidden parameters section Auto section Search section Date part section Bracket count test Defining an OLAP parameter Adding level or member Adding numerical value Adding hidden parameter Adding Date part Adding member properties value Adding member property Adding measure Adding MDX function Edit parameter Rename parameter Delete parameter Save query with parameter Run query with parameters Dialog Select Parameter Select parameter at reuslt table Add query to the dashboard Change table or graph settings fot the query with parameters Parameter substitution modes User-defined substitution lists Dynamically generated substitution lists Dahboard - Linked parameters Defining linked parameters Using linked parameters Is there a limitation? Reporting Services Server Support Register Reporting Services Server Connect to Reporting Services Server View report Run report as CubePlayer object Save CubePlayer object to Reporting Services E-mail support Send mail Master catalog Create master catalog Run object Copy Paste Edit Export to master catalog Import from master catalog Drag-and-drop New folder Refresh Local Repository Create Local repository Add Local repository Set as default Create new folder Export to catalog Import Run object Copy Paste Edit Register object Delete object Exclude local repository from the list Refresh view Understanding OLAP cubes Icons on AS 2000 and AS 2005 OLAP cubes Dimensions Standard dimensions Time dimensions Measures Dimensions with multiple hierarchies Named sets Member properties Understanding the multidimensional data Appendices Copyright Informations EULA