A better reason for it is that a dataset is a very limited scope compared to a subject area: a dataset is a unique object, with a known and generally small number of columns (10-50). Statistics and correlation between columns can easily be calculated because it also uses the attribute vs measure logic to show a measure by…

Are you using a dataset or a subject area? Explain works on datasets, it isn't available on a subject area (as there you should already know everything about your data).

This tools is using OBIEE, but since it is a cloud product and I am only a user, i do not have access to the data model. OBIEE doesn't exist as "cloud product". There is Oracle Analytics Cloud (OAC) which is a cloud product. Or you using another product which has a old OBIEE embedded for analytics (like OTBI or Fusion).…

Hi, Are you using OBIEE? As you maybe know, OBIEE is delivered empty, no data, no models, no analysis. You are asking a "functional" question which is based on a model and a dataset. But you are the only one having that model and dataset, nobody else in here have it. Therefore it's just impossible to give you an answer if…

What you are after requires both sides as Christian said. The catalog doesn't tell you anything about usage but can only tell you if an object exists or not. On the other side UT only tells you about objects being requested, not if one exists or not. Combine both and you get the full picture. Just like Sample App 607 does…

The whole catalog is stored there in the BIPLATFORM schema. Don't have a DB accessible now, could maybe be the CSS_IS tables. Just remember: you aren't supposed to be there, SELECT isn't going to damage anything, but avoid changing things without using the official tools (catalog manager etc.). Everything is possible, the…

Hi, What exact version of OBIEE? And you did only what you described in your post? Because what you say is that you defined a variable, nothing else. OBIEE isn't going to magically use a variable for a filter or something if you don't tell it what to do, how and where.

Is that an installation of OBIEE 12c? Oracle product should not be started as root. The issue when starting as root is that some files on disk will get the wrong permissions (root!) and when started after with a less privileged user they can't be accessed anymore. Is it possible that you did perform the whole install as…

While not on the same patch and also not the same browser, DV for me stays into a single window. Any button is by default in the same tab, nothing open in a new tab. Did you try a different browser?

What WebLogic? What Linux? Part of which product? What install document did you follow?

Sort column is a RPD thing, in the front-end you don't have anything for that. You have the original date column, use that for sorting. If for whatever reason you can't use that one, just create a new one returning your day in a YYYY-MM-DD HH24:Mi:SS format and even if it's a varchar it can be used as sort column as it…

That's why Oracle explicitly wrote in the doc the meaning of deprecated and desupported. Because the very first version of the doc just said it was deprecated without saying it was still there. Oracle understood the "Act As" is an important feature and that many customers needed it. That's when they said that they will…

@User_Z12HD , If the date dimension exists and has a time hierarchy yes. If a time hierarchy isn't defined no. For a more precise reply, start a new thread explaining the whole context.

The integration with Fusion apps or EBS etc. is a special case. "Act As" is basically like it was in OBIEE 12.2.1.4 if I don't remember wrong, but you need to enable it first as it's disabled. There is a MOS document about it. And "Act As" really just works fine in OAS 5.5, the question is more for the future: what will…

The doc is very explicit: https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html#OASWD-GUID-C907A4B0-FAFD-4F54-905C-D6FCA519C262 And right above the meaning of "deprecated": Deprecated features won't be enhanced in the future but are supported for the full life of the Oracle Analytics…

If value 1 has a row for x and another row for y, I want to show it. If value 1 has only x I want to hide it. So why in the above example you say that you expect to see only rows where column A has values 1 and 3? Value 3 doesn't have a row for "x", and therefore doesn't match your "show it" rule. In what exact product…

Damn, I forgot that RANK is a RANK and not a DENSE_RANK. Dirty fix: use EVALUATE? If your source is a database, it must have a function doing ranking without skipping values in case of multiple with same ranking. That's what DENSE_RANK does in an Oracle Database.

You could try to cheat with a ranking function on the Record IDs and use that as condition? Same Record IDs is supposed to have the same ranking, and it always start with 1.

If you really want fixed colors you should look into conditional formatting, which will need to be set for all columns of your table view (even if using the same condition on "Record ID"). If you just want alternate colors between rows, you should have a checkbox to enable the "zebra pattern".

It's one or the other: you can't support multiple values if you want to keep only the first 14 chars. Your input is just a piece of text, it doesn't have any logical meaning for the tool.