As far as I know there isn't any setting for pagination of REST calls, and I doubt it does magically handle it (if it was the case, you wouldn't be asking). The REST connector is still defined as "preview", therefore it's possible that support for pagination could be added in the future. The best you can do for now is to…

In addition to what Federico said, if your 2 tables do not contains exactly the same data, you don't want to always query both tables. If you have a known rule defining what is in table A and what is in table B, you can define the fragmentation rule. In this way, if a filter is set in the front-end for that same criteria,…

This RPD was working fine in my previous Oracle Version OBIEE 11g. Going in the same direction of where @Brandon_H was going (I believe): did you upgrade your RPD before to try to deploy it in OAS 2024? Because OBIEE 11g is many many years older than OAS 2024, and there have been many changes. Even just OBIEE 12c required…

https://community.oracle.com/products/oracleanalytics/discussion/24536/aloha-analytics-community Hi, Do you mind to expand the "WACS" acronym? Is that Oracle Utilities Work and Asset Cloud Service? If it's the case, I imagine your Publisher is provided as part of that service, is an embedded thing and a product you…

Hi, You seem to be asking a purely data-related question and not a Publisher question. As you refer to a MOS document about Oracle Fusion Cloud services, you should consider asking in the forum that cover Oracle Fusion Cloud applications: https://community.oracle.com/customerconnect (it's a parallel forum fully independent…

Hi @MSR16 , Another question for you, just to have a better understanding: as your Publisher is part of OAS, did you install the full OAS and are you using the Fusion Middleware security? Or it's fully standalone and you followed…

Hi @Abd_Razak_Mohamed , This question being 6 years old, it has been migrated across a few forums and never really got an answer… Are you using FDI? If yes, then you better post a new question in https://community.oracle.com/products/oracleanalytics/categories/fusion-hcm-analytics If you aren't using FDI but are asking a…

Hi @Maalavica , what product are you asking about? This category is mostly for technical questions on Publisher. If you are using OBIA or FDI, there are dedicated categories for those products where to ask questions about the data model. If you are using a Fusion product, then you should consider asking your data question…

The "Download" button was there in 11g, 12c and is still there in OAS. But apparently you don't have it… Do you mind to post a screenshot of how that page looks like for you? Because it definitely should be there.

Hi, The error you get comes from your database and does tell you that something you expect to be a number isn't one ( https://docs.oracle.com/en/error-help/db/ora-01722/?r=23ai ). If you look in your logs you find the physical SQL that has been sent to your database and will easily be able to fix it. It generally comes…

@Rama123-Oracle , your users are able to see the analysis, but it simply doesn't have any data to show (it's different than not being able to see it). If you, with different roles, have results when opening the same analysis (assuming same prompts/filters if any), it's probably because of some row-level security jumping…

Hi, I assume you are using OAC with the January 2025 release, right? Do you see this issue only with this data flow or with many of them? I just built a quick test data flow in an OAC instance, it does preserve the names correctly. Therefore, if you only see the issue with this single data flow, it's possible that there is…

Hi @User_WA0HA , ODI is not an Oracle Analytics product, therefore it isn't covered by this forum. As your question isn't linked to your OAC usage but about a direct connection between ODI and your current source, it is an ODI-only question. Various other ODI questions have been pointed to this other forum:…

Ok, first thing: you can get rid of EVALUATE, you don't need it. The strange thing is that you have an hardcoded value for the position where to start the SUBSTRING for Month2, does this mean that you know the exact position of all the ']'? In that case remove EVALUATE and just enter the numbers directly. There is a LSQL…

Hi, Tried substr and instr and its not working. What did you try exactly? Any particular reason for wanting to use EVALUATE? In simple SQL, with SUBSTR and INSTR you can do the job, adding some extra logic around it to manage boundaries. Also, if you have a fixed, constant number of "]" per row, it will be a lot simpler.…

(Many) Years ago, I remember having seen a thing where you could define a piece of javascript executed when "apply" was pushed and before to execute the query or something like that. I just don't remember if it was OBIEE 10g or 11g. As you are on OBIEE 12c, it could maybe still be there if it was 11g (while if it was a 10g…

using the screenshot to extract data and load it into PowerBI and other tools which is a huge security issu This is what I mean: instead of wasting your time trying to find something that doesn't change anything to the problem, explain to your customers why their idea is the wrong solution to the wrong problem. In 2 clicks…

Just asking… How do you prevent a user from taking a picture of their screen with a phone or anything like that? If the information is visible on a screen, it's gone: it's available to the user in many different ways. Nothing will really prevent a user who want a screenshot to really take one. If you search how to prevent…

@User_Q7SHC , there isn't a "click here" solution to this kind of requirement. It all depends on what your query (criteria) looks like, because that's the one you have to adapt to add filters excluding what you don't want. OP for example is retrieving data in rows, and want to filter sets of rows, this is what make it more…

Recent OAS version "auto-apply" changes. In the past there was even a button to restart the required components. Now it's a black box: no idea when it does restart what and when your changes are applied for real. The easiest is to change the settings in the page, make sure they are saved there and then do a manual restart…