@Philippe Lions-Oracle and @SteveF-Oracle , I don't know how to reproduce the generation/saving of the wrong JSON in the GUI, mostly because I don't know at what point it went wrong with all the other issues I had yesterday, and how I managed to do it. Being a customer's environment, I don't have the permissions to raise…

Hi, What product are you asking about? Because you posted in the Publisher category, but your question isn't about Publisher, it's about data. Data is probably part of another product, and maybe made available in Publisher through a number of prepackaged reports or something like that. Based on your answer the question can…

And the answer is ... a "corrupted" DV workbook JSON, but not corrupted enough for the tool to see it and report it as broken. I can't explain how, why, and how to reproduce, but the DV workbook JSON for 2 of the 30 columns I needed in that table, contained the same "columnID" twice, pointing to presentation columns (the…

What product are you talking about? Because you link to some kind of content, therefore it isn't "just" Publisher, you should be asking about a different product providing a number of pre-packaged content with Publisher.

Please avoid multiple posting for the same question: https://community.oracle.com/products/oracleanalytics/discussion/21163/max-aggregate-returning-multiple-rows#latest

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.