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: (In the…

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…

@User_CPTP6 , This is a old thread imported from a different forum. Essbase isn't an Oracle Analytics product and therefore it isn't covered in this forum. You should ask your question about Essbase EAS in a forum looking after that product. You could look in (I believe they have some Essbase category) or (but there isn't…

Adding to Federico: In the Console you can define the initial page by application role, this gives you a flexibility and configuration that for most cases is enough to replace the fully dynamic PortalPath variable that you had before. If you look at the doc linked in the MOS document you referenced above, you see an…

Not an app user, therefore not going to comment on the missing action option. If it is confirmed it isn't available, and you want it to be considered to be added in the app, the ideal way is to post an idea in (not exactly for the mobile app, but it's the place being the closest to it) so it can be considered as a feature…

Hi @Hasan Sd , Your example seems to be "made up" with modified data, or are all the revenue figures for 2023 negative? It looks like it was made up by manually turning 2023 into negative to have them below the 0 horizontal line. The closest you can get out of the box in OAC to that is by using a butterfly visualization…

Hi @User_EZAOS , Do you mind posting a new question for your issue? This is a old thread, and received an answer. Also keep in mind that the error 500 you see is not the cause, it's just a visible consequence of an issue somewhere else. It doesn't mean anything and will not get you any valid answer other than random…

You are using Publisher in Fusion, therefore you have no control on the "product" itself and you will not even see the change of name, except maybe if you find an "about" or "help" link somewhere inside a Publisher screen. Nothing will change for you or your content, things will work as usual (because again you don't have…

Hi @Nirupama Gopalakrishna, The key part of the message is this one: BI Publisher is effectively replaced by Oracle Analytics Publisher As you can see the only difference is that the product was previously named BI Publisher, while now it is named Oracle Analytics Publisher. It's part of the larger renaming that happened…

The OCI services aren't directly dependent on OAC, they are just cloud-only services that can be called (via APIs) from tools like OAC and OAS. Of course those tools (OCI AI services) requires the data to be available to them, using OCI Object Storage in general, and because of that they feel more "natural" when used with…

after the upgrade from 10g to 11g We are only able to log into Analytics, not to XMLPUser Sounds like the upgrade wasn't done correctly, but this is anyway a different problem. Were the agents working fine and one day stopped and started throwing that error? Or they never did and since your upgrade to OBIEE 11g they are…

Sounds more like a EBS question… If you can get a url (GET) containing all the parameters you need, DV actions or "classic" action links can call that kind of URL and replacing parameters' values based on what has been clicked. But if EBS doesn't have such kind of link available and requires something special, then it will…

Hi, I don't think the command fail right after you run it. I imagine it starts running, doing something, and then it fails. Monitor all your mounts/drives on the host while running to see which one is running out of space and add space in there. Oracle owns the code executed by that script (the script itself just call…

Hi, If you want to remove the rows only when the 3 columns are 0, instead of having OR conditions between your 3 conditions, change them to a AND condition. That will remove the side effect of the NULL values in the one or two of these 3 columns. This will obviously work only if your analysis retrieve rows with all the…