I see it in the cloud "My Service" console page, where I can start/stop the whole service. Still couldn't find the proper info in the front-end :( In my few tests the range one did work (using only one of the 2 range to get it act as simple >= or <= and not like a BETWEEN). Ideally you would need to raise a SR reporting…

Looks like a fresh issue as it was working fine in OAC 105.1.0-217, while I have your same error in 105.3.0.

A random guess: is it possible that "# Voucher Count" has many duplicates inside? A filter on Top10 keeps all the rows with the same value as the last one as it doesn't know how to pick by multiple rows with the some value. This could explain why you do see more than 10 rows while using a Top10 filter.

Hi, Looks like the "expression" box has some issues in the validation. The column name is auto-completed while writing it, therefore it's right, but the expression expect the fully qualified name of a column (which at this point not sure what it could be as this step isn't based on a source directly but another step…

Hi, Technically speaking everything can be scripted (even if sometimes it just isn't worth it as the script take longer than doing things by hand). The ways to migrate things from OBIEE to OAC are documented and defined, the important part is more the process. OAC is "alive", things happen there, content can be created,…

Hi, did you try adding one by hand while recording actions in weblogic to get the commands to use at the end? I believe it’s the easier way to get a piece of code to automate things.

Building a proper time dimension takes about 30 minutes including the query to create and populate the table in the database. Let’s say 1h if you have many tables to join it to and many models. Using built-in functions doesn’t exclude by default something as being an hack. You seem to have a negative view of what a hack…

I have a presentation which goes over that kind of content and 2 blog posts which are related to the same topic (cover pieces of the presentation). https://speakerdeck.com/gianniceresa/gdpr-and-you-the-nightmare-of-ba https://gianniceresa.com/2018/03/gdpr-analytics-challenge/…

It all depends on what do you exactly expect to see in your BI security report. Out of the box there isn't much, but there are ways to get almost everything out of your BI instance and then "pack" everything together based on your needs. I do that for example for a GDPR compliance assessment using a graph storing all the…

"migrate BI reports" : this doesn't mean anything. So you mean OBIEE analysis or BI Publisher reports?

Hi, What "reports" are you talking about and in which tool? A report is generally a BI Publisher report, while in OAC DV / OBIEE Answers it would be called an analysis. The more precise you are in your question, the better the answer will be ...

So that's maybe just DVD (as said I don't have an OAC instance available now). This is what I get in DVD ...

When you click on the search bar and start writing something, do you see the info that you can query the catalog, sources and metadata? If yes, that's what the search bar can do. As said there is a crawler in the system, and no idea how quick or real-time it is ...

Maybe the crawler doing the indexing still didn't go through it? Not sure if it's realtime or there is some delay (not having an OAC running right now and in DVD I just have "old" content which is found without problems) But you can still open it from the list of the projects anyway.

The search bar in OAC is supposed to search in the catalog, in the data sources and the metadata. So if you saved your content as "Revenue by product type and department" you can search for Revenue and hit "Enter" to run the search and you must get the results.

You keep mixing tools and jumping from one to another ... Day by Day search bar is to search attributes / measures (either the column names or the values). You don't display content you develop in OAC in Day by Day, you create new content on the fly by using the metadata (datamodel, sources) of OAC. So don't jump from a…

Did you manage to use Data Visualization Desktop? Create a data source (csv based or any other kind), create a project and define some visualizations there inside? If yes, then just do the same. OAC is like DVD, not really different. What does "but I'm unable to query this analysis on homepage to view the analysis" mean?…

I just want to know how can I deploy analysis on OAC server or is there some tool other than Data Visualization Desktop, that can be used to create and deploy OAC analysis. Did you try OAC itself? It comes with a full interface to develop analysis in 2 ways: either the old OBIEE Answer interface or the new Data…

Why do you want to use ML in your HR report? First thing is that there isn't a thing called "HR report", you can display a random number which is the headcount and that's already a HR report in a way. For ODV you better google that as there are various blog posts, videos both from Oracle and 3rd parties covering ODV. And…

"Please guide" ? Guide you to ... what? You used an Excel file as source, but your excel file isn't a dataset, it is a formatted file (containing at least a pivot but more probably something really formatted), right? That's not what a datasource is supposed to be, an Excel file used for DVD is more just a table, without…