SoftPro Tetral  What's new    Products  
Update history (version 2.5/2.6)

Version 25.26.2010.1205-7

 

Description of latest changes is in MS Word file.            

Download MS Word file "What is New" here

 

Version 25.26.2010.1005

 

Description of latest changes is in MS Word file.            

Download MS Word file "What is New" here

 

Version 25.26.2010.0515 up to 25.26.2010.0801

 

Description of latest changes is in MS Word file.            

Download MS Word file "What is New" here

BUG FIXMDX Designer - Add member properties to columns.
                  
Syntax for DIMENSION PROPERTIES was added to row axis.
                  instead of column axis. Bug fixed
 

Version 25.26.2010.0420

 

            Static Report - defining row and column colors, formating available
                                     - Range analysis available for Static Report
                                     - Distribution analysis available for Static Report
                                     - ABC+ table analysis available for Static Report


            One Click Sort on measures - Disabled
                                                               - Right click menu Sort added to measures

            DrillThrough      - Column filtering is available in column headers
                                         - Click on a right end of the cell
                                         - Export to Excel
                                         - Save MDX
                                         - Save as dynamic document and run from control panel
                                         - Press F3 and edit DrillThrough statement

            Result Table - Column filtering available on static report

      - Column filtering is available in column headers
      - Click on a right end of the cell
      - If cell is merged with another cell(s) then filter will be applied
        to first column in range from left

      - Partial and Simple view
         Filtering is available only for data columns only, and it is not 
         in row header columns (columns that conatins headers for 
         each row).

Documentation folder - allowed to place documentation folder anywhere

Connections explorer - move up and move down option added

MDX Editor
Crete           - Ctrl + S create set from selected mdx
                     - Ctrl + N create Named Set
                     - Ctrl + M create member or measure

Intellisense - for functions that require two sets if user selecs with mouset:
                         a) from bottom to the top, selection will be used
                              as SECOND SET
                         b) from top to the bottom, selection will be used
                              as FIRST SET



MDX Designer

Create local cube - enhanced procedure, error handling

Export to Master Catalog - enabled multiple member export for
                                                  local calculated members

        

     

BUG FIX - Notes can not be saved

      - repaired

BUG FIX - Parameter replacement dialog might cause exceptions

      - repaired         

Version 25.26.2010.0402

 

   Result Table - Column filtering available

      NOTE: To allow filters to work properly, go to

                    Tools | Configuration | Designer

                    Check box for: Do not use server formated value in normal view

      - Column filtering is available in column headers
      - Click on a right end of the cell
      - If cell is merged with another cell(s) then filter will be applied
        to first column in range from left

      - Partial and Simple view
         Filtering is available on for data columns only, and it is not 
         in row header columns (columns that conatins headers for 
         each row).
        

      - Full view
        Filtering is available for data columns and row header columns 

 

Version 25.2010.0115

 

           Result Table - Table Extended Settings

      - New optional criteria to colorize rows or columns.
      From now, user can define to colorize rows or columns according
      to levels. For selected level fore color and back color will be
      applied. For NON selected levels fore color and back color will
      remain unchanged.

 

BUG FIX - SSAS 2000 Designer Drill Down Level

      On SSAS 2000 in Designer when DrillDown was applied
      directly on table execution was performed in new window

BUG FIX - Full View Columns Header mouse double click

      -After mouse double click on columns header in full view
      there was no drill menu 

BUG FIX - CREATE LOCAL CUBE - EDIT MDX

      After editing MDX command for CREATE local cube
      designer MDX was changed

Version 25.2009.1220

 

Designer - Parallel Time Element MDX Function

       - Parallel Time Element available on Dimension Funcitons (blue icon)

 
                Let us suppose you place some time range 2009 M5 : 2009 M7
                and you ask for parallel periods (for last year),
                usualy server will return it in order like this:
 
               2008 M5, 2008 M6, 2008 M 7, 2009 M5, 2009 M6, 2009 M 7
 
                If instead standard Time Function Parallel Periods available on 
                mouse right click, you 
select blue Function icon and 
                from menu Parallel Time Members it will sort it like this
 
               2008 M5, 2009 M5, 2008 M6, 2009 M6, 2008 M 7,2009 M 7


      - Support for creating local cube

 

ABC+ Analysis

      - From now, all members selected to be involved in ABC+
      will have hierarchy names and member caption

      

