Andreas Nobbmann

writing about Oracle Business Intelligence, Hyperion, IBM DB2, IBM Data Warehouse Edition and hopefully more

Reports uneditable because name of presentation catalog changed

I am sitting in the train on my way back home from Munich. Just completed the survey for Mark Rittman's BI Forum when my thought came back to that one topic I wanted to blog about. So, here we go !

Have you also faced this screen in the left pane of Oracle BI Answers ?

image 

A good description of what can be the reason, I do not know of any others. I would assume that in most of the cases the presentation catalog has simply been renamed. Sometimes there is a new version in the underlying business model of the presentation catalog, hence the guy modeling it decides wisely to rename also the presentation catalog.
The first option can of course also happen, but I want to dig into the second one.

I had this scenario at a customer and there it was not possible to rerename the presentation catalog back to the old name again. So, I thought about for a while and went the track right down the XML-path. And, yes, it was easier as expected.

For demonstrating that I changed the name of my catalog from "Sample Sales" to "Sample Sales 2".

image

Go to the advanced tab of the Answers report and take a look at the XML written there. You will find something like <saw:criteria subjectArea="&quot;Sample Sales&quot;">.(the &quot because of the spaces in the name). Replace the Samples Sales part with Sample Sales 2 and that's it, you see all your columns of the presetation catalog again.

image 

Save the report and you are done.

So long,
Andreas

Posted: Feb 25 2009, 04:48 von Andreas Nobbmann | mit 6 comment(s)
Abgelegt unter: , , , , , , ,

Kommentare

AnnaRR sagte:

Hi,

Thanks for your tip!

It works for the requests only and not for the filters. The filters do not get applied to the requests and hence I had to rename it back to the original name.

Do you have any work around for these filters?

Thanks

AnnaRR

# März 11, 2009 10:45

Andreas Nobbmann sagte:

Hi Anna,

glad it helped out for you.

Unfortunately for the filters there is no easy workaround like the one mentioned in the blog. The advanced tab simply is not present there.

The only thing you can do is to change the subject area directly in the XML as described for the requests.

For this open the catalog offline, search the filter under _filters and edit the filter in there.

Regards,

Andreas

# März 12, 2009 7:55

ADB sagte:

Hi Andreas,

is there a way to do this for all reports in a time and not report after report (it's possible in the catalog manager of 10.1.3.4.1 with the replace xml functionality, but I haven't found a solutions for earlier versions)

Txs for your help.

Kr,

A

# November 3, 2009 1:35

Andreas Nobbmann sagte:

Hi A,

if you do not have the replace XML functionality then there is not other functionality coming out of the box. But there are a couple of other possibilities.

You can write for example a little nifty Perl program, which searches through all the non attribute files in your presentation catalog or you can use XSLT to transform the XML. Another way is to simple use the search functionality of Windows and replace all the occurencies in the files.

For the XSLT transformations perhaps can find some helpful hints in the presentation I did in Brighton in May: www.trivadis.com/.../andreas_nobbmann_udml_xml.pdf

Hope this helps and so long,

Andreas

# November 4, 2009 8:46

ADB sagte:

Hi Andreas,

txs for your input...one remark when changing XML as described in your original post is that I'm loosing formatting on some columns (f.ex added currencies, changed header columns). Ever seen something like that too?

Regards,

A

# November 6, 2009 11:03

Andreas Nobbmann sagte:

Hi A,

no, I never faced the problem you mention when updating the XML. It could be because I copy all the XML out, edit it in my XML Editor, paste it completely back to the request and then click Set XML in the Advanced tab.

You have to pay attention with the Set SQL button, if you click this he crashes your XML, but the other way round it was running for me every time.

If you can provide me an example by mail we can sort this out together.

Hope this helps a little and so long,

Andreas

# November 6, 2009 11:32
Kommentar abgeben

(verpflichtend) 

(verpflichtend) 

(optional)

(verpflichtend)