Skip to Content
avatar image
Former Member

Colon authorization to show sub-total values

Hello,

This question is around using the Colon(😊 authorization in BI.

Eg: if there are 4 values in the Company Code (1000,2000,3000,4000), and I want to restrict the user to see only 1000 and 3000, what should the configuration look like.

I tried giving EQ = 1000 and EQ = 3000. The report returned an error saying No Autorization, and it needs a ":" authorization.

I then included the ":" authorization, but that shows me the grand total of 1000 and 3000. As soon as I drag in the Company Code into the rows, it gives an authorization error. What configuration should I do to also show the subtotals of company codes 1000 and 3000, in the same report.

Thanks very much. Appreciate your help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 08, 2010 at 03:22 AM

    Hello,

    The colon(😊 value is used in BW to authorise display of aggregates. If you are using company code in the free characteristics and do not restrict on it to authorised values, you need to maintain : for it. Once you drill down on it (or equivalently put it in the rows) you need the actual values to be maintained in the authorisations as well.

    Have you investigated the use of authorisation variables? You can maintain the values 1000 and 3000 in the authorisation and restrict the characteristic with an authorisation variable. This will ensure that the query is run for only the authorised values. This will work irrespective of whether you use company code in the rows or free characteristics.

    Regards,

    Aninda

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Can you post what the error is? Also, look at the RSECADMIN trace to identify the issue and post the output. This may help to provide you a sure shot solution.

      Rgds,

      Raghu