Filters Tab

     - When user opens Filters tab will find new notation for server
     
filters, user filters and server filters with default member different

                    from All Member
 
               Press F10 to get filters

 

Result Table - Table Extended Settings

      - Column Color, so you can colorize columns

    - Permissions where you can say what operations 
      (drilldown, drillup, isolate, organize ...) 
will be allowed for user
 

BUG FIX - Apply table style

      It did not colorize extra rows and extra columns 
      (for views different then Normal View -Sums for example) 

 

BUG FIX - ABC+ Analysis

      Fixed measure format in export to MS Excel

Version 25.2009.1101

 

Designer

      - Supports Drill, Isolate, Remove ... functions as native designer funcitons
         producing objects

      - Support for VisualTotals

VisualTotals.JPG


      - Support for creating local cube

 

Proclarity files

      - Support to read and execute Proclarity briefing book

PCL.JPG

      - Support to execute one or more pages or entire briefing book

 

Control Panel

     - Support to add any file to the control panel including MS Word, MS Excel ...
        MS Word file will be opened with Word, MS Excel file with Excel ...

 

MDX Editor

      - To add function through MDX Intellisense user can select part of MDX and then
         press ENTER to get entire syntax. Syntax will be wrapped arrowned 
         selcted MDX portion.

               ENTER -    gives full syntax for function

CrossJoinEnter.JPG


                                 if selection (portion of MDX) made it will be insered

                                 as first parameter in funciton

 

CrossJoinSelectionEnter.JPG

 

               TAB      -   gives only keyword

 

CrossJoin.JPG

 

----------------------------------------------------------------------------------------------------

After you made selection, while writing MDX and selecting TopCount funciton
this is what you will get.

 

untitled.JPG

 

      - Batch Job separator added - from now MDX Editor can hold and execute more
         one MDX Query. 

               

               CPGO - batch job separator (included in MDX Intellisense)

                              user can run one, two or more MDX at once (depends on
                              selection made by mouse)

 

                              even part of MDX can be executed (like [Measures].[Mark Up] 
                              for example) There is no need to select SELECT or 
                              FROM keyword

 

     CPGO.JPG

Version 25.2009.0801

 

Added new Table View: Subtotals

      -  Use "Show As" button to activate from drop down menu

      User can drill, remove, isolate, add dimension on subtotals

      It will not be activated in new tab like previous subtotals

      NOTE: Old Subtotals are still available on button "Subtotals"

 

Added new Table Settings

     - Use button Table Extended Settings on Table tab

      Define: Row headers width

                    Row colors according to selected member from hierarchy

                    Number format on the table:

                                 regular or short (2,00K instead of 2000,00)

                                for normal view select Formated Value or Valu+Format

 

Editor

      select portion of MDX and execute it with F5 (tab below) or F6 new tab

 

Version 25.2009.0701

 

Added CubePlayer configuration option to Designer Configuration:

      -  Use measure MiniGraph defaults always

Any MiniGraph saved configuration can be set as default MG

view for any measure.

Added Save and Load predefined MiniGraph configuration.

 

Version 25.2009.0601 - 25.2009.0616

 

Improved, speed.

Improved MiniGraphs. Added new features to configuration.

 

FIX forMemory leak on Dashbaords while working with SSAS 8.0

 

Version 25.2009.0501, 25.2009.0505

Version Upgrade

 

This update is also version upgrade to CubePlayer 2.5.

To see some of the features user need 2.5 license file.

Without 2.5 license file, update works as regular CubePlayer 2.0 update.

 

Designer

Added support for NONEMPTY function.

Can be added as set (axis), dimension or inner function in combination

with tuples (members and/or levels and/or measure)

 

Find

Added support for Match Case

 

MiniGraphs

Enhanced configurator


 

Difference

Main difference between 2.0 and 2.5 are MiniGraphs.

 

Update history (version 2.0)

Version 2009.0112

Editor

Fast Preview Tab added

 

FastPreviewTab.JPG

 

Fast preview will be visible inside editor area at the bottom after pressing F5.

Former F5 is moved to F6 - run in new window.

Fast preview does not generate objects inside workspace like F6 does.

User may run any MDX command created inside editor with F5.

Each F5 runs in a new thread, therefore you may run any number of

MDX instantaneously.

Each pressing of F5 will generate new preview tab.

 

Fast Preview Tabs right click menues:

