Hi I have a track record with the top 10 positions to go. I will need a subtotal of the top 10 positions in addition to the grand total. So it must have 2 totals in my array. Is it possible ? Thanks!
Is this an exam question you just posted here without context looking for an answer?
In any case, your question doesn't make sense.
If you question is can an array store two values, sure you can have tuples as elements of an array.
Hello, It was a serious question. I would like to have 3 totals like in the picture. For now, I only have the total Other organizations and Total. Can we do a total of the top 15 too? If yes, how ?
https://blogs.oracle.com/analytics/post/how-to-calculate-top-n-versus-rest-of-population-in-oracle-analytics
J’ai lu l’article et c’est ce que j’avais réussi à faire.
Par contre, mon problème est que j’aimerais avoir le total des 10 premières positions, le total des autres et le grand total, tous les totaux dans le même tableau.
Cela ne semble pas possible à moins que quelqu’un saurait comment y arriver ?
I read the article and that's what I had managed to do. On the other hand, my problem is that I would like to have the total of the first 10 positions, the total of the others and the grand total, all the totals in the same table. Doesn't seem possible unless someone knows how to make it happen?
As Gianni told you in the other threads and why he consistently answers you in English even though him and myself both speak french:
This is an English-speaking forum in order for it to be accessible to and beneficial to the maximum number of participants. Please adhere to this standard. If you write in french, then the posting benefits only you personally and whoever happens to speak french - that's not the point of a publicly accessible community.
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
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.