Confused about Aggregation authorization (Colon authorization)

[Former Member]

Hi All,

When I use the Aggregation authorization(in BW 7.4), I found that it show the data that I think should not be authorized. For example,

Company	Sales amount
A	100
B	200
C	300

User1 has authorization to see only company A and B. I think User1 will see only 300 when he open the report but it show 600. For my understand, Aggregation authorization will aggregate follow the user's authorization. Please correct me if I am wrong.

[Loed · Accepted solution]

Hi,

It is correct, you should see 600 since you will see the AGGREGATED VALUES of all company codes, regardless of your authorization in company..But if you drill it down to COMPANY, you should only see the COMPANY A and B..

You may check these links:

https://launchpad.support.sap.com/#/notes/1337102

https://launchpad.support.sap.com/#/notes/1140831

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/46/932b839c8019ade10000000a11466f/content.htm

https://wiki.scn.sap.com/wiki/display/BI/Colon+authorization+during+query+execution

Regards,

Loed

[Former Member · Accepted solution]

Dear Loed,

Thank you for your reply.

Regards,

Nuttapol

[Loed · Accepted solution]

Hi,

You are very welcome..Hope the links helped you..

You may already click the CORRECT ANSWER, if this is already solved, to close the thread..

Regards,

Loed