Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How Self Serve Reporting works in Microsoft BI Expand / Collapse
Author
Message
Posted Saturday, October 12, 2013 2:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 4:01 PM
Points: 1, Visits: 287

Data source is based on MS SQL databases.
- Data is accessible through a data warehouse. Selected databases/tables are shipped to the DW SQL servers.
- We need to provide user authentication:
User logs into www.abc.com system
abc company has a complex access control system based on a hierarchy established by the product type such as:

Law Firm->Corporations
Enterprise->business units

Each of the above entities have users of different levels. Access control has to be enforced in cases such as in the Lawfirm edition a user from corporation A cannot access data for corporation B.
1) User clicks on the reporting portal link
2) User is taken to the reporting portal associated with their corporation. In there the user can run, edit, and add reports.

Please suggest any ideas .

Thanks in advance
Post #1504231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse