Add drilldown to your query
Test your existing query
If you reopen your query and execute it again, you will still the products as rows because in the previous definition of the query we tol the system to display the level named "PRODUCT" on the y-axis. Though the level changed and went deeper in the hierarchy of the dimension, it has still the same name.
Now we will create another query, which displays the level "CATEGORY" on the y-axis instead of the level "PRODUCT". Again, drop the fact "Quantity" onto the axis.
If you execute this query you will see that the number of rows has decreased dramatically. This is because the new first level of our dimension has less elements than the product levels and our query display this new level of the dimension.
As you can also see, the cells are still filled with numbers. These are the aggregated by SQL-cube which generated a SELECT statement using the column "CATEGORY" out of the table "PRODUCT" as its GROUP BY expression.
Enabling drill-down
Now it's time so add some drill-down to the query. Switch back to the edit-view and click onto the y-header (saying "Product::'CATEGORY'"). Now open the context menu of the header using the right mouse button and open the sub-menu "Set drilldown...". Choose the option "Vertical" to enable the drilldown for this header.
> There are two different styles for drilldown in instantOLAP (vertical and encapsulated) which differ in the diplay of the newly opended headers. In the 'vertical' style, the become new rows in the table, in the 'encapsulated' style the become subheaders of their parent header.
Now execute the query again. You will see little triangles before each header. This is the drilldown button for a header - if you click onto it the header will expand and show its children-elements inside the pivot-table:
After you drilled down into a header, the symbol of this header changes to a differnt symbol (the drill-up symbol) which you can use then to close the header again.
