Hi Bret, The situation I have in mind (that I'm facing right now) is for example a customer who has been "moved" to OAC by Oracle Lift: they needed to replicate 8 PVOs and they created 8 replication jobs scheduled at 1 min of interval from others with daily execution. Now the customer asked if they could run the…

Hi, What product (full name and version) are you talking about? What is a "direct database analysis" for you? An analysis built using a direct database query?

I believe what you are asking is similar or related (that answer could solve your question) to https://community.oracle.com/mosc/discussion/4557694/how-to-suppress-bip-output-from-being-sent-by-email-when-there-is-no-data-retrieved-oracle-cloud#latest . I didn't read what the replies were, have a look in case it matches.

Ok, so it's Publisher. Let's move the question in the right category so you can ideally get the right answer :) And I did see the same kind of question not too long ago (about Publisher). Will try to find it (can't remember in what forum I saw it ....)

Can you more precise on the what your "reports" are? Are they Publisher reports, "classic" analyses or DV workbooks? And by "running" you mean that they are schedule to send something out?

So, not the spaces or special characters in the path. I believe I remember people having had issues also because of existing Node.js installations that were conflicting (paths or something like that): do you have Node.js installed on your Window?

Your hardware is way more than the minimum requirement provided, don't worry for that. There have been a number of people reporting your same case over the years. The always were related to something specific in the user environment (because all our Windows are different in the end, we all install different things etc.).…

Thanks @Philippe Lions-Oracle , With "tools" I was thinking at that extension but couldn't remember the name and staid "vague" (also because I don't use that extension as I developed my ways to have access to everything in OAC/OAS over time...) That extension should become part of the product by default, it's one of the…

Your current solution is what I call "cheating" as you play on something that could be seen as a weakness in constraints in the tool. What I mean is that by deleting and renaming you get an ID which wasn't supposed to be given to you as it was used in the past (even if you deleted that dataset) and there are even objects…

@User_9BUCP , Not sure what your post is meant to be, but if you have an error with Publisher, create a new question in the Oracle Analytics Publisher (BIP) category explaining your issue (full product name and version, what you tried to do, how you did it, what you got instead and also screenshots often help in better…

@OAldrich , That plugin doesn't do any miracle, it simply call an API and store the result into datasets to "analyze" it. You can call that API yourself and get the output and do the job you need with it, without going through the plugin. Without going too much into the Oracle cooking behind the scene, seeing how DV is…

Could this tool be moved to a Cloud browser function to replace the current client tool? It is there, it's called web service, because that's mostly what the Catalog Manager does. And if you check the roadmaps (or some of the sessions where Oracle talks about it), they plan to get rid of the catalog manager at some point…

@User_F707D , OAS 5.9 is out of support, why would you use that? In another question you said : We are doing one upgrade to OAS 2023 for OBIEE 11.1.1.7.0 to OAS 2023 Are you expecting OAS 5.9 to work with BVT? Still no, the tool is gone and wasn't developed for OAS at all. You should look at fixing the issues, mostly…

Did you click on "Convert this filter to SQL" in that popup? "Products"."P1 Product" LIKE concat(concat('%',@{your_variable}{'%'}),'%') Which obviously isn't going to work because it doesn't mean the same. I imagine it would work better with a static list of values because that can be turned into a proper SQL expression…

As I said above, you have to repost your question in the other forum (link posted above to the right category). This forum is about Oracle Analytics products, it doesn’t cover SQL Developer Data Modeler.

The number of selected values in the dashboard filter can change so i cannot write the query myself with a fixed number of OR operators. This is why there isn't an operator in SQL doing what you ask. LIKE works on a single value, IN working on a list of values but it's full match values, not part of their value. I don't…

Hi, Can you have a look at https://support.oracle.com/rs?type=doc&id=1917119.1 ? The link is the "accepted" answer to another user having the same issue (at least same error message): https://community.oracle.com/mosc/discussion/4295668/bi-publisher-desktop-unable-to-install

@Michal Zima , Is your improvement of current visualization "Dashboard Filters" to rename it to something else? Because DV doesn't have dashboard but workbooks and canvases? Every time I see that name I have the impression somebody got confused and though they were developing something for "classic". And it just confusing…

Ok, so good to know that your issue is actually with BIP. Is your use case that you want to select 1495 locations of your total 1500 locations? Because then you should switch to exclude the 5. Or you simply wants them all, then you should skip filtering it fully. All in all: the ORA-01795 is a database error. It isn't BIP…

If you are passing a parameter to a query that has more than 1000 values, you are doing it wrong somewhere. What is the reason to have more than 1000 values in a parameter?