Skip to Content
author's profile photo Former Member
Former Member

Hierarchy based authoration failed in Webi

I have created authorization based on master cost center hierarchy and tested within BW environment and everything is working fine.

There is two hierarchy ZDB_COSTCTR_LOB & ZDB_COSTCTR_GEO.

The authorization control is for ZDB_COSTCTR_LOB for a specific node only.

ZDB_COSTCTR_GEO only for specific users only.

Once this queries being used in WebI reports , the system throw the below error

LOBCY - Joiners & Leavers - LOB

A database error occured. The database error text is: The MDX query SELECT { [Measures].[4KSFAYYL395O4E0YP8T0SIB4N], [Measures].[4KSFAZ69M7RDN0KEV2VD2K9UF], [Measures].[4KSF0B3XAHT4LKA3AK9CVJ9AV], [Measures].[4KSF0BBLTGEU46TJGEBP5L80N], [Measures].[4KSF0BJACF0JMTCZM8E1FN6QF], [Measures].[4KSF0BQYVDM95FWFS2GDPP5G7], [Measures].[4KSF0BYNEC7YO2FVXWIPZR45Z] } ON COLUMNS , NON EMPTY CROSSJOIN( CROSSJOIN( CROSSJOIN( INTERSECT( { Descendants( [0MAST_CCTR ZDB_COSTCTR_LOB].[LEVEL00].MEMBERS, [0MAST_CCTR ZDB_COSTCTR_LOB].[LEVEL03], LEAVES) } , { Descendants( { [0MAST_CCTR ZDB_COSTCTR_LOB].[CPRTFNCTN 0HIER_NODE], [0MAST_CCTR ZDB_COSTCTR_LOB].[TWNSHIP 0HIER_NODE], [0MAST_CCTR ZDB_COSTCTR_LOB].[CONSULTANCY 0HIER_NODE] } , [0MAST_CCTR ZDB_COSTCTR_LOB].[LEVEL03], LEAVES) } ) , [0PAYSCALEAR].[LEVEL01].MEMBERS ), [0CALYEAR].[LEVEL01].MEMBERS ), [0CALMONTH].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS FROM [ZMPSSUR12/ZMPSSUR12_Q007] failed to execute with the error Value CPRTFNCTN 0HIER_NODE for characteristic 0MAST_CCTR unknown. (WIS 10901)

The error only get resolved if i give authorization to hierarchy itself rather then the individual nodes

Please help

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 23, 2011 at 09:10 AM

    when i execute the queries in BW it rreturn the result as per the authorization control that have been set

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.