Skip to Content

  /wp-content/uploads/2012/03/banner_83291.png

Applies to:
SAP Business Intelligence 7.0. For more information, visit the Business Intelligence homepage.

Summary
This document describes how-to list all roles by queries in SAP BW easily.

Author(s):    Carlos Basto

Company:    Accenture

Created on:  22 November 2011

Author Bio

/wp-content/uploads/2012/03/image001_83278.jpgCarlos Basto is a Senior Programmer at Accenture. He has been involved in SAP BW Consulting and Support Projects.

Table of Contents

Table of Contents. 2

  1. 1.            List roles by Queries. 3
  2. 2.            Introducing to purpose of this document 3
  3. 3.            Using QuickViewer (SQVI) 3
  4. 4.            Using SE16. 8
  5. 5.            Related Content 10

 
 

1. List roles by Queries

Almost always the BW professionals have some difficult in listing roles by queries, considering that does not exist a specific table in Business Intelligence Platform. Thus, this document comes to make this task a little easier, illustrating two ways of getting this list.

2. Introducing to purpose of this document

Let’s see two ways of listing roles by query:

  • Using SQVI (QuickViewer)
  • SE16 (with Filters)

3. Using QuickViewer (SQVI)

Through this t-code is possible to list all roles by queries following the steps below.

  1. Access SQVI.

/wp-content/uploads/2012/03/image004_83292.png

Note: Sometimes, by being a BW professional and in the requirements for this module SQVI is not part of, is possible that there’s no access to SQVI T-code.

2. A list with all views created is shown.

/wp-content/uploads/2012/03/image006_83293.png

3. However, let’s create a view that will help us to automate this list when it’s necessary.

4. First, put a name in the QuickView field, and then click “create”.

/wp-content/uploads/2012/03/image009_83294.jpg

5. A new screen is opened up which lets you to put the “title” and your “Comments”.

/wp-content/uploads/2012/03/image011_83295.jpg
6. Now, you have to choose which type of data source will be used. In this case: “Table Join”.

/wp-content/uploads/2012/03/image013_83296.jpg
7. After, a new screen called “join definition” is shown.

Note: Sometimes this screen does not appear immediately, then you must choose BASIS mode,  go to the tab “DATA SOURCE” and click on “change join”.

/wp-content/uploads/2012/03/image015_83300.jpg

8. You need to choose all tables you want to use. By following our focus — list roles by queries, there are 3 tables that you must use to show correctly this information.

/wp-content/uploads/2012/03/image017_83301.jpg/wp-content/uploads/2012/03/image019_83302.jpg/wp-content/uploads/2012/03/image021_83303.jpg

9. The join must be exactly as image below.

/wp-content/uploads/2012/03/image023_83304.jpg

10.  Now, you can check you join definitions [CHECK] and [RETURN] to main SQVI screen.

11.  Once you selected all tables above is time to choose what fields will be used in the output of the view.

/wp-content/uploads/2012/03/image028_83305.png

12.  “List fields” sets the fields will appear in the view (as fields) and “Selection” sets what fields will be used as filters before executing the view.

/wp-content/uploads/2012/03/image030_83306.png/wp-content/uploads/2012/03/image033_83307.jpg

13.  After you [SAVE], press [EXECUTE].

/wp-content/uploads/2012/03/image039_83308.jpg/wp-content/uploads/2012/03/image040_83309.png

4.    Using SE16

1. This way is easier than first one.

2. You have just to access SE16 in put the table AGR_1251

/wp-content/uploads/2012/03/image043_83310.jpg

3. After, you’ll have to use some filters to get correctly all relations between roles and queries.

/wp-content/uploads/2012/03/image045_83311.jpg

Note: FIELD filter is used to indicate that the “LOW” (from range of records in this table) will bring the name of queries;
LOW filter is used to filters results by query technical name

/wp-content/uploads/2012/03/image046_83312.png

 
 

5. Related Content

Maintaining Roles and Authorizations in BI7.0 – RSECADMIN

SAP Business Information Warehouse

Tables to Find the BW Report and Query ID from Role Menu


Disclaimer and Liability Notice

This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.

SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document, and anyone using these methods does so at his/her own risk.

SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply