none
Filter All dimension members based on Factory while browsing RRS feed

  • Question

  • Hi All,

    A cube contains data for All factories.There are 12 dimensions each contain factory specfic members.

    Now the requirement is as below:

    • As a standard the cube should open for the users factory only.
    • When the user needs to see other factories data there should be an easy way to select the affiliate data from other affiliates. 

    What are the best way of doing so?

    Note:We have some constraint also:

    • Cannot split the Cubes for each factory.
    • There are 20 Factories and dimension security for hidding members are also not feasible.

    Please suggest some options that can be done to achieve the requiremnt.


    Thanks, Tanmoy Santra

    Friday, January 11, 2013 5:26 AM

Answers

All replies

  • Hi Tanmoy,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    If you have any feedback on our support, please click here.<o:p></o:p>

    Regards, 


    Elvis Long
    TechNet Community Support

    Tuesday, January 15, 2013 2:07 AM
    Moderator
  • Hello,

    In order to do this you should try the ALTER CUBE statement with UPDATE DIMENSION and DEFAULT_MEMBER options in combination with username function.

    ALTER CUBE Statement (MDX)
    http://msdn.microsoft.com/en-us/library/ms144822.aspx
         Updating the Default Dimension Member
         This clause updates the default member of a cube and is used in the MDX calculation script to define a default member. The default member can be specified for the database dimension, a cube dimension, or for a user's login. The default member can also be changed during a session.
         Arguments
              Dimension_Name
                   A valid string that provides the name of a dimension.
              MDX_Expression
                   A valid MDX expression that returns a single member.
         Remarks
              The specified MDX expression can be static or dynamic.
        
    UserName (MDX)
    http://msdn.microsoft.com/en-us/library/ms146016.aspx

     

    These links might also help:
         Dynamic default members
         http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/72b31b44-0fdf-4135-a4f1-ff5b14b4d732
         Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
         http://www.ssas-info.com/analysis-services-articles/51-security/385-using-username-to-control-data-access-and-default-member-in-ssas-2k5-carrie-williams

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Thanks,
    Orsi
    Microsoft Online Community Support

    Monday, January 21, 2013 2:41 PM
    Answerer