Colon authorization to show sub-total values

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks for the reply. I have an Authorization variable on the Company Code info-object in the query. I also have an Authorization Object that restricts company codes to 1000 and 3000. But when I drag the Co. Code into the rows, to see the subtotals of 1000 and 3000, it gives an Authorization Error.

Thanks.

[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