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, https://www.oracle.com/business-analytics/data-visualization/connectors/ , 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…

"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. https://community.oracle.com/mosc 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. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/oracle-analytics-ai-assistant.html There could also be privileges involved. But they don't say what region has it, and what shape can have it…

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…

Hi, Are you maybe based in India or a region in the area or have set that as your date/time? The 2 dates to me looks the same, once corrected of the time zone. For example I believe India is at GMT+5:30, if you take midnight and remove 5h30 you get 6:30pm, and that's why you get a date in your URL that is 5h30 earlier than…

That's a configuration of that forum. It's a bit weird: if you aren't connected to an Oracle account, it is visible. If you have a valid session with your Oracle account then you need extra steps. Read the content of that page, it does talk about an incomplete profile (point 2.). You need to go through those steps to…

Hi @Jorge Olmeda , Would you mind to post a new question for this? This one has been imported from a different forum (after having been migrated across at least another forum). Pictures have been lost and it was about OBIEE 10g. In your question, can you also make sure to say which part of OAS you are working with: DV,…

@User_74KN4 , You can follow the link provided by Rajesh and post there (find the best matching category). It's a parallel forum but the 2 platforms are independents and a question can't be moved from this forum to the Cloud Customer Connect forum.

Reading again your question: when we try connect to http://xxx:9502 it redirect to https://xxx:9502. That sounds like a browser thing. Browser try to enforce https:// on everything, there was even a plan to make that a default thing that any URL would be turned into https://, now I believe it is checkbox somewhere in…