User Access Control + Dimensional Model

LR at 14h54
16
Sep
2010
User Access Control + Dimensional Model

Hi All,

How can I implement an user access control along with a dimensional model?
Let me take the classic sales star schema: fact_sales, dim_date, dim_store and dim_product.
Also I have 100 end-users of my web application.
Each user is allowed to access a sub-set of products. For example, User 1 must access only Product A and Product B.
The problem is that my access control list may change in the secur
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my
I am building a data warehouse on the Microsoft BI Platform. The architecture will include a dimensional model database residing on SQL Server 2008 that is updated nightly from a daily snapshot of a production database. The architecture will also includ
Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here
Hello, folks. I'd like to ask some newbie questions. I'm starting a multidimensional model for facilities management from scratch, and I'll certainly need a SPACE dimension, since it's the grain in which all the spatial information is stored in the
Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"User Access Control + Dimensional Model"

This topic has been viewed 1207 times.

Last message :
16/09/2010 at 14h54 by "LR"