SSAS ROLAP Aggregation Processing Issue.

As we planned to create an existing cube (which is with MOLAP storage mode), we have started converting the existing measure group & partition properties to ROLAP storage mode.

On an initial note, The Cube does have the MOLAP measure groups & aggregations. To convert the measure groups to ROLAP mode, have changed the measure group & partition storage mode to ROLAP.

After deploying & Processing the cube, have come across an issue with the processing by mentioning that Aggregation schema binding was not done.

By only deleting the aggregations, Could be able to process the respective measure groups.

Is there any chance to have the measure groups in ROLAP & the existing aggregations are also can be used?

SSAS ROLAP Aggregation

 

July 20th, 2015 2:50am

Hi Kumar,

According to your description, you want to use the measures with aggregations in ROLAP mode. Right?

Since the ROLAP mode makes the aggregations stored in indexed views(relational database), you can't keep it in your multidimensional structure. Otherwise it will throw error once you process the cube. So if you need to keep those measures, you have to choose MOLAP and HOLAP mode. This is the build-in features for these storage mode. I don't think there's any workaround for this requirement.

Reference:
Partition Storage Modes and Processing

Regards,

Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 1:49pm

Thanks Simon Hou for the update. 

How the aggregations are getting in Indexed Views?. How we can customize that?.

July 26th, 2015 5:33pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics