If I trust the documentation, it should still be there. But I didn't check in a real OAC….

Welcome to the forum @Paula McMahon , If your workbook is based on a dataset that is a SQL query on a database, and the dataset is set to be "live" (no caching), then you can define the dataset as being the full set, containing all the data, and by adding a filter to your visualization in the workbook the product will try…

Hi, Welcome to the forum! Is the question really about Publisher? Are you asking how you could generate Excel files from Publisher with that option? Or is it a question about something else, more related to Fusion as cloud product? Based on your answers it will be possible to move the question to the right category if…

Hi, What do you call "OAC"? A DV workbook or a "classic" analysis (or maybe even a Publisher report) ?

In OBIEE it was possible to setup SSO by editing some files and redeploy them in WebLogic. This method is fully deprecated, and if you try to do it, you will break your OAS (it will start behaving weirdly saying every click that you aren't connected etc.). In OAS SSO is officially supported "outside" of OAS, therefore you…

Hi, welcome to the forum. Would you mind in giving some more context, explaining a bit more what you look for? The question is maybe not in the right category, or maybe not even the right forum. Based on the extra details you will post, it can be moved or you can be given a link to a place where to ask for it. What product…

Welcome to the forum, User sessions report " Running / Finished / Cancelled " Can you be a bit more explicit in what you are looking for? Is that a question? What is a report for you? A report is generally a Publisher report, or you mean a "classic" analysis or maybe a DV workbook? What would the status be related to? Also…

Hi @User_UN2OH , Can you please go to and ask a new question? This is a 6 years old thread, it's better if you ask a new question by providing all the information about your question, including the product version you are using. Thanks

Should i patch the Oracle WebLogic Server and Oracle Fusion Infrastructure to latest release patch? Good practice says that yes, you should patch. But because you are still using a more than 4 years old version of OAS that isn't supported anymore for more than 2 years, do you really care match about the security of your…

Not sure if you really want to submit an idea for this, is that really what you want? Or you are just asking how to do it, like you did in the thread posted in the right category? I believe this idea can be closed and discarder as posted in the wrong place…

What product are you asking about? Publisher doesn't come with any data, it's just a reporting platform. Your question is about some tables or some other kind of data and not about a technical feature of Publisher. Based on your reply the question will be moved to the right category, or you will be pointed to a better…

Did you configure the database properties in the RPD accordingly to what Postgres understands/accept? The piece of message you posted above is LSQL, it isn't the query sent to your database, if you want to know what query the server tried to send to your database you should look in the logs.

Do you have any insights on how to create a form in OAC DV for users to fill out? This is something that I am trying to achieve with OAC landing page acts like a signup form where users must enter some information before they can access the dashboard Easy: not possible. The only thing that can prevent a user from opening…

You already got the answers you were after based on the marking of the thread. Keeping it short: Oracle doesn't provide any piece of documentation about the JS part of "classic". There are tons of event handlers all over the page, and many of the menus and interactions are often events instead of direct links. This means…

Did you configure your OBIEE 12c to allow the Google files to load? CORS/CSP/browser protections is a real thing, and in 12c you must configure it to allow the Google JS files to load. Look at your browser developer extension and you should see if the JS files are blocked because of the default CORS/CSP/browser protections…

The key point in Christian message was "Can you please open a new thread", because as he said this is a old thread abandoned by OP. Ask a new question, provide all the details (product name and version), explain your need, what you tried and as much context as possible. And posting it in the right category, if it is about…

since we moved all the case when calculations to the table view it was supposed to perform better What made you believe this? If your CASE WHEN instead of being in the workbook or dataset is in the view, the real query executed by your database is probably pretty much the same: a view doesn't materialize anything, it just…

Hi, Your question is more about the source system than Publisher (because Publisher does reporting on a number of sources but doesn't own the source application data). You should consider asking in the Fusion forums: There are lot of categories, find the one matching the best your product and question.

Go in Graph properties > Titles and Labels > Data Markers and select to always display the data label. But as said, it's one or the other, it can't display both the value and the percentage at the same time. The size of the bars already give a hint about the %, therefore if you display a small table with the % values…

Ok, it's a "classic" analysis, and let's take OAS as product (version 11 would be OBIEE, but that's a 10+ years old product). Moved your question to the right category…