Difference between revisions of "Creating Reports in Web Edition"
| Line 12: | Line 12: | ||
In this case the right hand side of the window shows a history of reports run. | In this case the right hand side of the window shows a history of reports run. | ||
To create a new report in Web edition, click on Adhoc Grid and you will see the following display: | To create a new report in Web edition, click on Adhoc Grid and you will see the following display: | ||
| − | + | ||
| + | |||
| + | [[Image:WebGrid2.png|300px|centre]] | ||
| + | |||
You will see a list of the servers, databases and cubes to which you have connected previously. | You will see a list of the servers, databases and cubes to which you have connected previously. | ||
To create a new connection, enter the name of the server in the lower half of the window and then click connect. | To create a new connection, enter the name of the server in the lower half of the window and then click connect. | ||
| Line 18: | Line 21: | ||
Select a cube – you will be presented with the following screen: | Select a cube – you will be presented with the following screen: | ||
| + | |||
| + | [[Image:WebGrid3.png|300px|centre]] | ||
Drag items from the Available Hierarchies list to the Headers, Columns and Rows. | Drag items from the Available Hierarchies list to the Headers, Columns and Rows. | ||
Next, double-click each member and in the right-hand area of the window (this is also referred to as the Member Selector area) you can drill-down to select the member to display. | Next, double-click each member and in the right-hand area of the window (this is also referred to as the Member Selector area) you can drill-down to select the member to display. | ||
In this example I have double-clicked on Measures which has expanded in the Member Selector area to allow me to select the measure, Reseller Sales Amount. I can double-click or drag across to the right-hand side to select. | In this example I have double-clicked on Measures which has expanded in the Member Selector area to allow me to select the measure, Reseller Sales Amount. I can double-click or drag across to the right-hand side to select. | ||
| + | |||
| + | [[Image:WebGrid4.png|300px|centre]] | ||
You can use SHIFT and click or CTRL and click as normal to select members when you are selecting more than one member. | You can use SHIFT and click or CTRL and click as normal to select members when you are selecting more than one member. | ||
Clicking OK will display the report as follows: | Clicking OK will display the report as follows: | ||
| + | |||
| + | |||
| + | [[Image:WebGrid5.png|300px|centre]] | ||
You can double-click on entries in the grid to drill-down. | You can double-click on entries in the grid to drill-down. | ||
Revision as of 09:52, 1 September 2011
Connecting to the XLCubed web server in a browser window shows a similar display as below:
| Icon | Description |
|---|---|
 |
Toggle Tree |
 |
Adhoc Grid |
In this case the right hand side of the window shows a history of reports run. To create a new report in Web edition, click on Adhoc Grid and you will see the following display:
You will see a list of the servers, databases and cubes to which you have connected previously. To create a new connection, enter the name of the server in the lower half of the window and then click connect. You will then be presented with a full list of databases on that server. Select a database and on the right-hand side you will see the cubes on that server and database to which you have access.
Select a cube – you will be presented with the following screen:
Drag items from the Available Hierarchies list to the Headers, Columns and Rows. Next, double-click each member and in the right-hand area of the window (this is also referred to as the Member Selector area) you can drill-down to select the member to display. In this example I have double-clicked on Measures which has expanded in the Member Selector area to allow me to select the measure, Reseller Sales Amount. I can double-click or drag across to the right-hand side to select.
You can use SHIFT and click or CTRL and click as normal to select members when you are selecting more than one member. Clicking OK will display the report as follows:
You can double-click on entries in the grid to drill-down.
