From my problem is about activate/deactivate hierarchy for query in SAP BI version 7.0 whether query running on portal or on Business Exploeror(excel).
First of all, this query is reported about cost center value and amount.
I set the user with authorized for responsibled cost center.
This user can access and run this query for responsibled cost center with hierarchy display active without error.
And i see that, this report is filter with the user authorization, that's correct.
But my problem is ...when this user deactivate the hierarchy in the query, the message " User is not authorized" will be showned. It's mean that the auto-filter doesn't work.
How can i set the authorization to user which can deactivate hierarchy and see data only responsible cost center?
Thanks for any help in advance.