Could you please clarify what you call "BI Mobile Apps" ? If you mean the OBIEE mobile app there is nothing to "drag", it gives you access to the same content as it's the same thing. Or do you mean a mobile app developed with the Mobile App Designer?

All in all you need to do a "response time profiling" : https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-analysing-results/ Only based on that you can identify what need to be tuned. Any other approach will be just random guessing, setting things, turning them on and off hoping it will change something (and…

2933551 wrote:I already mentioned the query only run 12s on db no performace issue What Joel was asking is if you run that query in the DB via SQL*Plus from the OBIEE server : it's different than just "the query run in only 12s on the DB" (there are "things" which can make a huge difference .... like .... a bad networking…

Now the next step is to find out how that file ended up being empty ... You maybe want to keep an eye on it or the logs to try to identify what made it happen if it's coming back.

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 ...