That's my file on a clean install of 12.2.1.3 : <?xml version="1.0" encoding="utf-8"?><sawsavedformat:metadata xmlns:sawsavedformat="com.siebel.analytics.web/savedformat/v1.1"><sawsavedformat:datatypeSavedFormats><sawsavedformat:datatypeFormat xmlns:saw="com.siebel.analytics.web/report/v1.1"…

Hi, An opaque view is just what the name says: a view. So you can have any kind of query there inside as long as the result is a set of columns. It's purely SQL (not OBIEE at all, like if you had this view in your database). To use this in your analysis (report = BI Publisher, analysis = OBIEE Answers) you need to model it…

Do you have any other 12c system around? (even a sandbox or something like that) Look there to see the content of the file, if it isn't empty try by copying the file (if you copy the content directly make sure to not have line breaks breaking your tags and attributes and that the permissions on the file on disk didn't…

Yeah, that's what I saw in the bug as well ... It means just what they said: an ER has been raised, so now you can only wait to see what happen with it: if they implement it and when or they just forget about it for ... "reasons". There isn't much which can be done. In generally I would say you are slightly "abusing" the…

What exact version of 12c do you have? What is the history of that catalog? Is that an upgrade? Is that, as Robert asked, a move from another environment? In a clean install of 12c I have content in that file, it isn't empty like your with just the XML tag.

Based on the error it looks like there is an issue with the XML inside /system/metadata/_datatype_formats (in your catalog) Did you saved some default formats lately? Did you touch that file? Or what does it contains?

As you can see there inside there isn't a patch for it now. So do not expect the community to have fixed a product bug Get in touch with Oracle and tell them you have the same issue and ask them about their plans.

The first one is Excel, the second a dashboard/analysis: do you want to embed Excel in your dashboard/analysis? PS: this comment was a reply to a post of the OP with 2 screenshot, in which it was visible the name of the bank and some details about loans, so in a way it's a good thing he deleted the post

Did you try that?

Hi Abhishek, 1525161 wrote:but still we are facing the issue for displaying the Color in Row and Column.Colors are not displaying as expected. I'm sure you can imagine that with just this there isn't anything the community can tell you, right? Because ... we have no idea of what you are talking about and what you exactly…

Data Visualisation (the old name was Visual Analyser). It's part of OBIEE 12c, but as Christian said you better make sure you have the right license for using it.

1525161 wrote:we are seeing below URL while doing the View Source of the report ..."res/v-wlxaLl*k8U8/sk_blafp/master/customskin.css" That's one of the default styles embedded in OBIEE, so if OBIEE revert back to this one it's because you have some issues with your own custom style. And I really have the impression you…

As an extra info: did you "just" copy your old 10g custom styles into the folder? Or did you take a 12c skin and customize it to be like your 10g? Because lot of changes happened in the interface between 10g to 12c, so I wouldn't expect the old 10g styles to really work correctly....

Did you check the logs of the executed queries? When the agent is supposed to run (or if you execute it by hand), you must see the logs of the condition analysis executed, including the logical query etc. Look for that: is the query executed? Is it right? With which user it is executed? If the agent run as recipient you…

More widely I believe it's worth to think about your "need" from a global point of view. OBIEE as an enterprise wide analysis and reporting platform based on Excel file sources? It's probably easier and safer to get the Excel into a database first and use a proper database. DV can use Excel as source, but it has been…

2934375 wrote:But the presentation services is not starting after this change in the instance config file. And what does the log tell you? OBIPS doesn't stop starting without generating anything in the logs ...

Hi, First thing first: a report as in BI Publisher report or an analysis in OBIEE Answers? The name defines the tool, the tool drives the answer you look for ... ( (c) Christian ) Assuming you mean an OBIEE analysis: If you set an aggregation like MAX or MIN on your "Planned Code" you get just what you look for. As you…

Charles M wrote:I'm going to delete the problem connection and call it a day for this one ... Beer time, sounds fair

Charles M wrote:So, knowing all of this. Can I add 2 more connections? One for the UAT instance and another for production? The whole reason for getting into this in the first place was so that I could connect online to our different environments. Not only you can, but you must do it Or you will really struggle if every…

Charles M wrote:By the way ... are the client tools "hard-coded" with the information specific to the instance that they were downloaded from? For example, if I downloaded the tools off of the 'Dev' instance, will it have only that information> No, the tool only filter available connection by "version" (driver used). It…