ComponentOne Olap for WinForms
OLAP for WinForms Quick Start / An OLAP Application with No Code / Creating OLAP Views
In This Topic
    Creating OLAP Views
    In This Topic

    Run the application and you will see an interface similar to the one in Microsoft Excel. Drag the "Country" field to the "Row Fields" list and "ExtendedPrice" to the "Value Fields" list, and you will see a summary of prices charged by country as shown below:

    Click the "Olap Chart" tab and you will see the same data in chart format, showing that the main customers are the US, Germany, and Austria.

    Now drag the "Salesperson" field into the "Column Fields" list to see a new summary, this time of sales per country and per sales person. If you still have the chart tab selected, you should be looking at a chart similar to the previous one, except this time the bars are split to show how much was sold by each salesperson:

    Move the mouse over the chart and you will see tooltips that show the name of the salesperson and the amount sold when you hover over the chart elements.

    Now create a new view by swapping the "Salesperson" and "Country" fields by dragging them to the opposite lists. This will create a new chart that emphasizes salesperson instead of country:

    The chart shows that Margaret Peacock was the top salesperson in the period being analyzed, followed closely by Janet Leverling and Nancy Davolio.