SSAS - Making cube data available after review by power user

View previous topic View next topic Go down

SSAS - Making cube data available after review by power user

Post  kajaldas007 on Tue Feb 21, 2012 2:00 pm

This one's a unique requirement:

After a cube is processed, normal users should not be able to view / browse the data. Only the power user should be able to view the latest incremental data. Only after the power user reviews the cube data and "release"s it, the normal users can view the latest data.

After I read about cube partitioning, I thought maybe it's doable. However, truly speaking, I am not sure if at all it is achievable. Maybe, the requirement can be met partially; in that case, we have to clearly set the expectation and the requirement should be modified accordingly.

I need some guidance in this regard - especially in the details of implementation steps - things like, how would the power user "release" the latest incremental cube data (or in other words, how should he trigger the availability of cube data after he is done with his review)?

Posts : 15
Join date : 2012-01-05

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum