VS2010/VS2008 BIDS AddIn is CubePlayer MDX Engine specially created to be used inside BIDS. This is engine is based on:
CubePlayer Real Multi Threading engine
Video
Supports servers:
· MS SSAS 8.0,
· MS SSAS 9.0 and
· MS SSAS 10.0 servers (incl. 2008R2)
· MS Share Point Power Pivot
· MS Local Cubes
It works with x86 as well as with x64.
It supports objects from CubePlayer:
· 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))
Supports Member properties and CELL PROPERTIES
Supports OLAP parameters.
Supports Export to MS Excel and PDF
Supports Redo Undo operations
Supports Proclarity briefing books.
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