Showing results for 
Search instead for 
Did you mean: 

Error in Opening a query after Authorization.

Former Member
0 Kudos

Dear Experts,

in a requirement to restrict the users to access some specific queries only I have created the role and assigned some queries to those role in PFCG. The user is able to see only the authorized queries when he login to BEx Analyzer . Now the problem is that when he opens the query instes of getting the prompt for variable values entry he is getting some message as

" Error in specifying the value for variable for Fiscal year and plant."

however the query is opened success fully with my ID which has all authorization.

in Role maintenance I have provided following authorization to the user .

1. Business Explorer - Global variables

2. Authorization Check for RFC Access

3. Transaction Code Check at Transaction Start

4.BI Analysis Authorizations in Role

Business Explorer - Components

Business Explorer - Components: Enhancements to the Owner

Business Explorer - Enterprise Reports

Business Explorer - Folder View On/Off

Data Warehousing Workbench - Hierarchy

Data Warehousing Workbench - InfoCube

Data Warehousing Workbench - InfoObject

Data Warehousing Workbench - MultiProvider

Data Warehousing Workbench - DataStore Object

Authorization Object for RS Trace Tool

5. Business Explorer - Variants in Variable Screen

could please some one tell where i am missing , are what is wrong with it.

Thanks !

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I would start with the SAP delivered authorization template for reporting user and restrict to the specific query/.

Former Member
0 Kudos

Hi Anurag - Did you resolve this? I am having the same issue now. Can you please explain?

Former Member
0 Kudos

you may wish to try executing the queries using the RSECADMIN and analyzing the log for the same.

Hope it Helps



Answers (0)