Catalog object schema validation failed

Catalog object schema validation failed

After Applying patch for OBI 11.1.1.6.0 to 11.1.1.6.7, Many reports in my dashboard didn't show up. I couldn't even view them. It was throwing  "Catalog object schema validation failed"

Seems it to be some bad xml issue.

Solution:

 Go to the corresponding folder

 D:\OBIHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root\shared\Dashboard1\_portal

2)  Edit the troublesome file in an editor. 

3) Check for the XML tag value

<saw:dataLabels abbreviation="default" display="default" label="default" valueAs="default" waterfallValueAs="diffprevbar">

Remove the waterfallValueAs attribute from the XML:

<saw:dataLabels abbreviation="default" display="default" label="default" valueAs="default">

You have to repeat this process for all the improper reports. 

OBIEE Patching

Patching OBIEE

Recently I patched OBI version 11.1.1.60 to 11.1.1.6.7. There are many blogs about patching. I liked the one from "peak Indicators" 

Check out the process to Patch in the link here : 

To Pass OBIEE Session Variable as a parameter to an Embedded content

To Pass OBIEE Session Variable as a parameter to an Embedded content

Embedded content is to display the java based or any other web page content in OBIEE. Sometimes its required to pass OBIEE variables info to the URL. 

This can be achieved by passing session variable @{USER} to the url :  

Example : http://in.search.yahoo.com/search?p=@{user}