Hi, Welcome to the Oracle Analytics community and forum. BICC is not an Oracle Analytics product or feature, it is part of Fusion. Fusion, and BICC, PVOs and any other data question about Fusion or Fusion integration is covered in a different forum: https://community.oracle.com/customerconnect It's a fully separate forum,…

Hi Ana-Maria, Welcome to the Oracle Analytics community and forum. As you say this is a brand new install of OAS 2024 (not upgraded like the one that works) I imagine it is also fully patched. With OAS 2025 the port for the Model Administration tool to connect online has been moved to 9515. Oracle said it was due to a FMW…

Hi, Is your question just about BICC? Or you are working with OBIA? BICC itself is part of Fusion and is covered in the CCC forum: https://community.oracle.com/customerconnect If you are working with OBIA, you maybe want to post more details, because right now it's quite difficult to have an idea of what is going on…

Thanks, up-voted !

Hi, If you are working in DV, not really… It is a right-click property only so far. There doesn't seem to be a way to dynamically influence that, or set a parameter or a condition on it. It's maybe worth looking in https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server if…

Hi, You just change the source of your physical table from "Table" to "Select Statement", and then enter the query in the columns tab. This is your database SQL language, not LSQL or things like that. You should also consider to create a view in your database directly, this would give you a better auditing and tracking…

From the doc I linked above: If you select either Replace Listed Accounts or Remove Listed Accounts, then make sure that you also remove from the list in the Permissions area the entries that you do not want changed. In theory you could use the "Replace Listed Accounts" to only add the 2 new you need. In practice, I didn't…

In OAC, you don't have access to the tables containing the security, and you anyway would struggle to handle inheritances in your query. If you express your requirement instead of what you imagined as solution (trying to avoid a "XY problem" situation), the answer is maybe simpler than what you believe…

Hi, You can do as you prefer, it depends on you if you want to set permission bottom-up and never use any inheritance or you want to go top-down and use inheritance to do less work. The "Replace Options" you can see it described at https://docs.oracle.com/middleware/1221/biee/BIEUG/mancat.htm#BABEACDC , it's a way to make…

Hi, Are you asking about the OBIA dwh model? Or you are asking about a Publisher or OTBI analysis in your Fusion application?

Hi, I don't have OHS but, in my memory, it is just a custom version of Apache HTTP Server. This means that there are good chances you can just configure it just like you would do it for an Apache HTTP Server. https://httpd.apache.org/docs/trunk/howto/reverse_proxy.html#cluster The thing is that I'm not sure OHS can be as…

Hi, You could go and up-vote the idea asking for it: https://community.oracle.com/products/oracleanalytics/discussion/25265/ability-to-change-color-and-font-of-canvas-name

Hi, Could you provide more details about the idea you submitted? It actually sounds more like a Fusion thing, you are maybe in the wrong forum. What product are you thinking about for this idea? Are you looking for a piece of data coming from your Fusion app and that you can't find when trying to build some reports or some…

Hi, ODI is not an Oracle Analytics product. It is partially covered in this forum when it's about the ODI mappings included in OBIA. Yours seems to be a purely ODI question, without an Oracle Analytics connection. You could try visiting one of these 2 other forums and see if your question would fit better there:…

Did you look at the LSQL and the physical query behind both visualization? For your numbers to change like that, it could be an interference between the filtering and maybe some inner join doing some unexpected filtering or something linked to your data source. But it isn't possible to say more based on 2 screenshots. The…

and IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER You have to decide: it's either a IN condition or a IS NULL condition, you can't have a IN … IS NULL. If you look at the full query, you should easily see what makes it invalid, it's just SQL…

Hi @Karthikeyan s-Oracle , Welcome to the (public) Oracle Analytics community and forum. What product are you asking about? It helps if you can provide a full product name (and version if relevant). Right now you are talking about a table and a column, but Oracle Analytics Cloud or Server, both comes empty, with no data.…

OAC or OAS?

@SANTOSH VIDHATE-Oracle , edit: you already have a question posted for this, stay in it, but provide more details, like the things I mention below. https://community.oracle.com/products/oracleanalytics/discussion/25539/i-need-to-calculate-percentile-of-25th-50th-and-75th-please-let-me-know-any-calculation-available This is…

Hi, A month ago you posted an idea for this same thing. https://community.oracle.com/products/oracleanalytics/discussion/25265/ability-to-change-color-and-font-of-canvas-name Are you saying you posted the idea before to know if it was already possible or not?