FlexPivot for WPF | ComponentOne
FlexPivot Cube / Using the Cube
In This Topic
    Using the Cube
    In This Topic

    In the previous step, you connected your WPF application with a cube. Now, its time to run the application and see how the data appears on the FlexPivot control.

    1. Press F5 to run the project.
    2. You notice that the control appears displaying some random data fetched from the database Adventure Works.
    3. Now, drag-and-drop Country and State-Province fields from the pivot panel to the Rows list, and Order Count and Internet Sales Amount to the Values list.
    4. The control now displays a grid summarizing Order Count and Internet Sales Amount by Country and State Province as follows.

    5. The cube data bound to the FlexPivot control in the above image consists of Dimensions, Measures, and Key Performance Indicators (KPIs). Dimensions are used to categorize the data cube, while Measures are the values for the dimensions. KPIs evaluate the measures in cube so as to present different perspectives of performance.
    6. The installed cube Adventure Works consists of Geography as one of the many dimensions, Internet Sales as one of the measures, and Customer Perspective and Financial Perspective as the KPIs.
    7. Users can use the cube data to build reports much like they would using regular datasets. The major difference between cube data and regular dataset is that data in cubes is represented in a tree-like structure in the C1FlexPivotPanel control.
    8. Each node in the tree-like structure represents a dimensional entity or an object for measure.
    9. Moreover, dimensions comprises Hierarchies, Levels, and Attributes
      • Hierarchies: Organizes levels in which the dimensions of a cube are structured.
      • Level: Describes position in a hierarchy.
      • Attribute: Gives additional information about the corresponding data.