Check the link I posted ;-) Because of end of support on FMW 12.2.1.3, OBIEE 12.2.1.4 has been made compatible with FMW 12.2.1.4. It's something very recent (last month), and only to allow for FMW 12.2.1.3 to "die" peacefully while still having a solution for installations of OBIEE 12.2.1.4 (because FMW 12.2.1.4 is used by…

@User_PE6GL , You shouldn't be installing FMW 12.2.1.3 anymore these days, you should move to FMW 12.2.1.4 even for OBIEE 12.2.1.4. And, is there really a good reason to install something as old as OBIEE 12.2.1.4 these days?…

Ah, well, that error message clearly doesn't help you :P To make sure your query fully works on all the rows in SQL Developers as well, you can try to retrieve all the records of the result set. Or write that query into a new table: if there is an error you will get the details (but it's possible the query seems to work in…

Hi, If EXTRACT is the one giving you issues, why don't you replace all that piece by a TO_CHAR ? You only seem to want to format a date into month-year, to_char() can do that as you pass the format mask to the function (as long as your date is a datetime, can't remember if to_char() works on intervals...). Also, it's…

@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…