Hello Everyone,
When ever apply some another column in sql it will automatically affected another measure column in sql report
I want c1 is 15 value based on add another column.
Could you please help me anyone.
Thanks.
Greetings,
It looks like your question is not OAC or OAS related. Please consider posting it in SQL & PL/SQL community :
SQL & PL/SQL - Oracle Forums
or Oracle Database Discussions : Oracle Database Discussions - Oracle Forums
@User_HQ9TE ,
Isn't this one the same as https://community.oracle.com/products/oracleanalytics/discussion/21032/if-create-calculate-column-it-will-automatically-affected-another-measure-column-in-report#latest ?
You marked the other thread as answered randomly and not ask about a piece of SQL. But that query isn't something you wrote by hand, it very much looks like a piece of query generated by the BI Server, or you really should consider aliasing your tables with something that makes more sense.
By the way: you are sharing a number of information and data taking pictures of your screen: don't you have a print screen app, even just Windows default one? Or aren't you breaking some privacy and security rules of your employer posting all that?
Please be precise in what product it is about: is it an analysis? is it a report in Publisher? is it just a pure piece of SQL? What is the full product name and version?
And if it's the same as the other thread, not a big deal, but then I would suggest you post this extra piece of info in the other thread and this one will be closed.
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?
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.
I am getting syntax error when im trying to add full table hint in evaluate for an obiee report analysis column. This is the function im adding the below: why isnt the syntax working, what is missing or incorrect here in the function?
Hello everyone, We use OBIEE 11.1.1.9, on Oracle Linux. We have set up Usage Tracking. It shows users but it misses some of them. How can I see all users?
Hi everyone, I have a cascading prompt setup in OAS Classic (OBIEE 12c) that works for single selection but fails on multi-selection due to variable formatting. The Setup: Column Prompt 1: "Cost Center" (Multi-select enabled). Sets variable @{COSTCENTER_CONCAT_PROMPT}. Column Prompt 2: "Organizational Unit". Filters its…