OBIEE 12c - Reload Server Metadata required?

Mark.Thompson

In 11g, when I made changes to the repository in online mode, and those changes did not affect the presentation layer, a click on the Refresh Query icon on the Answers toolbar would rerun the query based on those online changes.  In 12c, I am seeing that I must select Reload Server Metadata in order to run against the repository changes.

For example, I'm adding an alternate sort order to a logical column.  In 11g, I could do that in the repository (online), save it, then refresh my query in Answers, and the sort order would be applied.  Now, in 12c, I must manually Reload Server Metadata in order to see the sort order applied.

Is this a design decision in 12c?

rmoff

The behaviour you describe in 12c is what I would expect, and would have said I'd observed in 11g too.

Did you check what the manual said re. this behaviour?

As for design decision ... very unlikely you're going to get one of the product managers from Oracle lurking on here, so if you literally want an answer to that you'll need to raise an SR I guess

Mark.Thompson

Nope, that was not the behavior in 11g.  A query refresh ran immediately against the updated repository without Reload Server Metadata.

I don't find the topic in the release notes for 12c, and I have yet to figure out where to find the full documentation for OBIEE 12c.

I have accessed:

Oracle Fusion Middleware Documentation content

Then:

Oracle Business Intelligence Enterprise Edition

But everything on that page is related to Getting Started.  Wherever the full documentation is hidden, it isn't easily discernible from the standard path.

rmoff

12c docs home: https://docs.oracle.com/middleware/1221/biee/docs.htm

The described behaviour for publishing changes in online mode does indeed seem to have changed, comparing 11.1.1.9 docs to 12c:

http://docs.oracle.com/middleware/1221/biee/BIEMG/planning.htm#BCGJIBAE (12c)

https://docs.oracle.com/middleware/11119/biee/BIEMG/planning.htm#BCGJIBAE(11.1.1.9)

Mark.Thompson

I think I'll have to slap myself on the forehead and say that the documentation was "hidden in plain sight".  Books.  It's under the "Books" link on the left side of this page:

http://docs.oracle.com/middleware/1221/biee/index.html

Duh!  Thank you, rmoff.