Close - close tab

Edit - brings MDX from tab to editor area

New Window - runs MDX from fast preview tab in new window generating

                           object inside workspace

Zoom - displays results from fast previe tab in new form

              that can be spred over entire screen

Export in MS Excel - exports content of Fast Previe Tab in MS Excel

                                     (formats are not exported)

Info - isplays info about result table inside Fast Preview Tab

 

Editor Function Keys

F3 - edit

Bracket Counter

F4 - Bracket counter

Cheks brackets inside selected tekst

F5 - run fast preview

Runs editor's MDX in fast preview tabs at the bottom of editor
(does not generate new tab and object in workspace)

F6 - run in new tab

Runs MDX in new tab generating object in workspace

F7 - runs selected portion of MDX (one axis only)

displays results inside tooltip - maximum first 20 memebers

F8 - runs selected portion of MDX (one axis only)

displays results inside tooltip - maximum last 20 memebers

F9 - split editorr area

splits editor area in two sync editors

F10 - folding

enable or disable folding

F11 - comments

adds or removes comments over selected portion of MDX

F12 - structurize

creates structurized view of MDX

Tabs

F2 - rename

On tabs MDX Deisgner, Query, Dashbaord, Static Report

F3 - edit

On tabs MDX Deisgner, Query, Dashbaord

F6 - run in new window

Runs current tab MDX in New Window

F7 - run in dashboard

Runs current tab (or current panel in dashboard) MDX in Dashboard

Delete

Close tab and delete object from workspace - on tabs  Query, Dashbaord, Static Report

 

Version 2008.1227

Tabs

F2 - rename

On tabs MDX Deisgner, Query, Dashbaord, Static Report

 

F3 - edit

On tabs MDX Deisgner, Query, Dashbaord

 

Delete

Close tab and delete object from workspace - on tabs  Query, Dashbaord, Static Report

FIX

Fixed printing. (Problem appears from version 2008.1125)

Version 2008.1215


 

 

Designer

From now, CPMembers, Local calculated Sets and Local calculated Members  can be placed in Filter area. 

Workspace and Registered objects explorers

F3               Edit object

Enter          Run object

Editor

New function keys defined:

 

F2     Insert Format

F9     Split/Unsplit Window

F10    Folding/Unfolding

F11    Comment selected line

F12    Structurize MDX command

 

Inhenced MDX intellisense (back key recognition)

Version 2008.1125
 

Designer

One of the most needed features for those that are not professionals in “MDX world”:

 

    How to create query that will refer to YESTERDAY (or LAST WEEK, LAST MONTH,

 THIS YEAR …) whenever I run my query?

 

CubePlayer will try to help any user, professionals or not, with or without programming skill to achieve such a aim without any problem within a second.

Therefore CubePlayer offers you to create on one or twp clicks:

 

·          Today

·          Yesterday

·          This Week

·          Last Week

·          This Month

·          Last Month

·          This Quarter

·          Last Quarter

·          This Year

·          Last Year

