When ever apply some another column in sql it will automatically affected another measure column

User_HQ9TE

Hello Everyone,

When ever apply some another column in sql it will automatically affected another measure column in sql report

IMG_20240306_194015.jpg

IMG_20240306_193752.jpg

I want c1 is 15 value based on add another column.

Could you please help me anyone.

Thanks.

TetyanaH-Oracle

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

Gianni Ceresa

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