BI Hierarchy Authorization Error.

[Former Member]

Dear ALL,

For Query Q1 following are authorization relevant characteristics :

HREP_ENT - Reporting Entity - Hierarchy

HREP_UNIT - Reproting Unit - Characteristic

0TCAACTVT

Following Set Is Checked

Characteristic Content(in SQL Format)

HREP_ENT Node S0001

0TCAACTVT

HREP_UNIT

HREP_UNIT = 'ALL_BU'

AND 0TCAACTVT = '03'

Comparison with Following Authorized Set

0TCAACTVT I EQ 03

HREP_ENT Node A0001 (This node does not authorizes selected node)

Node A0002 (This node does not authorizes selected node)

Node A0003 (This node authorizes selected node)

HREP_UNIT I EQ :

*Result

Not Authorized.

Objects Used

Hierarchy Node Definitions Used in the Selection

Nodes Char. Hierarchy Key Date NodeInfoObject Node Name NodeLevel Depth (Levels)

Node S0001 HREP_ENT 0CS_GROUP_HIP_H02 99991231 G_ABC G_ABC 2 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 HREP_ENT 0CS_GROUP_HIP_H02P 99991231 0HIER_NODE G_ABC 0 00 0 00000000

Node A0002 HREP_ENT 0CS_GROUP_HIP_H02 99991231 05G_ABC 0 00 0 00000000

Node A0003 HREP_ENT 0CS_GROUP_HIP_H02 99991231 0HIER_NODE G_ABC 0 00 0 00000000

From The Log the difference I could make out is that the

The nodes of Hierarchy ( 0CS_GROUP_HIP_H02) are of Type 0HIER_NODE whereas in query selection the node of hierarchy are of type G_ABC .

Please let me know how can we debug authorization errors related to Hierarchies.

Edited by: Ajit Nadkarni on Mar 19, 2011 8:15 AM

[Former Member]

Hi,

If S0001 is a subtree node of A0003, then change the 'type of authorization' to 1 (subtree below node) for A0003 in your analysis authorization. Currently in your case, I guess its 0- selected node only (default type).

Thanks

Sandipan

[Former Member]

Sandipan,

Changing the authorization level for me to 1 from 2 or 0 seemed to fixed my 0PROFIT_CTR hierarchy error.

Many thanks,

Mosi