If you look at the available functions in OBIEE there is a whole set about dates, including extracting components from a date. Just look in the UI and you will see the list of functions available.

In the RPD you should set the sort order column for your text month logical column. Pick a column which can be sorted correctly for months (like the month number or something like that) and use that one as sort column for the text versions of months.

I used "LIKE pattern" in prompts and created a presentation variable and used this as a filter with the same "LIKE Pattern" criteria in the filter.It is not working. And why it isn't working? What does the generated SQL query looks like? What should be different in that query to make it work? You are maybe just 1 step away…

Keeping in mind the known differences between OAC and OAS/OBIEE, it should work. Of course being all custom content/code, you have to try it to discover if you used something which is known to not be supported in OAC.

Hi, With a SQL filter you can write the filter condition you want.

Wrong category and you double posted in the correct one (https://community.oracle.com/tech/apps-infra/discussion/4482433/odi-12-2-1-4-problem-in-connect-with-odi-agent#latest). So you can close this one and let people of the ODI category use your other thread.

Turn it into a join of your table with the mapping manager-city to the cities dimension, in that way you can set the security on the manager column and the join between the 2 tables will automatically filter the cities even if they are millions.

Doesn't the documentation says to use 7-zip? Did you try with that? Did you check the the checksum of the 5 files, are they correct?

Conditional formatting is a row-level thing. Your logic is across multiple rows. You are back to the previous thread trying to "align" different rows.

How? That exact behaviour you describe will take you some HTML and JS and some time writing the required pieces of logic.

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?