Only 32 Attributes in Query Design

[Former Member]

Hello,

I have a strange problem in Bex with BW 3.5.

I have an InfoObject 0MAT_PLANT that has 46 attributes there are a mixture of nav and display ones.

I have written a query and included it in a workbook where 0MAT_PLANT and a number of its attributes are in the rows. The attributes are included with 0MAT_PLANT as display.

when I run the query/workbook, all is fine (I have sap all). When a user runs the query/workbook they get an error BRAIN691 Query was changed! Settings for attribute Vendor have not been transferred.

When the user changes the query they only have 32 attributes available under 0MAT_PLANT (I have 46).

On checking the 32 attributes were the first 32 defined for 0MAT_PLANT. I have tried changing the order of the attributes and also the f4 help order but this did not work. I can not find anything on OSS etc.

Any ideas?

Thanks

Peter

[former_member188975 · Accepted solution]

Hi Peter,

Are the missing attr auth relevant? Also if the users are allowed to create queries, can tey try by creating a new query and see what turns up for the MAT_PLANT attributes. Are the ones missing Nav or Display...were they newly added...any pattern here?

[former_member199956]

Dear Peter,

it seems that we have encountered the same or at least a very similar problem on our project. In our case the char. has far less than 32 attributes. If a user with SAP_ALL runs the query everything is fine. If a restricted user runs the query a BRAIN 691 message is generated and the attribute gets removed from the query result.

In our case we think that authorizations might be causing the issue: The attribute in question is also a characteristic in the cube which is authorization relevant. We believe that BW gets confused because the technical names are similar and this confusion causes BRAIN 691.

I would be interested to know if you have found a solution. If so it would be nice if you could share some information.

Thank you very much. Kind regards,

Hanno.

[Former Member]

Hello,

The missing are a combination of display and navigational. Yes the ones missing are the later ones, As stated in my post the first 32 displayed and these were the first 32 added to the attribute. If the user creates queries they still only see 32 attributes. have now tried SE14 on the tables for 0mat_plant and this hasn't worked either.

Regards

Peter