1. How to create an OLAP Cube
o 1
Select the "Data" option at the top of the page followed by "PivotTable and PivotChart Report"
o 2
Select "External Data Source" before pressing next to continue.
o 3
Press "Get Data," which will open the "Choose Data Source" dialogue.
o 4
Select the program from the list in which your data is located. It could be Microsoft Excel, Microsoft Word, Microsoft Access or another program that you used to store the data.
o 5
Select the tables and fields that you are interested in before pressing "Next."
o 6
Once you have selected the information that you want to organize, press "File" and then select "Create OLAP Cube."
o 7
Select the fields that you want to make visible as summarized fields. Press "Next" when you're finished.
o 8
Create the dimensions of your cube file. In this step, you'll be able to create sub-fields for the data. Press "Next" once you finish this step.
o 9
To make the data work with Excel, select "Save a cube file containing all of the data for the cube." Press "Finish" to end the creation of your OLAP cube.
Read more: How to Create an OLAP Cube in Excel | eHow.com http://www.ehow.com/how_8618051_create-olap-cube-excel.html#ixzz1fGthdWq6
Confidentiality Notice This email is intended only for the individual/s to whom, it is addressed and may contain information that is confidential or privileged. If you are not the intended recipient/s, or the employee or person responsible for delivering it to the intended recipient/s you are hereby notified that any dissemination, distribution, copying or use is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone and return the original email to the sender.
