Can you help us to understand this issue. The only truth is the physical query executed against your data source. You have "no results" when adding a new column in an analysis? Open the logs, find the physical query generated and that's how you fill find out why no data can be found for that query. OAC doesn't do any…

To be precise: in a dataset you can define filters at the dataset level to select only a subset of rows. The issue is that a parameter doesn't exist at that time, parameters can exists once you have the dataset. Therefore if you try to define the filter to be based on a parameter you get an error that the syntax (the…

In a DV dataset, you can't have that dynamic component. It is based on a "static" query by design. If you were using the "classic" part of OAS (analyses and dashboards), you could use a direct database request to build your analyses. There inside you can use parameters, just like in your Discoverer workbooks. But, as I…

Hi, You are probably using attributes and measures coming from various dimensions and fact tables, and not all of them are connected or have the right content level defined. The column you added comes from something (dimension or fact table) that doesn't have any connection with something else that is already part of your…

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/odata.html 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 https://community.oracle.com/products/oracleanalytics/categories/bi-publisher 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,…