Ok, This to me doesn't sound like an Oracle Analytics product, but more like a Fusion product. Therefore you should post your question in the forum covering the Fusion products: Have a look at the various categories there and try to find the one being the best match for your question.

Data visualization doesn't replace to design a storage for your data that is adapted to what you want to do with it. Your current data format is maybe the format you are given by the source of the data, but doesn't mean you have to stick to it for visualization and analysis. What would be a cleaner model for your data…

Wrong forum… This community (forum) is only for Oracle Analytics products, FCCS Data Management is not part of them. I don't know what forum cover that product, you should try to look on the other 3 main forums to see if you find it there (and there are other specialized forums as well)

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…

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…