Home Dashboard Directory Help
Search

SSAS\MOLAP Does not allow change in AttributeHierarchyOptmizedState by Bob Duffy


Status: 

Active


3
0
Sign in
to vote
Type: Bug
ID: 872497
Opened: 5/13/2014 3:24:19 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

If turn off bitmap indexes on a shared dimension in SSAS/MOLAP by setting the AttributeHierarchyOptmizedState to false it will also update within the copy of the dimension within the cube. However if we then set the AttributeHierarchyOptmizedState back to true in the shared dimension it does NOT update in the cube, resulting in an inability to turn bitmap indexes back on for a customer.

Details
Sign in to post a comment.
Posted by Microsoft on 5/15/2014 at 11:31 AM
Hi Bob,

Thanks for reporting this issue. It is intentional that disabling indexes on the dimension will disable it in all cubes. The behavior should be as follows:
- If dimension has AHOS=Disabled, all cubes must have it disabled
- If dimension has AHOS=Enabled, each cube can customize the state for the attribute and choose whether to enable or disable the indexes by setting it on the CubeAttribute object

This behavior allows an administrator to globally disable indexes for an attribute across all cubes. But it also allows each cube extra control so that individual choices can be made on a per-cube basis.

Thanks,
The Analysis Services Team
Sign in to post a workaround.