Switching a Webi Universe from a report

[former_member297636]

Hi All,

I have a situation going on with our BO system. Recently, we lost a universe(reason undisclosed) with it's folder from the system and all reports connected to that Universe won't refresh due to no underlying universe. We were able to promote a copy of this universe from QA env. so the universe is back in place now but the reports won't automatically connect to this universe, each time I try to edit the report it comes up with a error "This query cannot be edited". I was wondering if there is a way to manually point the report to the new universe that was recently promoted to make up for the existing one. I tried opening the report in rich client as it would let you change the data provider but in this case that option is greyed out.

As a back up plan, I can create these reports again based on the recently promoted universe but now I have no visibility to the Query panel too, so figuring out the filters and conditions used in the report is also an issue.

To summarize what I'm looking at this point :

1) Is there a way to switch the universe of the report and point to the new one (it's an identical copy) when the option is greyed out?

2) is there any way I can find out what filters/conditions are used within a report when the query panel shows as blank with only an error message ?

Any insight on this will be very much appreciated, please feel free to share your thoughts on this.

Query Panel screen shot attached herewith

Thanks

GauravB

[vijaymuniraj]

Hi Gaurav,

Are u using rich client or lauchpad? If you wanted to edit the query or change the datasource, i think you need to open the report either on rich client or launchpad with modify mode. did you try it already?

[sateesh_kumar1]

Hi Gaurav ,

Check your client and Server are at same patch level !

If possible bring back all the content from PROD to DEV /TEST , check they are overwritten with existing content or not , incase of errors you can rollback the job .

Can't you promote reports assosiated with universe from QA ?

[former_member297636]

Thanks Mehboob!

We'll try to restore the objects from our back up. Thanks for sharing your ideas to overcome this situation. Really appreciate it.

Will keep you posted on my progress.

Thanks

GauravB

[former_member297636]

Yes Aright, I tried that already , the option is greyed out .

Thanks

GauravB

[mhmohammed]

Hi Gaurav,

Sorry about the situation you're in, I hope get out of it soon.

Few questions:

1. You said, you were able to promote a copy of the Universe from QA env, but is the Universe Folder structure identical to what you had in Prod env?
2. How did you get the universe from Dev to QA to Prod? Did you follow the best practice by creating the Universe in Dev, then migrate it QA, and then migrate it to Prod?
   • If yes, then the Universe should've had exact same CUID in all the 3 envs, and in that case, the link between the Universe and Reports shouldn't have broke.
   • If no, then the Universe should've had different CUID in different envs, and in that case, the link between the current Universe (in Prod) and reports will be broken if the (lost) Universe in Prod had different CUID that the one in QA env.
3. Can you confirm that the CUIDs of the Universe in Prod and QA are the same now, as you've promoted from QA?

Answers to your questions (check out the answer for 2nd question first):

1. May be, please check this out
   • Repointing webi reports to a different universe | SCN
2. You should be able to get the objects, filters and/or prompts in the different queries by creating 3 variables using just the functions QuerySummary(), PromptSummary() and Reportfiltersummary(), and it will give you all the details. You can also, do it without having to create the variables, if you got to Report Elelment -> Cell -> Pre-Defined -> and clicking on Query Summary, Prompt -> Summary and Report Filter Summary and clicking in the blank space in the report, as I did in the test report.

Hope that helps.

Thanks,
Mahboob Mohammed

[arijit_das]

Did you check the path Data Access > Tools > Change Source from rich client ?