You maybe want to consider granting the privilege to an application role and make your user member of that application role, as Christian said above. It's a general good practice to never set any privilege or permission on a named user but always use application roles for obvious reasons.

Did you manage to find where to reset the password? I guess you did as it's almost 3 weeks, but the thread is still This question is Not Answered.

For the record I better address a misleading part of my previous reply "The" only solution is: creating the totals by hand Not mandatory by a union query. So, as Farrukh did, also works because it's all about how the view is done in the end. Sometime a union is required, other cases works fine with an extra measure. PS:…

What Robert said is "the" only possible workaround. Grand totals are quite simple: they are either always there or never there, you can't do anything on a give one. It's really binary: all or none. So as Robert said: create your own totals, they will be normal columns/rows.

Yes, you would need to understand the basics of javascript. Google could clearly just give you a piece of code to copy/paste, but I really believe it's safer if you stay on things you master, at least you don't add more issues trying to solve a thing with some random javascript. Try your best with the sections properties,…

That's why the blog posts was using a hidden page without the prompts The print will include everything you have in the page, so if the button is in the page, it will be printed out. Because the "PDF printer" isn't able to understand everything you can probably cheat a bit by using full javascript instead of direct HTML…

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.