In what piece of the product? And, why? Excel has it, but you don't need it: do a count and take the TOP1 of the count measure, job done. If you want to suggest that as an improvement, go to and post an idea (that's where ideas for new features or improvements are collected).

Yes, that's the plan. Creating Skyros as a full style/skin, with all it's files, and deploy it as a custom style. Because it doesn't exist anymore in 7.6, you will not really have issues (duplicate name etc.). And from 7.4 to 7.6, I don't think you will need to adjust anything: it will just work fine. I'm not fully sure of…

You would probably have more chances by building a full custom style/skin, and not mixing up things in the CSS. As Federico mentioned, most styles/skins work by inheritance: there is a base one on top of which some customization are deployed. If you want Skyros, then you should create a full skin/style for Skyros by coping…

Well, dropping is maybe "extreme" (ok, you said you cloned the database, therefore somewhere else you will still have the real 12c schemas). Can't you just use a different prefix? And yes, when picking a prefix keep in mind what you just said: future upgrades in-place mean the schemas will stay, therefore don't add the…

I'm maybe missing something, but it sounds like you are doing a out-of-place upgrade while trying to perform an in-place upgrade. It's one or the other. You are moving to a new server, therefore forget in-place upgrade. Your 12c schemas will not be upgraded, you can't upgrade them, they don't belong to a product being…

You should not set dimensioned based aggregation when not trying to have different aggregation rules by dimension (like SUM for any dimension but LAST for time dimensions etc.). By default the aggregation rule of the measure is used. The semantic model works just like the RPD and the same rules as OAS and OBIEE do apply…

Hi, Are you sure your semantic model is fully correct? Because by default, when having hierarchies, all the measures are aggregated all the time. As the picture posted below, you can see that enabling the "Grand Total" is even pointless because by default the measures aggregate all the time and therefore on the "Total…

@Antariksh Kar-Oracle , that's great, but it's better to not resurrect 7+ years old posts that have been migrated across a few forums. If a question is old (2 years or more), let's leave it where it is, how it is… If somebody has the same question they better post a new one, so they can also provide all the details…

Double post:

Ok, that's the catalog manager version, but what product and version is your catalog from? Are you on some OBIEE version?

Thanks @Jacques V.-Oracle for sharing that number :)

@Sindhu -Oracle , what product (name and version) are you using? That could change a lot of things, mostly because in recent version catalog manager can't be run in offline mode, therefore you maybe don't have the rights to search for that everywhere but just in a limited place of the catalog.

Another argument against an OAS migration: AIX is not supported anymore, OAS is only linux or Windows. You should always do silent installations when it's something that should be done in multiple environments. You can run the GUI installed in dev, set all the values, save the response file, cancel the installation and…

@Saroj Kumar Behera , This is meant to be a community: people come asking questions, others invest their time in answering. It's good that you found the solution yourself, but by not sharing it, if somebody else had the same/similar case and find this post, they will not get anything helpful out of it. Can you please post…

There are a number of REST API connections templates, , but nothing in the list looks like SharePoint. You should find the SharePoint REST API documentation and that will tell you what are the URLs and how you can authenticate. Once you know what SharePoint needs, you can look at how to make it in OAC. If you look at some…

"06/09/2024 12:00:00.000 am" this timestamp in URL changes to "08/06/2024 06:30:00.000 pm" Let say it's right while being very much wrong… 06/09/2024 is dd/mm/yyyy, but the system took it as mm/dd/yyyy, and removed 1 day to it to get 06/08/2024 (in mm/dd/yyyy) and this is where 08/06/2024 (in dd/mm/yyyy) comes from. I'm…

Moved to OTBI, but Financial Reporting Web Studio isn't an Oracle Analytics product, therefore it's still not the right forum. has many categories about EPM products, there are more chances Financial Reporting to be covered there.

@SteveF-Oracle : do you maybe have a number linked with "larger"? Just to have an idea how large it really is 😅

Hi, You probably already saw this: Oracle Analytics AI Assistant is being rolled out in phases, based on region and shape. There could also be privileges involved. But they don't say what region has it, and what shape can have it (if you need more than X OCPU etc.). Hopefully a PM has some details on that.

While I obviously don't know your full task: doesn't the search feature of DV itself works better for the job? Because your API call will show what the account you used to get a token is allowed to see, not what the user is allowed to see. Or maybe this is actually your real need: display a list of everything existing so…