Good to hear: the answer is (almost) always in the query :D

Do you see the query fired when you click on the column in the filter and go to select the values? Because there as well a query is executed, and the result is used to show you the values. It is visible in the session logs or the log files.

Hi, The question is maybe obvious for you, but remember that nobody else see your screen or know your environment. You should be more precise... What version are you asking about? Is your "report" an analysis or a BI Publisher report? OBIEE never invent any data, everything comes from queries. And queries are generated…

First thing: OAS 5.9 is our of support, you should really consider an upgrade (OAS 7.6 aka 2024 was released just yesterday), 5.9 is from 2021 and OAS only has 2 years of support. If you look at the session logs you will see the query executed to show the values of the filter. Based on that you will be able to identify…

If you want to create a Google Drive connection, you can follow the steps documented: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-google-drive-or-google-analytics.html

The user there asked for FAW, but all the question was about OAC itself (FAW is a package of tools: ETL, a data warehouse model and prepackaged content in OAC). Up vote that idea, it will be doing the same you ask about.

It is available now: https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html

Just saying, "einstein" is an internal-only Oracle platform (the link doesn't work if you aren't an Oracle employee). @twixi-Oracle please keep in mind this is a public forum (not an internal one), where only "public" content should be discussed or shared. Links to einstein or any other internal Oracle platforms shouldn't…

Triple posting: https://community.oracle.com/products/oracleanalytics/discussion/21121/what-is-pvo-for-fun-user-role-data-asgnmnts-table#latest

Give it a try, I believe it will tell you where it does find all the occurrences. And it doesn’t matter if you replace that search with blank, because it is anyway not a catalog used by anyone or anything. You can search and replace with the same string, just to be able to run it again and again if needed… But that catalog…

What I mean by full catalog search is a content search, not generating reports from the catalog. You can even search with any other tool you have available in the system where you extracted the catalog (fgrep if it’s Linux or any other tool in Windows). You have to search for the full catalog path of your filter, because…

The full out of the box solution is to export the BAR, extract it and use the catalog manager in offline mode (to not enforce security) and then do a full catalog search for the path of your saved filter. You will find all the places where it is referenced. If you work online with catalog manager you will be limited to…

Hi, Shouldn't you be asking this in a Fusion forum? Because it isn't really a Publisher question, it's a Fusion question... Fusion products are covered in a parallel forum: https://community.oracle.com/customerconnect/ There are many categories, have a look and identify the best place for your question.

Ok, in the future for SQL questions you should consider posting them in https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql_and_pl_sql (it's a separate platform but still a fully Oracle products/services focused forum). What data type is your source? "date"? The data type is able to have the time…

Are you asking about a Publisher feature or is yours a pure SQL question? A column of type date, doesn't have a format. The visible format of the date is always a formatting "like a string". There is a default date format mask that is used by the tool you use to view the data.

@Niyati Mehta , You are asking in an abandoned 7 years old thread that was about something else. Your question seems to be about how to do something in Fusion, if that's the case, you are in the wrong forum. Fusion products are covered in https://community.oracle.com/customerconnect/ (look at the many categories available…

@User_HQ9TE , Isn't this one the same as https://community.oracle.com/products/oracleanalytics/discussion/21032/if-create-calculate-column-it-will-automatically-affected-another-measure-column-in-report#latest ? You marked the other thread as answered randomly and not ask about a piece of SQL. But that query isn't…

Ok, so back to your test case: you now have a user that, thanks to the DV Consumer role, can open the workbook and see the various visualizations inside. Now that same user is opening a dashboard and while you can open it, the content is blank. What is the "dashboard"? Is that a "classic" dashboard (from /analytics ) ?…

Security is a serious thing in Oracle Analytics: a security model can be extremely complex because it's meant to be an enterprise platform. If you don't see data, it's once again because of security. But nobody else than you has that environment available and know what the security model looks like. Adding your new user to…

Depends if you want to change it... MUD for the RPD will still be the same and work the same for a few years. But if OAS 2024 comes with the new Semantic Modeler, and that your RPD is fully compatible with the Semantic Modeler, you can plan to move to that and adopt a totally different way to handle parallel development of…