Hi, "classic" agents can't write to OCI Object Storage from OAC. DV export also doesn't write to OCI Object Storage. Therefore you can't "natively" do it from there. What you could do, for DV, would be to have a script that export via the Rest API and then write to your OCI Object Storage. But you will need to write the…

So, if your Contracts table had 0-1 rows for each supplier, it would be very simple, because that's just a simple snowflake you need "flat" into a single logical dimension. You do that by adding the 2 tables in the same logical table source of your logical dimension. The tool is smart enough to query the second (Contracts)…

Hi, As your question is about Fusion data more than how Publisher works technically, you should ask it in the forum covering Fusion applications: https://community.oracle.com/customerconnect This is a parallel, but independent, forum covering all the Fusion apps and a number of other cloud apps. You can see that it has…

1 and 2: it isn't about legacy vs new, it's DV vs "classic". Two different solutions, with different features. DV isn't designed as the full replacement of the other, it's a different approach to analytics. Therefore there isn't a best practice, or even a good practice between the two UIs. It depends on you, your usage of…

Hi, Is your contracts table a dimension or a fact table? While not all suppliers have contracts, do they have a single contract or multiples? By the name, it sounds like you could have multiple contracts for a single supplier, which will then start multiplying your suppliers rows if you join them.

No clue if one exists… Take the one between OAC and OAS and the one between OAS and OBIEE and merge them together: you should get a global overview of OAC vs OBIEE.

Hi, Welcome to the Oracle Analytics community and forum. but the engineer provide directions to post the query into cloud customer connect. Then you should try posting it in Cloud Customer Connect. It is a separate, independent, forum covering all the Fusion applications and a number of other cloud products:…

Hi, Welcome to the Oracle Analytics community and forum. You seem to have a purely data question about a Fusion application, and not a question about how Publisher works. If this is the case, you should consider asking the question in the forum looking after Fusion applications: https://community.oracle.com/customerconnect…

An install finished without errors sadly doesn't mean everything is right. A number of requirements are only involved when performing some activities, and therefore can generate issues later on. Did you install all the required packages listed in…

Ok, your screenshot shows E-Business Suite. There is a category for EBS in the public Developer Community: https://forums.oracle.com/ords/apexds/domain/dev-community/category/general-e-business_suite You also have a category for EBS is MOSC: https://community.oracle.com/mosc/categories/oracle_e-business_suite (look at the…

Was your install of OAS 2025 done correctly? Supported OS and all the required dependencies installed? (there is quite a list of requirements depending on the OS selected)

Hi, This is a duplicate of https://community.oracle.com/products/oracleanalytics/discussion/26133/bicc-connection-external-service The answer didn't change, BICC is not an Oracle Analytics product, it is part of Fusion. The Fusion applications and all the related tools are covered in a separate parallel forum:…

Good! And while it wasn't said, do your report in "offline" mode if you want to really have everything.

You should have "All", or something that means the same. I don't have a 12c catalog manager anymore, and I saw that the OAS version does it. There are good chances the same (or similar) was already there in 12c.

Hi, If in your report you add the ACL column you get the ACL of the object. It will be a single column with the whole ACL, therefore you need an extra step to process it if you really want a full detailed ACL output in separate columns (but because the ACL can be from a single object to 50 different objects, that's maybe…

Hi, As your question is about Fusion data, it isn't really a Publisher (technical) question. Fusion, its data, its embedded reporting, is covered in a parallel (but independent) forum: https://community.oracle.com/customerconnect You will find lot of categories there, including some about analytics and reporting. Have a…

@User_TUN0Q , If the error you had was something like [nQSError: 22020] Function Concat does not support non-text types. then the expression you need to use is not exactly what is posted above. As you see in screenshot just casting as char will generate char values longer than needed, adding a space after the year and also…

Hi, Welcome to the Oracle Analytics community and forum. What was the error you got when concatenating the 3 pieces (formula for year, static text, formula for quarter)? If you provide that, there is maybe a simple fix in the syntax…

https://community.oracle.com/products/oracleanalytics/discussion/comment/68911#Comment_68911 No SR because that would be between the customer raising it and Oracle. But there should be at least one MOS note covering this. Did you try searching in https://support.oracle.com ?

Your OBIEE 12c BAR contains mostly only catalog content: your RPD is meant to be somewhat clean (that's good practices) and therefore usually isn't a problem when importing. Your security should also be somewhat clean, even if seeing the _GRP2ROLE_ prefixes those are catalog groups that have been migrated automatically in…