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?

@User_2EC4C , Do you mean Oracle SQL Developer Data Modeler? If yes, then you are in the wrong forum. Because it's a different platform your question can't be moved to the right place. You will need to repost it in https://forums.oracle.com/ords/apexds/domain/dev-community/category/sql-developer

And you don't even need * in the name, just leave it empty and click "Query". Without a name you search for it return all of them by default (at least in the 2023 Jan Admintool, but I doubt somebody did change the behavior in the meantime).

Please do not triple post. https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest

Please do not (double or) triple post. https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest

You can easily export a list into a CSV if you open your RPD in the Model Administration Tool. Go in the "Tools" menu and select the "Query Repository". There you will need to make 2 queries. One for the type "Physical Foreign Key" to get the the "simple joins". You can export the result into a CSV and you can click on…

@Sumanth V -Oracle , all the old threads like this one being 3 years old that have been imported from the old OTN forum are abandoned, no need to post anything as nobody will really come back to look at it (they should never have been imported like that, if they really had to be here they had to be locked when not having…

Wrong tool for the job: OAC is not an ETL tool. It can do part of it, but shouldn't be used as purely an ETL tool...

So .... is this Fusion? If you are using Fusion Analytics Warehouse (now called Fusion Data Intelligence Platform), which one of these is your question about? ERP, SCM, HCM, CX (these are categories in this forum where the question can be moved) If you aren't using Fusion Analytics Warehouse, then you should ask in the…

@Alex111 , What product (full name and version) is this about? I suspect it's posted in the wrong category (and this is an abandoned thread by the author 6 years ago). Based on your reply, the post can be moved or we could point you to the right forum.

There are some Oracle product managers and some Oracle support employees in this forum (not sure about developers). But no idea about the users of the Fusion forum, because you clearly expect an answer from them. In the end your question is really more about the Fusion data and the Fusion business rules, not the technical…

Well, I don't remember having seen that kind of question because there are (to make it very generic) 2 possible situations: 1) you don't build or maintain the reports and just run reports that are part of the tool 2) you do build reports yourself In the case of 1), you often have no way to say if it's the case or not,…