locked
Peculiar requirement of dimension security RRS feed

  • Question

  • Hi All,

    We have dashboard which has source from MDX.


    Basically the output of MDX is to display the site links, and their details. metrics ,the fact table do not have the user information and the requirement is to show all the sites.

    The fact has details like BU,QID,IP (each QID will have multiple Ips) and no user information about the access to site

    (Sitelink is basically the hyperlink for site metrics)

    Requirement is to: Disable the site link to which the user doesn't belong. If we use dimension security and create Usersite junction table and join the sitelinkkey of the site dimension table and Userkey of Usersite table joining with User dimension table. and implement dynamic security will cause the Sites will get removed from the display based on the userlogged in and Usersite junction table

    so we are unable to achieve the requirement of displaying all the sites and only disable the hyperlinks which he doesnt have access

    Can any

     one have a solution advise on the same

    Thanks & Regards,

    Prasanna

    Monday, November 4, 2013 4:16 PM

Answers