Hi All,
We are on BO 3.1 using Crystal Report 2008. I have a question regarding Crystal Reports using BO universes as data source.
We found that the reports using universe as data source stopped working for a group that don't have full control. The group could refresh the reports previously. They can also create reports against the universe. But after the report is saved, the group cannot open it. They can not refresh the same reports that they used to be able to. They are getting:
Failed to open the connection.
Details: Update of the SQL command from the Universe failed. This report cannot be refreshed unless the SQL command is updated from the Universe.
The other groups that have full control can refresh the same reports just fine.
We couldn't tell what event would have triggered it. We did export universes in the past week. None of our webi, deski, quaas or Xcelsius have this problem with the updated universes. Could you please let me know what would cause this error and how it can be fixed?
Thanks.
Fan
We are on BO 3.1 using Crystal Report 2008. I have a question regarding Crystal Reports using BO universes as data source.
We found that the reports using universe as data source stopped working for a group that don't have full control. The group could refresh the reports previously. They can also create reports against the universe. But after the report is saved, the group cannot open it. They can not refresh the same reports that they used to be able to. They are getting:
Failed to open the connection.
Details: Update of the SQL command from the Universe failed. This report cannot be refreshed unless the SQL command is updated from the Universe.
The other groups that have full control can refresh the same reports just fine.
We couldn't tell what event would have triggered it. We did export universes in the past week. None of our webi, deski, quaas or Xcelsius have this problem with the updated universes. Could you please let me know what would cause this error and how it can be fixed?
Thanks.
Fan