Method 1Put the measures that should be secured into a separate cube, and implement the cube level write security under your role.
Note When you use this method, performance is as fast as when the query runs under an admin role. However, your cube design becomes complex, and you have to create virtual cubes to use linked measure groups in order to return the different measures in a single MDX query. Additionally, when you perform the writeback operation, you have to create an MDX query that uses the correct cube name based on the writeback measure.
Method 2Perform the writeback operation at the lowest granularity level of a particular member. You cannot allocate for many detailed granularity members.
Note To support the writeback operation, you may have to create dummy members in dimension tables that are marked as adjustment members in each dimension.
Note "Space" does not refer to the number of rows in the fact table. Rather, this refers to the full cross join space of all dimension granularity attributes. It takes a long time to enumerate those cells one-by-one in order to check the cell security.
Id. de artículo: 2792976 - Última revisión: 21 dic. 2012 - Revisión: 1