Skip to Content
0

Can not edit the query of a webi report with BO XI 3.1

Mar 28, 2017 at 12:52 PM

90

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Mar 28, 2017 at 02:04 PM
0

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

Show 7 Share
10 |10000 characters needed characters left characters exceeded

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

0

sorry you need to check on support.sap.com. To access this you need S-User id.




0

Hello,

I have a S-User id but not with me. I am out of my office , please write me what is written in supporp.sap.com related this topic

0

check this.

  1. Symptom

    Error:"This query cannot be edited" is seen when the owner of a report tries to edit query in Web Intelligence (WebI) reports when "Allow other users to edit queries"option is unchecked.

    Environment

    SAP BusinessObjects Enterprise XI3.1

    Reproducing the Issue

    1. Login to InfoView.
    2. Open the WebI report in Modify mode.
    3. Click on Edit Query.
    4. Uncheck "Allow other users to edit queries" option.
    5. Click on Edit report.
    6. Save the report.
    7. Modify the WebI report again.
    8. Click on Edit Query.
    9. Even the owner of report is not able to edit the report and gets the error message: "This query cannot be edited".

    Cause

    The problem was observed with only few reports. The reports got corrupted due to some unidentified reason.

    Resolution

    1. Need to create the WebI report again.
    2. Click on Edit Query.
    3. Uncheck "Allow other users to edit queries" option.
    4. Run and save the report.
    5. Login to InfoView again.
    6. Modify the report with same user.
    7. Owner of the WebI report is able to edit query.
0

Thank you very much !!!

I will try but do you think Will it work ?

It seems magic !!!!

Resolution

  1. Need to create the WebI report again.
  2. Click on Edit Query.
  3. Uncheck "Allow other users to edit queries" option.
  4. Run and save the report.
  5. Login to InfoView again.
  6. Modify the report with same user.
  7. Owner of the WebI report is able to edit query.
1

it will work from my point of view as your query is similar to isse mentioned in the note.

0

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)

Resolution

  1. Need to create the WebI report again.
  2. Click on Edit Query.
  3. Uncheck "Allow other users to edit queries" option.
  4. Run and save the report.
  5. Login to InfoView again.
  6. Modify the report with same user.
  7. Owner of the WebI report is able to edit query.
0
Antonio Astudillo Mar 28, 2017 at 02:44 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Antonio Astudillo Mar 29, 2017 at 08:32 AM
0

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)

Resolution

  • Need to create the WebI report again.
  • Click on Edit Query.
  • Uncheck "Allow other users to edit queries" option.
  • Run and save the report.
  • Login to InfoView again.
  • Modify the report with same user.
  • Owner of the WebI report is able to edit query
    Show 1 Share
    10 |10000 characters needed characters left characters exceeded

    I would suggest to raise sap support ticket.Support team will investigate and confirm you.

    0