Hi, As your question is about Fusion data more than how Publisher works technically, you should ask it in the forum covering Fusion applications: 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 tons of categories, and for Fusion apps it…

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: And you are…

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: It's a parallel, and independent, forum with…

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 ? Often it is from that list that something is missing. Then there are the…

Ok, your screenshot shows E-Business Suite. There is a category for EBS in the public Developer Community: You also have a category for EBS is MOSC: (look at the main menu "Categories", when you mouse-over the E-Business Suite menu on the left, you have all the sub-categories visible). MOSC requires your account to be…

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 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: Look at the various categories in there and identify the best location where to ask your question about BICC.

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: You will find lot of categories there, including some about analytics and reporting. Have a look and find the best place where to ask your…

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

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 ?

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…

Ok, so you would like to install Oracle Analytics Publisher (let say latest version, 8.2.0) to replace your current BI Publisher 12.2.1.4. If this is all you need, you can stay with Publisher only, you don't need the whole Oracle Analytics product. "Oracle Analytics Publisher" (OAP) is just the new name of "Business…

Hi @Sohail Anwar , Welcome to the Oracle Analytics community and forum. First just a detail: the version 7.0.0 is out of support already, because it's the 2023 release and support ended with the release of the 2025 version earlier this year. You should therefore target 8.2.0 (2025) or 7.6.0 (2024). I want to use BI…