Change content and settings of an OLAP cube

Microsoft Query

Show All Show All

Change content and settings of an OLAP cube

You can change the organization of the fields in a cube and remove fields that you no longer want in the cube, but you cannot add more fields to an existing OLAP cube. To add more fields to a cube, you must create a new cube.

  1. On the Microsoft Query File menu, click Open.
  2. In the Files of type list, click OLAP Cubes.
  3. Locate and double-click the cube definition (.oqy) file for the cube you want to change.
  4. Follow the steps in the OLAP Cube Wizard to change the content and settings. For specific instructions, see Help in the OLAP Cube Wizard.
  5. When you finish the wizard, Query prompts you to save the .oqy file. To replace the existing .oqy file, click Save. To save a new .oqy file, type a new name and then click Save.

Notes

  • If you specified an offline cube (.cub) file in the OLAP Cube Wizard, the .cub file is created after you click Save. An existing .cub file that you are changing must be completely re-created and replaced. Depending on the amount of data for your cube, saving this file might be time consuming. You cannot do other work in Microsoft Query until the .cub file creation is complete.
  • You can base Microsoft Excel reports on a .cub file either by opening the .oqy file by using the Open command on the Excel File menu, or by setting up a data source for the .cub file and then specifying this data source when you run the Excel PivotTable and PivotChart Wizard.