Your Comments.

• # SSAS: New white paper on Many-to-Many relationships

  Thanks for your nice document on Many-to-Many relationships.
  
  I need some help in implementing one business requirement.
  
  Let us take an example to illustrate this. Let say we have four tables; Users, UserAccessBranch, Branch and FactLoan. User’s access to particular loan is based on his access to loan’s Branch (BranchID or OperatingBranchID). If user has access to at-least one of the two branches (BranchID and OperatingBranchID) then the loan is accessible to the user.
  
  Users.UserIDà BranchAccess(UserID,BranchID)ßBranch.BranchIDàFcatLoan.BranchID
  
  àFactLoan.OperationalBranchID
  
  
  In case of T-SQL it’s very easy to implement. In case of MDX it’s easy to implement if there is only one column of BranchID is there in FactLoan. I have implemented this case (having one BranchID) by having Many-to-Many relationship in the “Dimension Usage” of cube designer. How can we implement the logic for two Branch access (either Or) in MDX and cube design.
  
  Please let me know if you need any further information in this regard.
  
  Thanks a lot in advance.
  
  Regards,
  Rakesh
  
  

  Left by Rakesh Mishra at 11/16/2006 3:47 PM
• # re: SSAS: New white paper on Many-to-Many relationships

  This is the first time i have implemented the Many-to-Many Rleation ship. And i understood usage of Many-to-Many . Thanks and Keep doing good.
  
  Thanks
  Liyasker
  http://liyasker.blogspot.com
  
  

  Left by Liyasker Samraj at 11/17/2009 6:32 PM

Your Reply.

Comment Form.

Fields denoted with a "*" are required.

*Your name:

*Subject:

You may also like to leave your email or website.

Your blog:

Your email:  (will not be displayed)

*Your message:
 

Enter the code shown above

Preview Your Comment.