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.

c'mon Gianni, you are better than that :P Of course I am, but I'm supposed to write that thing from time to time 😅 For the catalog search, I would say you have to do it in offline mode. Because the info of the "homepage" is stored into user's folders and in online mode you have the security preventing you access there…

S_NQ_ERR_MSG doesn't mean all it contains is an error, it could just be a log.

The S_NQ_JOB are created by default when you run the RCU to install the product. There isn't anything to configure, they exists. Look into your BIPLATFORM schema in the database.

The tables didn't move. Still the S_NQ_JOB and other few tables there around. Just keep in mind that most of the attributes of agents are still just inside the agent itself (the XML file saved in the catalog).

Well, you aren't supposed to point to a missing page. It's just the equivalent of a HTTP-404. You could consider adapting your development process to not remove dashboards but just change their content instead. As you said, you can add a piece of JS to the dashboard page to point somewhere else. And you can also consider…

Sorry to ask but: do you know how to use OBIEE? Having a physical table defined in the RPD doesn't mean you don't have to change the RPD. It all depends on how you want to do things. If all you are after is just "SELECT * FROM ...", why don't you do a direct database requests? Not really using anything OBIEE can do, but if…

I don't have examples, but you can find some inside the SampleApp. It's OBIEE: dashboards are built like everything else in OBIEE. Aren't you using the tool for some kind of analysis? It will be the same exact job, except that instead of using a subject area about sales, stocks, HR or whatever else you do, it will be usage…

Hi, Just to make sure about the product: you are asking for Oracle APEX? Because you posted in the OBIEE/OAS category, but don't provide any hint about OBIEE or its version... If you really mean Oracle APEX it isn't a problem, a MOD will move the thread in the right place so the APEX experts can look into it.

OBIEE is exactly built for that job: query tables based on a model you provide and build dashboards on top. In previous OBIEE versions there was an RPD provided with a small model built on top of usage tracking tables, try to look into your own install to see if you find that RPD or a BAR for it. You could also look into…

One single RPD can contain many physical sources, many business models, many subject areas. But they all need to be into the same RPD. OBIEE use a single RPD: when you upload one, any existing models not part of the new RPD will disappear.