Hi, Are you using OBIEE 12.2.1.4 or OAS (what version?) ? If using OBIEE, what FMW version are you using? 12.2.1.3 or 12.2.1.4?

Hi, Welcome to the Oracle Analytics community and forum. You can't directly impact the whole criteria unioned to another as an "object", but you can bet on the "smartness" of the BI Server for doing the job… If a request contains a filter being something like 1 = 2 you can assume that this simply means that nothing will…

Hi @maria.stanciu , you better create a new question, expressing your use case and the issues you are facing. The original poster of this question didn't really came back to the forum after posting it, therefore your case is maybe slightly different, and with your own question you will get better replies. Feel free to…

OBIEE usually automatically convert date/time to the user account time zone configuration. It does it on all the dates columns not having a time zone (they are considered UTC and therefore adapted to the user). In your case, what is the physical data type of that column? Because that could be the reason why OBIEE isn't…

@Nazera Shabnam. , You don't need to use time calculation for the previous month number. Those calculations generate quite heavy queries while you can do the same with simple mathematics. For example, MOD(MONTH( CURRENT_DATE ) -13, -12) + 12 gives you the previous month number (1-12) without any date calculation (adding…

For a quick test, when running %ORACLE_HOME%\oracle_common\common\bin\wlst.sh you are in an interactive session inside WLST. You can enter these commands: connect('<admin username, like weblogic>', '<password>', 't3://localhost:9500') grantAppRole(principalClass='weblogic.security.principal.WLSGroupImpl',…

@Chad Williams , That command, the grantAppRole , is to add a single group as member of an application role. So, yes: the forceValidate='false' is in each and every call to that command. My WLST scripts to setup the security model easily have 50-100 commands for not too complex security models: it starts by creating all…

Found my notes… So, I was adding groups from the SQL provider as members of application roles using WLST, and it was complaining that it couldn't find the groups. While digging at what the grantAppRole function was doing, I found the definition of the function itself: def grantAppRole(appStripe=None, appRoleName=None,…

Hi Chad, If I'm not wrong, when I last used the BISQLGroupProvider, I had a similar issue. But I was working with WLST, and I found one of the commands had a flag to ignore the check and just add the group name I entered without verifying anything. I need to go through my notes to see if I find the details of what I was…

Hi Adrian, Welcome to the Oracle Analytics community and forum. Your question is related to a data source you are using, but you aren't providing any information on what that source is, what structure it does have, what product you are using etc. For you all that is obvious as you are spending time trying to make it work,…

Hi, Oracle Data Transforms is not an Oracle Analytics product, and this forum only covers Oracle Analytics products. You should consider visiting the parallel forum Cloud Customer Connect, and ask in the Data Integration category: https://community.oracle.com/customerconnect/categories/oci-data-integration There have been…

Hi, What exact product are you working with? Is it a "generic" OAC or is this FDI or maybe OBIA? OAC doesn't come with any data, therefore if a piece of data is missing, you should speak with the person who is in charge of the data integration. If you are working with FDI, the question can be moved to the right category…

Hi Jay, You should develop your "Semantic Model B" inside the "Semantic Model A", because as both Ram and Gayathri said only a single semantic model can be deployed at a given time on a server. If you look into your semantic model, you see it is split in layers: physical, logical, presentation. You can see this as 3…

Hi Saroj, If you look at the second link posted above you see the meaning of (most of) the columns in your usage tracking. If you focus on the columns of the "Query Origin-related Columns" part in the doc, you have all the elements to get the exact name of the catalog object that generated the query. SAW_SRC_PATH is…

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…