Authorization error when viewing the contents of a cube.

[Former Member]

Hi all,

I created a cube,loaded data into it. When I want to view the contents I get this below error...

any clues on how to debug this.....

Your user master record is not sufficiently maintained for object Commodity and Company Code Auth object

Message no. BRAIN805

Diagnosis

When checking your authorizations for object 'Commodity and Company Code Auth object' (technical name: ZCOMSEC) it was established that you do not have authorization in your user master record for this object (return code 12).

Procedure

How you continue depends on the return code. See the online documentation for ABAP language element "AUTHORITY-CHECK". Please note:

With a return code of 12, the object 'Commodity and Company Code Auth object' has not been maintained in the user master, meaning there is no profile in the user master record in which this authorization object has been entered. This is, however, absolutely necessary, as all of the authorization objects created in the development class RSR are validated in the 'and' link. If the authorization is missing for only one object, the request is rejected as unauthorized.

Get the person responsible for your authorization to create you a profile containing authorization for object Commodity and Company Code Auth object.

thanks.

[Former Member]

Hi Kiranmai;

Seems like the Object to execute the viewing contents of the cube is not included in your user profile. you need to go to the T-code SU01 and add the missing object into your profile. Click on the maintain objects at the bottom of the screen this is where you can add this object. If you are not sure which object that you are having this authorization issue,,you can put the trace on it via t-code ST01:Do the following steps.

1. Go to tcode ST01.

2. put the trace on your user id. ( can ask this to your Basis guy if you don't know how to do it).

3. then execute the view content of the cube.

4. when you get autho. error, go to the ST01 again, and have the trace off, and view the trace. you will see the name of the Object that needs to be included in your userid via SU01, do not forget to activate and Generate the profile after the addition. The return code 12 is the return type of the object that you are having problems.

Hope this answers your question.

Regards:

Buddhi

[former_member188975]

Hi Kiranmai,

Is the security valid: If yes then you need to get your user maintained. If you are just testing the cube and data and want to remove the security see this:

Hope this helps...

[Former Member]

Well I think I should have the security, do you know how I can add it.