1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?
2. During cube creation where do I specify the type of "cube" I want to create
TIA,
Barkingdog
The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.
HTH,
- Steve
|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.
No comments:
Post a Comment