BI Authorization Issue
Hi All,
I have issue with authorization plase helpme.
Authorization Check Log
For a general description, see the Note 1234567
Date and Execution Time (Local Server)
Execution Date: 01.12.2011
Execution Time: 13:11:06
Executed Query: ZPS_PVR01/ZPS_PVR01_VOCCR_1_1
Transaction RSRT ( BW - Output Test )
Executed by User ALIO
Executed with Analysis Authorizations of Another User TEST
Software Component Release Level Support Package
SAP_ABA 701 0005 SAPKA70105
SAP_BASIS 701 0005 SAPKB70105
SAP_BW 701 0005 SAPKW70105
-
InfoProvider Check
Building the Buffer...
...Buffer Built
Are there authorizations for accessing InfoProvider ZPS_PVR01 with activity 03?
Authorization exists for general access to InfoProvider ZPS_PVR01 with activity 03
-
-
Relevant Characteristics for Detailed Authorization Check
(Characteristics with Full Authorization Are Not Listed!)
List of Effective Authorization-Relevant Characteristics for InfoProvider ZPS_PVR01:
0PROJECT
0WBS_ELEMT
0TCAACTVT
-
-
Authorization Check
Detail Check for InfoProvider ZPS_PVR01
Preprocessing:
Selection Checked for Consistency, Preprocessed and Supplemented As Needed
Subselection (Technical SUBNR) 1
Check Node Definitions and Value Authorizations...
Node- and Value Authorizations Are OK
End of Preprocessing
-
Filling the Buffer...
...Buffer Filled
Main Check:
-
Subselection (Technical SUBNR) 1
Supplementation of Selection for Aggregated Characteristics
No Check for Aggregation Authorization Required
Following Set Is Checked Comparison with Following Authorized Set Result Remaining Set
Characteristic Content in SQL Format
0WBS_ELEMT Node S0001
0PROJECT
0TCAACTVT
0TCAACTVT = '03'
AND 0PROJECT LIKE *
Characteristic Content in SQL Format
0PROJECT I EQ $YCCM_PROJECTS
0TCAACTVT I EQ 03
0WBS_ELEMT I EQ $YCCM_WBS_ELEMTS
Not Authorized
Following Set Is Checked Comparison with Following Authorized Set Result Remaining Set
Characteristic Content in SQL Format
0WBS_ELEMT Node S0002
0PROJECT
0TCAACTVT
0TCAACTVT = '03'
AND 0PROJECT LIKE *
Characteristic Content in SQL Format
0PROJECT I EQ :
I EQ M0149
0TCAACTVT I EQ 3
0WBS_ELEMT Node A0001 ,
I EQ :
Not Authorized
All Authorizations Tested
Message EYE007: You do not have sufficient authorization
No Sufficient Authorization for This Subselection (SUBNR)
Following CHANMIDs Are Affected:
182 ( 0PROJECT )
183 ( 0WBS_ELEMT )
Authorization Check Complete
-
-
Objects Used
Hierarchy Node Definitions Used in the Selection
Nodes Char. Hierarchy Version Key Date Node InfoObject Node Name Node Level Depth (Levels)
Node S0001 0WBS_ELEMT WBSH 99991231 0WBS_ELEMT M0149C 3 0
Node S0002 0WBS_ELEMT WBSH 99991231 0WBS_ELEMT M0149C 3 0
Hierarchy Node Definitions:Used in the Authorization: Node Char. Hierarchy Version Key Date Node InfoObject Node Name Type Level Validity Range Structure Date
Node A0001 0WBS_ELEMT WBSH 99991231 See Variable $ZVAR_WBS_EXIT 4 08 0 00000000
Legend:
Type 0: Selected Nodes Only
Type 1: Subtree under Node
Type 2: Subtree under node up to and including level (absolute)
Type 3: Complete Hierarchy
Type 4: Subtree under node up to and including level (relative)
Validity Area 0: Name, Version Identical, Key Date Smaller or Equal
Validity Area 1: Name and Version Identical
Validity Area 2: Name Identical
Validity Area 3: All Hierarchies