Hi, I'm jumping in here just having read "pieces" of the thread (but hopefully I got the important pieces). In DV, in your workbook (as Christian said, the date filters aren't in your dataset, that one should be without filters to allow the user to select filters at the workbook level), you can create a parameter and…

What for? For what usage? RCU? Source of data? And isn't this related to the other question? https://community.oracle.com/products/oracleanalytics/discussion/22684/what-types-of-database-is-supporting-to-oracle-analytics-publisher PS: when you ask a question, the "question" field is just a short title for your question,…

@User_GKKQ6 , For what usage? Do you want to know what databases are supported to install Publisher (the RCU schemas) or databases that can be used to create reports? Because in Publisher you can deploy any driver you need, therefore any database that has a JDBC driver works.…

Ok, the documentation you linked above, just like the screenshot I posted, are for a DV workbook (DV being Data Visualization). The screenshot you posted, are not for DV, but are the action links in a "classic" analysis. In action links in "classic" you can't set headers. You can just define parameters and that's it…

I see it just there on the screen on the data action… Don't you have it? It is also in OAS 2024, therefore it isn't an extremely new feature.

Hi, Publisher can generate reports and push them to a FTP server, but it isn't going to connect to a FTP, copy a picture locally, to then embed it into a report. It's your task to make any file needed available locally (or via URL could also work, depending on your report). Write a script, deploy a webserver exposing your…

Hi, It's a browser error, add more ram to your PC and see if it works better (or close everything else you have open to give all the memory you can to your browser). (I'm not even joking, your browser is telling you it doesn't have enough memory to display that page.) But I'm curious: why do you want to render a report in…

Hi @User_Q1Z83 , Welcome to the forum. Because this is a public forum (not Oracle internal), I believe there are Oracle rules requiring employees to identify as such in their profile by setting a display name. Please do consider being a bit more explicit in your questions (5 words or 2 paragraphs are the same price: free).…

If you want to have some form of follow up on the progress, you will need to go through a SR, to be added to the people affected but the issue (the bug already exists, you will need to be linked to it). That's all you could try to have updates. Otherwise you need to wait for those with a SR open to post updates if/when…

Hi @muneezaniaz , No need to upgrade your account or look for a paid OCI account, it will not help you. As Benjamin said, the demo instance is read-only and restricted in permissions to avoid users to "break" it (by mistake maybe). You could look at https://www.oracle.com/business-analytics/data-visualization/examples/…

Hi, The token is a static value that is saved in the connection. You can see it just like for the password of a database connection : it's part of the connection, and it is static. You can edit the connection and update the token, but that's not something a dataflow can do. In OAS 2024 the REST API connection in DV is…

Hi, The shared storage can be various kinds of solution, NFS is one example. I imagine that the idea, if using NFS, is that it does come from some kind of enterprise storage solution. One of those that just can't go down because it has redundancy everywhere (drives, host, power, network etc.). The architecture leave it…

If you are using that query as source for a dataset, then the issue is the WITH clause : datasets queries do not support WITH, because the tool is going to generate a query with WITH itself, and Oracle database doesn't support nested WITH clauses. This is a known, and documented somewhere, limitation. Rewrite your query…

If you want to request new features, look if the same has been posted as an idea. If you can find it, up-vote it. If you can't find it, post an idea requesting (and describing the benefits) of the feature. https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

Please do not double post. You asked the same thing, you got replies, you replied as well: stay in that thread. https://community.oracle.com/products/oracleanalytics/discussion/22635/date-in-manual-query

Hi, Does anyone see what's wrong with my manual query (OAS DV)? Well … nobody sees your screen or knows what you are thinking about. When something is wrong, there is generally some signs allowing to say "it is wrong"… Do you have an error? Then post the error. You don't get what you expect as result? Then you maybe have…

Hi, You can't expect the rows to be merged on a column that has other columns on the left not merged. Your "Work Order" and "Required Quantity" force individual rows, the "Total" column can't merge rows back. The merging is a left-to-right thing: it can be merged as much as what is on it's left, or less.

@Muzammil Aman Siddiqui-Oracle , This is a 6 years old thread, migrated through a number of forums over time. If you have a question, even if similar to this one, could you please post it as a new question in https://community.oracle.com/products/oracleanalytics/categories/bi-publisher ? Remember to provide as many details…

If you do have usage tracking configured and enabled, query the usage tracking table and you will be able to get a list. By default the table is S_NQ_ACCT in the BIPLATFORM schema, but you maybe configured a different table somewhere else. You can verify if usage tracking is on (the people installing that OAS hopefully did…

Expanding on Mostafa reply, you can also run the RCU manually to delete (clean up) the RCU schemas created, so that you can then create them again with the same name (but a different password if your original password didn't follow the requirements and limitations for a RCU schema password).