Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Thanks. Is that a column formula in measure or a filter formula, if you could clarify please?

in Q4 and All Other Qs Comment by User_2NI9B Mar 14, 2019 8:36AM
Would you please elaborate a bit? Not sure if I understood. My report has filter for three months that are fed by dashboard prompt.

in Conditional Format Across Columns Comment by User_2NI9B May 31, 2018 6:36AM
Hi Joel - Not sure what DB link you are referring to. Please elaborate. Hi Christian - I am completely aware of your concern. The report requirement is very discrete and it's not worth the effort of modelling the info. We also don't prefer direct sql, generally. But there are instances where it's better to use it, at least…

in 12c Direct SQL Query from Multiple Sources Comment by User_2NI9B Mar 8, 2018 6:29AM
Answer to my question: * Add or modify the following tag <MaxDefaultValues> into instanceconfig.xml and set a proper value (in the below example, it is set to 1000). <Prompts> <MaxDefaultValues>1000</MaxDefaultValues> <MaxScrollValues>100</MaxScrollValues> <MaxDropDownValues>10000</MaxDropDownValues> </Prompts> * Then,…

in Dashboard Prompt Default Values Limit Comment by User_2NI9B Nov 30, 2017 6:59AM
What is more interesting is that sorting in ascending order seems confusing too as it shows 0 as the least number and not null. An SR is definitely on it's way... Thanks

in Pivot Table Sorting Issue Comment by User_2NI9B Oct 26, 2017 7:26AM
This what I found in both- LOCALE = "english-usa"; SORT_ORDER_LOCALE = "english-usa"; SORT_TYPE = "binary"; Surprisingly, NULL_VALUES_SORT_FIRST=ON on 11g!!!

in Pivot Table Sorting Issue Comment by User_2NI9B Oct 26, 2017 6:19AM
Thanks for your response. I checked both, NULL_VALUES_SORT_FIRST=OFF and DB feature is unchecked. Still the same problem.

in Pivot Table Sorting Issue Comment by User_2NI9B Oct 26, 2017 6:04AM
Hi, We tried to apply the patch, but it complains that a more recent patch has already been updated. Any suggestion? Thanks

in 12c Data Issue Comment by User_2NI9B Oct 26, 2017 5:43AM
Thanks a lot Christian. Not sure if we have the same problem as I could not read the complete bug description. Sounds pretty similar though. Requested Bug could not be displayed. Possible reasons are: * The bug id was entered incorrectly. Please check and try again. * The bug id does not exist (was referenced incorrectly).…

in 12c Data Issue Comment by User_2NI9B Oct 25, 2017 9:15AM
That particular post was related to queries from subject areas. But nevertheless, it's the same issue, will have a look at the patch.

in 12c Direct SQL Analysis Issue Comment by User_2NI9B Oct 9, 2017 5:16AM
Hi Gianni, Yes we have tried creating new analysis from scratch. Details of version: Oracle Business Intelligence Product Version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) Please note that the issue is only for direct sql queries. Normal queries from subject areas have no problem. You meant this post? Data missing in…

in 12c Direct SQL Analysis Issue Comment by User_2NI9B Oct 9, 2017 4:57AM

MFA for Oracle Community

Welcome to the Oracle Analytics Community

User_2NI9B Rank 3 - Community Apprentice

Comments