to add on top of @GayathriAnand-Oracle inputs, @Kristian B. Joergensen begin with the session log with higher loglevel and check if the logical query and the plan are same of the one that is generated by the users and the one that you seeded the cache. If the logical query and its plan changes for the case#1 , it may not…

Hi @Kristian B. Joergensen So when we say slower load times, i do understand that its the cache seed time , ie the time taken for the agent that executes and seeds nqsserver cache takes a lot of time for the records over 20 years? Do you see much difference in the "physical query execution time" between the good one and…

Hi I tried with the Sep 2023 release admin tool with Sep 2023 and i dont see any issues, i think it maybe specific to Nov 2023. Is the use-case such that you are using "Open in the cloud " to connect to OAC nov 2023 and try to save the RPD local and that causes the warning? and whats the admintool version you are using?…

Can you check the below pointers Check if you are able to see the users when you search it on Enterprise manager console against any application role If this is not working in em as well, probably we need to revisit the adapter that you have created Check the logs ( bi_server1.logs ) by enabling DebugSecurityAtz and see if…

I do see an blog post about that on Microsoft side ( look at the update at : 03-30-2020 05:04 AM) But this is an FAW product community forum. I recommend you to create a new post with the Oracle Fusion Applications Cloud Service and you may receive more expert guidance. Thanks,

Hi What are the versions that your Windows and Linux OAS's are on. Are you comparing the same patch levels here? I do see the same behavior in my local OAS linux as well, yet to test this on Windows, . And my properties screens on both the versions look different than yours. It may require further debugging Thanks

You may provide more information than just that if its anywhere related to OAC workbooks that uses essbase as a datasource and give us more info about what kind of report/analysis, to help you troubleshoot. Thanks,

I just tweaked that formula a bit and it works this way. Is this how you want to display your dates in text format? cast(year("PC0"."Time"."Date") as CHAR(4)) || '-' || cast(MONTHNAME("PC0"."Time"."Date") as CHAR(3)) || '-' || cast(DAY("PC0"."Time"."Date") as CHAR(2)) And this is how it looks for a whole month!

OBIEE 122120 is out of error correction support and pretty old. We recommend you to consider upgrading your systems Oracle Business Intelligence Enterprise Edition (OBIEE) Error Correction Support (Doc ID 1664916.1) Oracle Analytics Server Error Correction Support Policy and Dates (Doc ID 2775561.1) For this writeback…

Hi, In my understanding , the "scheduling" option is available in OAC and not in OAD. i just had it tested on my new release of OAD and i could confirm that its not available. OAD Documentation for possible options to refresh data :…

If you still see any challenges in getting this implemented successfully, please post that here. If the SSO works properly, consider to mark this thread as answered.

I believe that the redirection is not set properly. Please revisit your OHS access/error logs, and verify if all the context roots are properly configured for the redirection. It looks to be a config issue.

How will the data be directly integrated into the Oracle Analytics Cloud (OAC) from an on-premises EBS data source? You can use Private Access Channel to integrate private/on-premise data sources with OAC, There is a series that consists of various use-cases to achieve based on your network architecture How will the OAC…

You may use the below API documentation and shall think of scripting ( like bash) to call this and schedule it on utils like cron etc per your requirement. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/op-20210901-catalog-datasets-datasetid-actions-reload-post.html

It sounds like covered in this blog, please take a look. the last picture shows how the top10 vs others perform and there is a nice video about that too, embedded within the blog. https://blogs.oracle.com/analytics/post/how-to-calculate-top-n-versus-rest-of-population-in-oracle-analytics

Hi, You may refer this blog and see if this is useful. https://www.ateam-oracle.com/post/querying-oac-and-faw-data-models-remotely-using-jdbc

I'd recommend creating a new post for your issue, this is a pretty old thread

sourceApplication -> I believe that its just a free text that could be added to distinguish where the SOAP call is originated from

Hi, I tested the scenario and I can see that the copyitem() and unarchive() methods work fine on OAC. If you are using latest OA* versions, it should be available to you as well. Note: in the below examples, i am using v12 wsdl. Input Sample for the copyitem() <soapenv:Envelope…

i tested with OAC and you need to put the filters under the filterExpession and in an xml format( You may have to use v6 versions instead of v12 versions in the sample below You may have to extend it to the variables based on your requirement. <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"…