Visual Studio for MDX
CubePlayer is a tool that will change your data into information and information into knowledge and will do so within any department in the organization. CubePlayer is a business intelligence application which can connect to multiple databases and file formats. No technical expertise is required, CubePlayer is user friendly with easy to use interface. It is an ultimate tool for strategic and tactical decision making at every stage of business process.
Monitor your efficiency, optimize performance, analyze your past and predict your future. Have your information ready and prepared in every moment at any place. Relay on your data, make your decision accurate.
From the technical perspective, CubePlayer is a .NET 2.0 OLAP client that works with Microsoft Analysis services 2000, Microsoft Analysis services 2005, Microsoft Analysis services 2008, Microsoft Analysis services 2008 R2 and Microsoft Analysis services 2012 databases and local files.
It runs on 32-bit and 64-bit Windows platforms. In small environments it can be installed on desktops. In large environment - on desktops or an application server and then used through remote connections since it supports multi-instance. CubePlayer supports multi-threading and stores all of its objects as XML files. It has document based user interface with docking windows (as in Visual Studio) and user configurable environment are additional pluses.
Designed for all categories of end users, it is primarily recognized as an invaluable asset by power users and analysts, since it allows them to save much of the their time needed to create the same analysis using other tools or no tool at all.
CubePlayer supports multiple connections to various SSAS databases and local cubes, one-click reports with or without linked parameters, various display modes, drag&drop interface, export to various formats (Excel and SSRS included), dashboards with innovative features like set operations (AND/OR/XOR) on its panels, built-in analyses, exception highlighting, advanced query designer (pivot), advanced MDX editor with Intellisense and MDX behind (view MDX for any object as it changes - live), drillthrough, actions and KPIs, user defined members/sets (built-in and various modes of creating new ones) and much, much more in its intuitive and flexible working environment.
Its true power is its MDX generation/handling engine that allows end users to create various pivots (ad-hoc reports) in its designer without having to learn MDX. So the limited select-all-or-some members from hierarchy, found typically in less powerful clients or add-ins is here extended to a larger set of common OLAP functionality that is otherwise required to be written by professionals in MDX language. Furthermore, users can even paste any MDX inside its Editor, run it and analyze the data without any limitations. CubePlayer makes no distinction whether query originated from its Designer, or it was an MDX aquired from another application (source).
And there's a real example of usefullness of such feature, even for beginners, who don't know anything about MDX. CubePlayer can aquire and run MDX from your SSRS reports (including parameters) inside its own environment (grid). That means user is no longer limited with context of predefined report. No, he can add any other dimension/hierarchy/attribute/measure to it, remove some of the existing and redefine it in a completely new report (without ever seeing its MDX!) since CubePlayer allow all that and more for any query. As said before, there's an option to export a query/grid to SSRS, which makes a nice loop back. Just imagine empowering (selected) users with such an analytical environment.
All tables, graphs and dashboards are live and support right-click funtions for drilling (down, up, through in many variants), isolation or removal of members, ordering members/hierachies on axis, generating sets from results, predefined measure templates, unions, differences, etc. Much of its functions allow tuple generation for slicing purposes (TopCount's third argument i.e.), a feature much needed in analysis of data. Search for members by name or property will be much useful when dealing with time dimension or large dimensions in general. Graphs and tables can have predefined or user defined styles (bar, line, stacked, font sizes, colors, etc.) that are also included while performing export into Microsoft Excel. Furthermore, each query or designer object can have rich text comment that helps in multiuser environment. In that environment, file based repository can be organized through CubePlayer, where end users share their member/set definitions, styles and reports. Many of its features are obtained on click or through the wizards.
Cubeplayer comes with rich local and online help and video tutorials that provide fast kick-start in multidimensional world.