·          Date Calculate (calculate any date based on Year, Month, Day calculation

 

Any calculation is always done according to TODAY on your computer.

Take any member to row or column area, right click and select desired function

from Time functions.

Examples:
If you want to create Time Element (Date Part) LAST MONTH then take any member
from level where you have months.

If you want to create Time Element (Date Part) THIS QUARTER then take any member
from level where you have quarters.

Member you will bring inside row or column area will
serve only to 
represent level,
therefore It is not important exact date that member represents.

 

Main guidelines:

 

                           Any element that represents any Date Part (numbers or Date Part

                           written with characters such as Nov or November) replace

                           with appropriate international supstitutions:

 

                                           yy                            Years represented with two digits

                                           yyyy                         Years represented with four digits

                                           M                            Month

                                           MM                         Month with leading zero (… 07, 08, 09, 10 …)

                                           MMM                      Month abbreviation (… Oct, Nov …)

                                           MMMM                   Month full name (… October …)

                                           Q                            Quarter

                                           QQ                         Quarter with leading zero

                                           W                            Week

                                           WW                        Week with leading zero

                                           d                             day

                                           dd                           day with leading zero (… 08, 09, 10, 11 …)

                                           ddd                        day short name (… Fri, Thu …)

                                           dddd                      day full name (… Friday …)

 

Any other element that does not represents Date Part should be

placed inside DOUBLE QUOTES (for example FY for fiscalYear should be "FY")

 

Examples:

 

01/01/2008                          dd”/”MM”/”yyyy                                      1st of January 2008

01/01/2008 - Thu                dd”/”MM”/”yyyy” _ “ddd                       1st of January 2008

01/01/2008 - Thusday        dd”/”MM”/”yyyy” _ “dddd                     1st of January 2008

1/1/08                                     d”/”M”/”yy                                              1st of January 2008

Q1 FY 2008                           “Q”Q” FY “yyyy                      1st quarter of Fiscal Year 2008

Week 03 CY 2007                “Week “WW” CY “yyyy                         third week of year 2007

Red color - fix slements that does not represent Date Parts

 

Version 2008.1021

Designer

Contribution function (rows only, measures have to be in columns)
- Two dimensions in rows
  Contribution function will calculate contribution of membrs from second
  dimension within the group that belongs to the member fromfirst dimension.
  For each memebr from first dimension subtotal member will be created.

FIX

Query Result Table, Add/Remove Member(s)
- when trying to reconstruct tree view on low level, treshold level (100) for
  member search have been activated; treshold level seted up to 900 members 
  

 

Version 2008.1012

Master catalog

Suport for Master Catalog selection while exporting objects


Designer

Hierarchize function
-added POST option for unnatural hierarhy order - first children then parents

 

FIX

Designer Redo/Undo
- restored Redo/Undo functionality

 

Version 2008.1004

Mastre catalog

Suport for Remove Master Catalog

MC.JPG

Dialogs

"Accept" replaced with "OK"
Icons on buttons OK and Cancel replaced with small icon marks

R.JPG

 

FIX

Handled Exception during copy-paste operation of folders from
one Master Catalog to another master Catalog
- fixed

 

Version 2008.0917

Configuration

Added support to configure
- Default table display style 
          
- Simple
           - Partial
           - Full (full cube structure in result table)

- Default tabel view
          
- Sum
           - Percentage
           - ...
- Tooltip configuration
          
- ON or OFF

Mastre catalog

Suport for more then one Master Catalog
- this feature will be improved

Version 2008.0912

Query Reulst Form, Designer, Editor

New functions available
- Order by Alphabet
          
- selected dimension/hierarchy will be ordered by member.name
- Hierarchize
- Remove member(s) from same or different hierarchy

Query Reulst Form

Table view Sum
- instead of only Sum view now there are two more views:
                      - Sum Bottom - sums for columns only 
                                               (for rows is not displayed)
                      - Sum Right - sums for rows only 
                                               (for columns is not displayed)

Push to filter
- if more then one dimension/hierarchy present on Row or Column
  axis, Push to Filter will be availabel on right click over row or
  column headers

  It will remove selected dimension/hierarchy and place selected 
  member in to Filter axis

Reporting Server Explorer

Edit registered servers
- edit each registered server listed in RS explorer

Conenctions Explorer

Edit conenction
-
 edit each connection listed in connection explorer

Version 2008.0910

Query Reulst Form

New functionality - Push to filter
-
 if more then one dimension/hierarchy present on Row or Column
  axis, Push to Filter will be availabel on right click over row or
  column headers

  It will remove selected dimension/hierarchy and place selected 
  member in to Filter axis

FIX

Designer

- Move from Fiter to Rows or Columns fixed

Version 2008.0906

EDITOR

MDX Intellisense - Added support for "." while selecting Cube Elements
-
 while selecting dimensions/hierarchies/level after typing
  few letters if you press "." it will do same job as ENTER or TAB

Note: If you ress "." immediately after window appears without pressing any
          character
 it will switch to Element Functions (.Members, .Children)

MDX Intellisense - Added support for MEMBERS
-
 after selecting level and pressing "." (dot) element functions
  intellisense window will appear 
  Select 
select OPEN BRACKET to switch to
  MEMBERS intellisense window where you can press
  green button with white arrow to see members or select some
  criteria like:
                   - bigger then ...
                   - smaller then ...
                   - starts with ...
                   - ends with ...
                   - contains ...
                   - and more ...

PARAMETERS

- Added Automatic Bracket test for selected portion of MDX
- Added parameters selector for hidden parameters

DESIGNER

- Dimension functions, now allowed to have more then one function
  per dimenson

  add any number of dimension functions to selected dimension
- Added support for new Dimension functions
            - Hierarchize
            - Order by alphabet
            - Remove member or members

FIX

- MoveUp,MoveDown in desifner Row/Column axis fixed

Version 2008.0813

EDITOR

Full support for MDX intellisense 
-
 all cube dimensions, hierarchies, levels available inside intellisense
- for cube elements intellisense windows linked in natural order
  after selection of dimension inside dimension window and pressing
  "." (dot) hierarchies window will appear
- all cube measures available inside intellisense
- all set  functions (CrossJoin, Union, Extract, Stdev ...) available
- all functions (.Members, .PrevMember, .Firstchilde ...) available
- SELECT, ON AXIS, FROM, WHERE, WITH, WITH MEMBER ...
   available with aditional features
   example: 
                - FROM will insert cube name as well
                    FROM [Sales]

WHERE, WITH, WITH MEMBER, WITH SET ...
   available with aditional features
   example: 
                - WITH MEMBER will insert WITH & MEMBER snippet
                   WITH
                          MEMBER
                         «DIMENSION».«MEMBER_NAME»
                          AS
                          '
                                «Expression»
                          '


Intellisense is automatically started while you type whenever appropriate.

ESC - close intellisense window

"." (dot) activates MDX functions (.Member, .Item ...)

chars A-Z when appropriate activates MDX functions intellisense
                (CrossJoin, TopCount ...)

ENTER or TAB - selects element from listview window

Note - Intellisense will not be activated while carret is inside square brackets
           [
no intellisense zone]

F3 
-
 Bracket counter
  Select part of MDX, press F3 to count brackets [], {}, ()
  Counter will notify you about result

F4 
-
 Inserts function over sselected MDX part
  example:
                  - select part of MDX with mouse,
                  - press F4,
                  - on dialog select function, measure,  conditions,
                  - additional filters inside function, 
                  - select Accept

F5 
-
 Run query (does not run part of MDX) 


F7 
-
 Select part of the MDX or one or more members and 
  press F7 to see captions inside tooltip (click on tooltip to close it)
  note* - displays first 20 members


F8 
-
 like F7, displays last 20 members

"Ctrl" + "1" 
-
 force intellisense window for MDX (set) functions (crossjoin, union, ...) 

"Ctrl" + "2" 
-
 force intellisense window for MDX functions (.Members, .FirstChilde, ...)

"Ctrl" + "3" 
-
 force intellisense window for cube Dimensions

"Ctrl" + "4" 
-
 force intellisense window for cube Measures

Do not forget

Syntax checker (checks syntax while typing, even in case of showing errors,
                          allows to run MDX command)
Split window
(rught click and select from menu)
Comment/Uncomment (right click and select from menu)
Folding (groups WITH, SELECT, AXIS 0, AXIS 1, FROM, WHERE)
MDX Structure (right click and select from menu) - formats MDX like:

WITH
MEMBER
[Time].[hYear].[2002 M 6_2002 M 9]
AS
'
AGGREGATE
    (
        {
        [Time].[hYear].[Month].&[1556] : [Time].[hYear].[Month].&[1559]
        }
    )
'
SELECT
NON EMPTY

    {
    [Time].[hYear].[2002 M 6_2002 M 9]
    }
ON AXIS(0),
NON EMPTY
    {
    [Customer].[hCountry].[State Province].MEMBERS
    }
ON AXIS(1)
FROM
[Sales]


 Create Local Elements (members, inner queries, sets, named sets)
 - select MDX part with mouse, right click and select option from menu
 - those elements can used later inside CubePlayer designer or query tables
   or shared with other collegues

Tree View - with find, properties, insesrt with functions capabilities
... and much more

 

DESIGNER

- Operator NOT added for function FILTER 
   from now on, you can directly in designer select entire level and remove
   members that you do 
not see within a second
   just select
                 - Filter function,
                 - operator NOT 
                 - and one or more memebers from the same or 
                   different dimensions that will be excluded

CONTROL PANEL

- Allowed usage of other users ControlPanels in read only mode

- If Control Panel is not yours, it will be in Read Only mode.
  Read only mode can be recognized by RED ball on icon near Control Panel title. 
  GREEN ball means panel is in ReadWrite mode.

- Added support for COntrol Panels in Master Catalaog
  select Master Catalog from Tool -Configuration-Master Catalog location
  select Create button to update your Master Catalog
  now you can add Control Panels to Master Catalog

- Added support to add Reporting Services Reports RDL to Control Panel
  just drag-n-drop from RSS Explorer tree view

LOCALE ID

- LocaleID support F12
  Press F12 to configure LocaleID if you want to use translated cubes.
  At this moment LocaleID ahs to be entered in form of DECIMAL NUMBERS
  for exmple
                   US               1033
                   French         1036
 
 

CONNECTION EXPLORER

- Implemented Disconnect All (right click with mouse and select from menu)

 

Version 2008.0721

DESIGNER

Dimension function notification 
-
 each element(s) in R/C/F that belongs to same dimension are colorized in 
  same color

Dimension Functions  
-
 for dimension functions, near each element  there is new notification when 
  function is applied
Elements ordering 
-
 inside R/C/F drag-n-drop elements vertically to reorder them
Member Properties     
-
 in MP explorer MPs are grouped by dimension
Properties
-
 to see element properties in R/C/F double-click element
ToolTips Cube Explorer
-
 removed, right click and select Properties from menu to see properties
Edit MDX 
-
 MDX can be edited without running query
Multiple member
-
 allowed adding same member twice to the axis


R/C/F - Row/Column/Filter area

EDITOR

F7 
-
 Select part of the MDX or one or more members and 
  press F7 to see captions inside tooltip (click on tooltip to close it)
note* - displays first 20 members

       (this enhancement expects more improvements)

F8 
-
 like F7, displays last 20 members

Insert level with function
- when selecting from tree vies and adding some functions,
  instead of Copy/Paste after creating syntax will be inserted
  at the place where cursor was

SAVE AS 

Save AS 
-
 QAT and Application button, with one click save each query as
                  - Static Report (CubePlayer format)
                  - MS Excel format
                  - MS Reporting Server RDF format
                  - Multidimensional Expression MDX 
                     
(directly exports to MS Analysis MDX file format)

OLAP PARAMETERS

New Result table Parameters Notification 
- Inside Dashboard and Query form selected parameters
  will be displayed at the top of the form
  Pressing button with parameters name will display Select Parameters
  Dialog to replace parameter

New OLAP Select Parameters Dialog 
displays captions instead member or level unique names 
Enhanced Parameters Options 
- new options available:
                    - Single or Multiple replacement
                    - Display Name, overrides captions
                    - Hidden Parameters - helps replace 
                      captions inside calculated members
                      should be linked to existing parameter 
Execution inside same tab 
- new options available  ( .PX queries will not be generated)
Refresh icon 
- runs parameter dialog with current parameter  values inside same tab
Workspace MoveUp, MoveDown 
- right-click menu with options MoveUp and MoveDown
  helps arrange parameters order

RESULT TABLE

Support for cell borders style 
- also added support for printing cell borders
Redefined table formatting      
- on tree view when root node is selected, changes applied to all nodes
Adding Dimensions  
- when adding dimension to result table dialog will appear asking
  whether to add dimension before/after or above/bellow present dimension
- when more then one dimension is present and we add
  third dimension when selecting leftmost/topmost 
  dimension will be added before/above dimensions,
  selecting rightmost/bottom dimension will be added after/bellow dimensions

REPORTING SERVER SUPPORT

Enhanced export to RSS (formats, styles, etc.)

FIX

Fixed problem with get children on tree view
Fixed problem with displaying member properties on result table
Fixed problem with saving document generated directly from editor

 

Version 2008.0306

DRAG-AND-DROP 

D-n-D - Added support for D-n-D from Outlook express. 
    D-n-D from outside or inside CubePlayer at the ribbon to Run
    D-n-D from outside or inside CubePlayer to the Editor to Edited.

WORKSPACE

Recovery workspace - Enhenced.

F5 

F5 - Added support for F5 to run query.

PROJET HELP - F9 

Added support for local project help - Runs Local Project Help with F9.
CubePlayer will create new folder

       ... \My Documents\SoftPro.CubePlayer.Client\Documentation

There you should manually paste your local project help to help your users using particular features of your BI Projects. Any file format will be opened. If you have more help files, on F9 list will be dispalyed to the user for selection.

FIX

Editor DnD - removed two additional blanks during D-n-D. 

Version 2008.0227

ANY RESULT TABLE

Replace Dimension - Selected member will be moved to filter axis and new dimension will be added

Add Member Properties as measure - If exist for dimension at the table, can be added as measure after receiving cellset

Set Functions - To any Set Function dialog added support to load local calculated members inside function tuple

OBSOLETE OBJECTS

Layout and Documents - Obsolete objects. Any preserved Layout or Document in Dynamic Document or Workspace will be executed as Dashboard. Furthermore from now, dashboards can be added to Dynamic Document Generator and be packed together with queries inside Dynamic document.

WORKSPACE

Recovery workspace - In case of unexpected shutdown, during next startup CubePlayer will create Recovery Workspace containing Designers and Queries that were inside workspace before unexpected shutdown.

EDITOR

Add level or member - On right click, inside tree view, during attempt to add member or level user can select additional functions to be added like NextMember, PreviousMember, Children, Descendants, or set functions like TopCount, BottomCount, Filter etc

Find member - Find member dialog added to tree view selector inside Edito

WEB HELP 

Added support for web help

FIX

Adding Filter 2005 - Corrected 

Version 2008.0118

ANY RESULT TABLE

Replace Dimension - Selected member will be moved to filter axis and new dimension will be added

FIX

Load Designer with Filter Function - Fixed wrong interpretation of Filter function argument, while loading designer from file

version 2007.1227

DESIGNER, EDITOR, RESULT TABLE

Improved levels and memebers handling

PRINTING 

New printing controls

CubePlayer exe 

Smaller code (reduced for 25%)

version 2007.1030 and 2007.1031

DESIGNER, EDITOR, RESULT TABLE

Support for tuples - While adding MDX functions with one or two clicks, user can additionally define tuples instead of measure only
TopCount (Set, 100, (StoreSales, Food, Mexico)) 

PARAMETERS

 Find and select multiple members - added find and replace multiple members

version 2007.1024

ANY RESULT TABLE 

Double click on member - Instead of DrillDowm Member user will get menu with options:

DD Level(+) - DD Level and retain selected member at the table
DD Level(-) - DD Level and REMOVE selected member from the table

 ANY RESULT TABLE 

Three new analysis added (test phase), ABC+ on the table, Range Analysis, Distribution Analysis

version 2007.1003

ANY RESULT TABLE 

Double click on member - Instead of DrillDowm Member user will get menu with options:

DD Member(+) - DD Member and retain selected member at the table
DD Member(-) - DD Member and REMOVE selected member from the table

DD Set(+) - DD Set and retain selected member at the table
DD Set(-) - DD Set and REMOVE selected member from the table

Memebr properties - if members have defined member properties, it can be used without defined inside MDX

EDITOR

MDX folding - enabled folding in editor

version 2007.0926

DESIGNER

Inner Query - create and use inner queries in designer and share objects in editor or use inner query created in editor

EDITOR

Syntax checker - automatically checks MDX syntax
Inner Query      - create and use inner query, use inner query created in designer

version 2007.0906

DESIGNER

Redo-Undo feature- redo-undo feautre is implemented inside designer

EDITOR

Split window
splits window and displays same MDX
Comment-Uncomemnt
allows users to automaticaly comments and uncomments parts of MDX
MDX structure
makes hierarhical view of MDX command
Insert
Function - mark text and select MDX function to wrapp selected part of command
Format - automaticaly inserts MDX format string
WITH - member or set sintax
Create local calculated elements
select part of MDX and create local named set, set or member and
save it for future use in designer or editor 
Font settings
will be preserved
Blue line
marks represents row where cursor is
Element properties
inside cube explorer element (member, level, measure ...) properties available
MDX Functions
alphabetical order Save directly saves MDX as Dynamic Document

WORKSPACE

Delete all
deletes all queries inside one any query folder
Delete closed
deletes all closed queries from workspace inside selected query folder
Copy parameters
from query to query inside or panel to panel (dashboard)

GRAPH

Data labels
for any graph (will be saved with object)

QUERY TAB

Delete
available for queries on mouse right click, closes window and deletes object from workspace

FIND (designer and add dimension)

First X
added option to find first X member from selected level

ANALYSIS

ShowMe Analysis
show me customers that are buying product A and B together but not product C

HowMany Analysis
how many of my customers are buying more the 15 products from my basket (top 50 products) 

Both analysis are aplicable on any result set.

Copyright © 1993 - 2017 Business Intelligence Website. All Rights Reserved.  SoftPro Tetral