on 03-28-2017 1:52 PM
Dear all ,
I have a problem regarding: "Can not edit the query of a webi report with BO XI 3.1"
Previous data:
Security is at folder and group level.
It seems like the connections to the universes are fine and the security of the universes is fine and the security of the Web Intelligence application is fine.
The problem comes when trying to "edit query" from an InfoView webi report or Rich Client. Showing "This query can not be edited"
Attached a screenshot
We have three users:
BITA_ADM
Administrator
Other unknown user
There are two universes A and B and two old reports that were made by a user other than BITA_ADM. They were loaded into the repository by that user other than BITA_ADM.
These two old reports:
Report 1 uses the A Universe
Report 2 uses the B Universe
If we login in InfoView with the user BITA_ADM (belongs to the group of ADMINISTRATORS BITA and others) we see only the BITA folder.
We execute the old report 1 that uses the universe A. When we try to edit the query it shows "This query can not be edited"
We execute the old report 2 that uses the universe B. We can edit the query
If we enter as administrator user we see all the folders in the repository including the BITA folder.
We execute the old report 1 that uses the universe A. We can edit the query
We execute the old report 2 that uses the universe B. We can edit the query
Now comes the good ...
As user BITA_ADM design two NEW reports -> NEW 1 and NEW 2
NEW report 1 uses A Universe
NEW report 2 uses B Universe
If we login in InfoView with the user BITA_ADM (belongs to the group of BITA ADMINISTRATORS and all) we see only the BITA folder.
We run the NEW report 1 that uses the universe A. We can edit the query
We run the NEW report 2 that uses the universe B. We can edit the query
Now my question:
When I try to edit with BITA _ADM the old report, which uses the universe A, created by another user other than BITA_ADM, I CAN NOT EDIT THE QUERY But when I try to edit with BITA_ADM a new report created by BITA_ADM which uses the same universe A, I CAN EDIT THE QUERY
What could be happening? Security is at the level of folders and groups
Thanks in advance !!!
Sincerely
Antonio
Dear All and Kumar
Thank you very much
But one question
Both reports OLD and NEW have the option
"Allow other users to edit queries" checked
Another thing
I do not understand very well the solution
Let me ask some questions
1. I log on in InfoView with an user , which? BITA_ADM
5. Login to InfoView with BITA_ADM ???
6. I cannot modify the report because it is an old report which does not belong to me.
I want to edit the query of the OLD reports using BITA_ADM ( Created by another user ) because I can edit querys of the New reports (Created by BITA_ADM)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My question:
When I try to edit with BITA _ADM the old report,
which uses the universe A, created by another user other than BITA_ADM, I
CAN NOT EDIT THE QUERY But when I try to edit with BITA_ADM a new
report created by BITA_ADM which uses the same universe A, I CAN EDIT
THE QUERY
What could be happening? Security is at the level of folders and groups
What can I do in order to edit the query of the old report using BITA_ADM ?
Thanks in advance
Kind Regards
Antonio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check attached sap note.
1851169 - Error:"This query cannot be edited" is seen when the owner of a report tries to edit query in Web Intelligence reports
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I cannot find 1851169 sap note
I do not understand your solution....
Please give more details.
My question:
When I try to edit with BITA _ADM the old report,
which uses the universe A, created by another user other than BITA_ADM, I
CAN NOT EDIT THE QUERY But when I try to edit with BITA_ADM a new
report created by BITA_ADM which uses the same universe A, I CAN EDIT
THE QUERY
What could be happening? Security is at the level of folders and groups
What can I do in order to edit the query of the old report using BITA_ADM ?
Thanks in advance
Kind Regards
Antonio
check this.
Thank you very much !!!
I will try but do you think Will it work ?
It seems magic !!!!
Thank you very much
But one question
Both reports OLD and NEW option
"Allow other users to edit queries" is checked
Another thing
I do not understand very well the solution
Let me ask some questions
1. I log on in InfoView with an user , which? BITA_ADM
5. Login to InfoView with BITA_ADM ???
6. I cannot modify the report because it is an old report which does not belong to me.
I want to edit the query of the OLD reports using BITA_ADM ( Created by another user ) because I can edit querys of the New reports (Created by BITA_ADM)
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.