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
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
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
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"






