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.

Please do not double post. You asked the same thing, you got replies, you replied as well: stay in that thread.

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 ? Remember to provide as many details as you can about it, including what seems to be obvious (it is for you, but…

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).

Hi, You are maybe in the wrong forum… What application are you asking about? Isn't your question about Fusion products somehow? If it's the case, then look at all the categories in and find the one being closer to the application you ask about. Publisher could be embedded into your Fusion product, but if it isn't a…

Look at the Network tab and find out exactly what page is being blocked. Because just having the console message about the domain doesn't tell you much… And OBIEE 11g is 8+ years old, browsers security was different back at that time, don't take it as a reference for embedding… For example, in this screenshot you can see…

You expect the login page to be visible in the embedding? What page is the system exactly trying to load? The login page is a different deployment in the bi_server1, not sure any config in DV or OBIPS config file applies there.

Is your prompt a real number? Or is that a number but defined as text? And is "Person_Number" the real name of the column? As you can see from the query visible in the error, what the tool is doing is adding the filters conditions to the LSQL of your analysis. You must make sure that the column is correctly referenced.…

Hi, Did you enter your domain where you are trying to embed the OAS page in DV > Console > Safe Domains as accepted for embedding? This is from OAS 2024 (aka 7.6), can't remember if that page was already like that in OAS 2023 (7.0). You can read some more details in the doc: PS: don't enable it for all domains, enter the…

Hi @Betty.ca , That "search" feature is actually a "virtual" feature that does loop over all objects of the catalog, apply your filter criteria on every single one and see if it matches or not. There isn't a webservice method for search (the Catalog Manager is a GUI on top of the catalog webservice), there isn't a search…

Do not mix the 2 key concepts: a calculation and a filter. If you want to filter YEAR = YEAR( your parameter ), then do this as a filter: it can be a filter in the workbook, it can be a filter in the visualization where you need it. Then if you need to extract the month from a date, you can do that with a calculation. But…

Hi, What should that calculation return for records with a date in 2023? You could use CASE WHEN "Year" = '2024' THEN MONTH("FAW_DATE") END But that calculation will return NULL for any other date not matching the year = 2024.

Hi, I believe BICC questions, mostly when about default PVOs, should be asked in forums looking after Fusion application as that's the one providing BICC and the PVOs. They are covered in a parallel forum: Look at the many categories available there and ask in the one that you believe is the most appropriate (source…

Hi, Our API Gateway does not allow us to configure variables/rules containing the %2F characters. I see what you are saying, but did you try asking your API Gateway provider to just support %2F (which is a perfectly valid component of a URL) instead of asking Oracle to rewrite the Publisher API? Because it isn't a…