Hi, I guess you need to read, understand and then adapt the solution of the link posted by Robert. That blog post cover a very specific need which is linked to printing in PDF without seeing the prompts in the PDF. You don't have that need, you just want to print. So based on the blog posts you can see how they managed to…

Maybe this is helpful? Because for now the thread is still This question is Not Answered. So would be helpful for other users if you look again on how to mark which will also close the thread.

As Joel pointed out there is your issue. A standard Oracle database error. Are you using the BIPLATFORM account to query that table? Because you access the tables directly without a schema, so it can only work if you use the real owner of those tables, by default BIPLATFORM. If you are using a different user you need to…

2933551 wrote:no any tune way in OBIEE? Am I wrong in assuming you still didn't look into the details of where that analysis spends time? Because first of all you don't "tune" a dashboard, which has no logic and takes nothing to render but the content of the dashboard. And still I didn't see you pointing out where the…

user5922791 wrote:User is in an application role. Application role has permission to subject area. After having read and covered the points Christian asked for, you maybe want to review how security in OBIEE works because "has permission to subject area" is not even 1% of the possible permissions OBIEE has. There is a lot…

Take the problem piece by piece: you have 1 object containing measures and attributes. That's what a degenerate dimension is (in dimensional modelling). OBIEE requires the BMM to be a star, a star means a fact table and at least a dimension. So 1 object will play the 2 roles, you model the measures columns in the fact…

2933551 wrote:Thanks ,Yes I saw that ,but I confuse how to improve that? By understanding what happen exactly and for how long when you open that dashboard. We are back at "response time profiling", identifying which part of the the dashboard takes long and why. Seeing already that your analysis has 86 columns ... I would…

You can have a look at the "Externalize Strings" utility (in "Tools" > "Utilities"). From the doc: You can use the Externalize Strings utility to localize the names of Presentation layer subject areas, tables, hierarchies, columns and their descriptions. You can save these text strings to an external file with ANSI,…

You can't "drag & drop" the analysis from OBIEE to Mobile App Designer. If you want the same, you need to rebuild it inside MAD directly.

984465 wrote:Hi All,I have resolved my issue. So can you please close the thread and mark the required replies as correct or helpful? Right now it's still This question is Not Answered.. By closing the thread and marking you help other users with the same need to find their solution faster, that's how a community forum…

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?