Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 01, 2011 at 10:10 AM

    Hi,

    You should check that the variable $YCCM_WBS_ELEMTS is getting populated as the 0WBS_ELEMT Node S0001 is being failed on.

    Add comment
    10|10000 characters needed characters exceeded