Querying the SQL Cubes


After creating and deploying the SQL Cube you can query the cube using the browse tab.

Note: For getting more information on how to create a SQL cube you can refer to my previous article entitled "Creating SQL Cube".

You can try deploying the cube to a localhost by the settings shown below. Right-click the project and select properties.

QuerySQLCubes.gif

Then right-click the project and click Deploy; you can see the deployment process in a window as shown below and successful deployment will give the success message below.

QuerySQLCubes1.gif

After successful deployment double-click the cube created to open that in the designer. And go to the browse tab as shown below:

QuerySQLCubes2.gif

You can now drag the measures and facts from the left side pane to right side pane (drop the column fields and row fields in the appropriate place) and observe the results.

You can do a lot of things using the cube; for example you can create KPI, Hierarchy etc. and use all that in the SQL report. We will see all these in future articles.

Up Next
    Ebook Download
    View all
    SQL Jobs
    Read by 0 people
    Download Now!
    Learn
    View all