OLAP client control lets you efficiently browse and analyze the multidimensional data from the OLAP data source. It lists all the cubes, dimensions, measures, named sets, and KPIs that are available in the OLAP data source, and lets you to slice and dice the cube. You can also create reports from the data source using OLAP client and store them for later use.
OLAP control enables you to retrieve multidimensional data either from SSAS or from any XML/A provider and present the OLAP information in meaningful ways. Following is the list of data sources our OLAP controls support:
OLAP client is great for building analysis and decision-making applications where end users can easily drag and drop dimensions and measures of their choice to visualize performance, trends, outliers, and more. On dragging and dropping the element into the axis element builder, the element will be added to the corresponding axis of the current report. The element can be dragged and dropped from:
OLAP grid is used to display the results of the slice-and-dice operation, which is a set of multidimensional OLAP values, in a concise, precise, and compact area. Rendering of data in the tabular format can be easily understood by users of any level. OLAP grid also has drill down/up capabilities. Built-in support for grid layout and tooltip enhances user experience. You can also export the grid content.
OLAP chart provides another view of the slice-and-dice results in a user-friendly chart UI. You can also select from a set of 17 different chart types. Interactive capabilities allow end users to expand/collapse the different levels in a hierarchical dimension. Built-in support like palette and tooltip enhance user experience.
KPI are a collection of calculations associated with a measure group that evaluates business success. Typically, these calculations are a combination of multidimensional expressions (MDX) or calculated members. There are four different types of available indicators:
OLAP client control displays user-defined dimensions and measures through an UI specially created to define and add dimensions and measures. The calculated members are classified into two types: Calculated Measure–a user-defined measure element created from an existing measure element; Calculated Dimension–a user-defined dimension element created from an existing dimension. New calculated members can also be created from existing calculated members, and they can be added to a report through the UI.
A named set is a multidimensional expressions (MDX) expression that returns a set of dimension members that can be defined and saved as a part of the cube definition. Named sets are created by combining cube data, arithmetic operators, numbers, and functions. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.
Virtual KPI is now built into the OLAP client control to help visualize growth and trends over time. Standard directional arrows, as well as red and green indicators and stop lights, can be used to visualize a variety of data types. Users can also create their own KPIs at runtime and write expression as well. In an expression, positive numbers will be represented by a green light or up arrow, and negative numbers will be represented by a red light or down arrow depending on the user’s preference.
Filtering by members in OLAP client provides you the option to check or uncheck the nodes to filter the members besides each dimension. Based on the member selection, filtered MDX query will be generated and executed.
OLAP reports can be created and updated on the fly by dragging and dropping measures, dimensions, hierarchies, levels, etc., from cube dimension browser to axis element builder. We can also change the axis of measures, dimensions, hierarchies, levels, etc., by dragging and dropping the split button between different axes in the axis element builder.
OLAP client allows users to perform various functions such as adding new reports, removing existing reports, exporting, renaming reports, toggle pivot, show\hide expanders, paging options, show MDX, and connecting to new data sources using the OLAP client toolbar. End users can also change the chart types and legend types using the icons in the chart toolbar and change the grid layout, enabling the header cell tooltip and hyperlink cells through the icons present in the grid toolbar.
OLAP client data can be viewed page-by-page through the pager option. The page sizes for categorical and series axes are set in the OLAP report, through which large amounts of data are broken and navigated quickly and easily. Users can navigate the page with the help of the navigation bar available within the OLAP pager.
Localization is the process of customizing the user interface (UI) as locale-specific in order to display regional data. Using this feature, data can be displayed in a specific language and culture, of a particular country or region. Visualization of the control right-to-left is also applicable.
OLAP client supports different types of predefined themes, allowing users to switch among them to view the controls in different looks. Supported themes are Office2007Blue, Office2007Black, Office2007Silver, blend, metro, Office2010Blue, Office2010Black, and Office2010Silver.