SSAS - Making cube data available after review by power user
Page 1 of 1
SSAS - Making cube data available after review by power user
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)?
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)?
kajaldas007- Posts : 15
Join date : 2012-01-05
Similar topics
» SSAS Cube - zero downtime even during cube processing
» How do I model this and create SSAS cube from it?
» Sales Target Implementation in SSAS Cube
» SSAS Cube structure of SCD Type 2 dimension
» SSAS 2008 - Hourly Sales Cube
» How do I model this and create SSAS cube from it?
» Sales Target Implementation in SSAS Cube
» SSAS Cube structure of SCD Type 2 dimension
» SSAS 2008 - Hourly Sales Cube
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum