New answers tagged

3

Dimensions in Microsoft SQL Server Analysis Services support either ROLAP or MOLAP. Open the dimension in BIDS 2008, select the root dimension node and change this in the properties window. For fact data you open the cube and can similarly set the storage mode by selecting a measure group and altering the storage mode to one of HOLAP/ROLAP/MOLAP in ...


1

This is where OLAP puts everything by default, but during the install I believe you can choose where you want your olap database (Data Directories tab). Look for a .db folder for your olap database in the below location, as well as supporting files (like .xml) in the OLAP folder for your olap database. ...\Program Files\Microsoft SQL Server\MSAS12....


1

For databases of a significant size, the normalised logical design is typically created first. Following this, sample queries are run and the database is then denormalised for performance if need be (the physical design). If the gains are minimal, you may elect to stick with the logical design for the simple reason that it is easier to understand and is more ...



Top 50 recent answers are included