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…

standard reports available in the menu Others-Financial Reporting Center OAC and OAS comes with no content, therefore I don't know what menu is and what kind of object is there. Is that maybe in a Fusion app?

Joan, You don't really need to redo an install of OAS 2025… Every time you import the BAR you can override almost everything, therefore it's a bit like having a new install all the time. And I don't see why users should exist to be able to import the catalog: when a user leave the company, the personal folder is still in…

Hi, You don't see 2 decimals but you see … no decimals at all? What is the data type of those numeric fields? Are they maybe integers? Can you try to edit the formula of one of those adding a * 1.0 to see if decimals appears when forcing the number to a float?

What Gayathri said: the logs in <domain>/bilogs/metadata/importbar... are extremely (almost too much) detailed and do contain all the details pointing at what went wrong in the process (it can really be a long log, read it carefully to avoid false-errors that aren't the real root cause but a consequence of it). Based on…

If you mean the "Data Replication" option Gayathri mentioned, it is this: It doesn't give you access to physical tables, it doesn't replicate physical tables, it does export PVOs to ADW, and from there you can do whatever you want with those database tables. The details about the PVOs (what means what, what is where etc.)…

Hi, Are you using FDI? If not, where does the subject areas come from (who did build the semantic model)?

Hi, That's how the tool work. The not formatted export (CSV), takes the result of the criteria as it is. The formatted export goes through a number of steps and that's what make it slower. If you don't have any error and the file is exported correctly, not sure you can really do much: that's how the tool work. If times…

@Benjamin Arnulf-Oracle can you close this idea based on the above interaction? Mandeep, ideas involve a workflow that has been defined on the Oracle side, and I prefer to not interfere with it (while I wouldn't mind closing a thread in the other categories). Ben will know how to best handle this :)

Hi Olga, Could you please share if by "report" you mean a Publisher report, a "classic" analysis or dashboard page or a DV workbook? Thanks :)