On Accessing Data From An OLAP Server Using MS Excel - Formatting a Report and Creating a Chart
(Page 6 of 6 )
The Pivot Table Menu bar has a number of options: formatting a report, making chart, making changes to the layout of the data, and so forth. These items can be accessed from the Pivot Table Menu Bar.
For example, if formatting a report is required, clicking on the Format Report menu bar item brings up this next screen, from which various styles of reports can be chosen.
Choosing the style, second column, second row, produces this report for the selected data shown in an earlier picture.
For this picture, all orders from customers beginning with letters "A" and "B" were chosen. The data now represents the changed conditions as shown in this picture.
The data can be turned into a "chart" as well, by clicking on the Pivot Table Menu bar item Chart Wizard. Voila! You have a preformatted bar chart.
If changes are made to the "Cube," it will be necessary to "process" the cube. One of the options is to "refresh" the data. This is carried out by right clicking MyFirstCube, then clicking on Process... from teh drop down menu. Depending on the amount of data to be processed, the time to complete the processing varies. Mercifully, for this example, it is rather short, as seen in the next picture.
Summary and Conclusions Data on an OLAP server can be accessed very easily from an Excel worksheet. The wizard driven report creation process is well automated. The report created has all the drilldown/drillup capabilities. Using the layout button in step three of the Pivot Table and Pivot Chart wizard, it should be possible to rapidly change the layout of the report, as it is supported by drag-and-drop features.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
