There is (luckily) an easy way. From the classical home you go in Administration > Issue SQL, from the data visualization one you go in Console > Issue SQL (it's the same page). The SQL you execute is: call GetOBISVersion();

Hi, As OAC is quite "wide" and contains few different products inside, do you mean in a data visualization project? And by "errors seen in my visualization" is that a reference to business errors? Like if you are showing sales of products and one is missing or it is a wrong number? Or "technical" errors like if you…

Interesting situation: either slow but running queries on your database live or fast but cache side effects. Could "Refresh Data" be a solution? I don't really use cached sources, so never tested it, but in classical OBIEE it's the way to force the system sending a query to the BI server instead of just using the front-end…

Keep applying updates when they are available for that instance. I tested in a new release preview and it is fixed, you will be able to use the expression filter without the error.

Bonjour Christian, Just to be sure I get the whole picture: you are using Data Visualization Desktop and have Oracle 18c XE installed on Windows on the same PC/laptop (or another one in the same network which can be joined just by its host name). Right? Just to give it a try on my side to see how it looks like, knowing…

Are you sure about the settings you entered? I believe 18c XE is installed by default as a pluggable database, and "XE" is the CDB, not the PDB (at least based on some default 18c XE installs I have around). The PDB is called "XEPDB1" by default (if not wrong), but you can anyway check that in your own database to make…

If you go in "Analytics" you will see a list of the instance you currently have. Click on the instance name representing the one you are using and there you must see the version.

It seems to work like a RANK function in the database and not DENSE_RANK. This is at least what I saw based on a quick test earlier.

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