Hi all
I'm creating my first reports on R&A. And i am stuck WITH a basic thing.
I would like to have all the Preference's column result into a single row.
would appreciate your help, will save my team tons of time.
thanks
Text can't be aggregated (well, technically some aggregation functions works on varchar, but you will not get what you expect).
To concatenate multiple rows into a single one you should push down the job to the database using EVALUATE (or one of the variants of this function).
If you do use an Oracle Database you can then use LISTAGG for the job, for another database you should look for the function to use (if any).
OK thank you for the feedback my technical skills are no there yet to go further in the elaboration of this report. Iguess i will need to turn to an IT guy.
Do you know anybody who can assist me with this small project?
What is the exact name of the product (and its version)?
You should contact the people in charge of the platform in your company, there should be developers there knowing how to do the job.
OPERA R&A VersionTime run: 8/27/2023 3:35:56 PM
ApplicationVersionInstalled DateUpdate DateRevision
ANALYTICS23.6.67/12/2023 3:19:27 PM7/12/2023 3:19:27 PMc00440f6
I am alone in the universe :|
Edit -Refresh -Print -Export - Add to Briefing Book
-Copy
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
