SoftPro Tetral  Business Insights 2    Products  
Business Insights 2

Business Insights is extremely powerful windows winforms application that incorporate CubePlayer's powerful MDX engine and maps. 

Features

Supports servers: 

·            MS SSAS 8.0,

·            Pentaho Mondrian 

·            Oracle OLAP 11g R2 cubes via SIMBA provider

 

It supports objects created by CubePlayer, such as:

·            Dynamic Document with or without parameters

·            Dashboards with or without parameters

·            Static Reports

·            Usage of Master Catalog

·            Usage of Control Panels

 

MDX operations at the table:

 

·            DrillDown set (one level or jump to any level)

·            DrillDown member (one level or jump to any level)

·            DrillDown level (one level or jump to any level)

·            DrillUp

·            Remove

·            Isolate

·            Remove dimension/hierarchy

·            Add Dimension/hierarchy (level or member(s))

·            Push member to Filter

·            Remove Non Empty (add Non Empty)

 

Supports Member properties and CELL PROPERTIES

Supports usage and creation of parameters.

Supports Export to MS Excel and PDF

Supports Redo Undo operations

 

Table view supports:

 

·            Normal view

·            Sums for rows, or columns or rows and columns

·            Percentage in set

·            Percentage in series

·            Ranks

·            Difference

·            Min-Max view

·            Dissipation

·            Subtotals

 

Graph supports:

 

·            show graph for one measure

·            show graph for all measures

·            show graph for measure pair

·            show trends

·            show forecast

 



 

MDX Designer

 

Integrated MDX designer allows user to use most of MS SSAS features almost without need for knowledge how to write MDX commands.

 

When we say integrated support we mean literally that with few clicks and without any clue how to write MDX command you can use most sophisticated MDX functions.

 

Integrated  support for MDX functions where you can even define tuple inside for example TopCount function includes:

 

·            Best N - Equivalent to TopCount

·            Best in Sum - Equivalent to TopSum

·            Best in Percent - Equivalent to TopPercent

·            Worst N - Equivalent to BottomCount

·            Worst in Sum - Equivalent to BottomSun

·            Worst in Percent - Equivalent to BottomPercent

·            Order - Equivalent to Order

·            Order by Alphabet - Combination of Order function and order conditions

·            Order by Hierarchy - Equivalent to Hierachize

·            Filter - Equivalent to Filter

·            Remove member(s) - Combination of Filter (and NOT members …)

·            First N - Equivalent to Head

·            Last N - Equivalent to Tail

·            Without empties - Equivalent to NonEmpty

·            Show Visual Totals - Equivalent to VisualTotals

·            Parallel Time Members - Implementation of generate and ParallelPeriods

·            DrillDown Level - Implementations of Generate to select level

·            Contribution - Special syntax

·            For each from previous dimension - Equivalent to Generate

·            Without empties - Equivalent to NonEmpty

·            Aggregate

 

 

Time functions support:

 

·            Periods to date

·            Parallel periods

·            Last periods

 

Member functions support:

 

·            FirstChild

·            LastChild

·            Children

                ·            FirstSibling

·            LastSibling

·            Item(X) 

·            Lag(X)

·            Aggregate 

 

MDX Editor

 

 

Integrated MDX editor with intellisense and

 

·            Element designer

·            Bracket counter

·            Comment/Uncomment

·            Split windows vertically

·            Split windows horizontally

·            Fold/Unfold

·            Support for MS MSDN help (F1)

·            Support for more then one MDX command

·            Fast preview

·            Support for caption preview, or part of MDX preview

 

Dashboards

 

 

Integrated dashboards with ability to use parameters per panel or linked parameters per entire dashboard

 

·            table view

·            graph view

·            map view

 

Each pane support all previously defined table operations. Table operations change MDX command but preserves original MDX context

 

 

Dashboard

 

 

Integrated dashboard with ability to use parameters per panel or linked parameters per entire dashboard

 

·            table view

·            graph view

·            map view

 

Each panel support all previously defined table operations. Table operations change MDX command but preserves original MDX context.

Dashboard supports creating of parameters per each panel as well as linked parameters as main set of parameters for entire dashboard.

 

 

Query

 

 

Integrated query viewer with ability to use parameters

Supported views are:

 

·            table view

·            graph view

·            map view

 

Each query support all previously defined table operations. Table operations change MDX command but preserves original MDX context.

 

Query supports creating of parameters.

Package content

Package contains:

  • CubePlayer Corporate Edition one (1) company license
  • CubePlayer Enterprise Edition one (1) user license
Copyright © 1993 - 2017 Business Intelligence Website. All Rights Reserved.  SoftPro Tetral