You did tag "HCM" and your question seems to be more about data than about a BIP report. Is your question about Fusion HCM Analytics? If it is, it will be moved in that category. If it's about another product, if you provide the full name we could maybe point you in the direction of the right place where to ask.

Didn't you get an answer to your question? You marked the thread as answered with an accepted answer. Also, keep in mind that a forum doesn't replace Oracle Support: if you don't get what you need from a public, community, forum you can always raise an SR.

Hi Jean-Pierre, Is that simple datasets in DV or you are doing the work via the RPD? As you talk about "fact table", I assume there is the RPD (Semantic Model) somewhere. If you add a measure being a MIN() and another being a MAX() on your date, you can then have a derived column being the difference between the 2. If you…

As you have SQL Developer on the same host, is that a Windows OS? (I assume you are using a certified OS, right?) What version of OAS are you installing? Did you try with the graphical interface of the RCU just to work on your connection details? The RCU in silent mode can be a bit "picky" on how your provide the password…

How can I check for firewalls? You don't need to do it... You said you have SQL Developer on the host where you are running the RCU comment (and I assume you aren't connected remotely somewhere else to run the RCU but it's really executed locally) and you can connect to your ATB database just fine.

By "actionable action" you mean catalog permissions? (update = write permission, move = write and delete permission, delete = delete permission etc.) If that's what you are after, you could try with catalog manager, it should be able to generate a report with that (no idea if OTBI supports catalog manager, I don't have…

@User_LJI8A , Your question has been moved to the OTBI category, no need to do anything on your side.

@SiddharthDang-Oracle , The question has been moved to the "Oracle Analytics Publisher (BIP)" category, no need to do anything else on your side. So now this forum should provide support for a BIP question ;-)

If you look for a IF ELSE logic, there isn’t one. Presentation variables can display a default value if the variable isn’t set: @{variableName}{<default>} @{PV_Department}{‘No department selected’} Write a default value that says it isn’t set. Because the static text field isn’t setting variables but just displaying their…

Any way to not show filters? Not really, because they are indeed filters (there aren't different kind of filters: they are just all filters...). The default Filter view shows all the filters for the analysis, it's an easy, simple, automated way to have a view of the filters. Anything else is a DIY solution: you have to…

What version are you using? In my screenshot it was just a simple example of an analysis without any filter but with some inline prompts. The filters view automatically show the values selected in the inline prompts. Did you look at the preview of your analysis? Because while you are editing, the inline prompts do not…

You can add the filters view in your analysis between the title and the table.

Please don't double post.

An understanding of ... what? OAS contains Publisher by default, that's it.

Let's agree to disagree... In a forum (like this one), it is similar to a double posting: doesn't bring anything useful other than increasing artificially the count of posts. (And this is why since forever double posting is a forbidden thing in the world of forums.) For example: what if a discussion with some useful…

You should coordinate posting with @Vinithra B-Oracle , you both seem to post the same exact things in these last weeks, just few days apart... https://community.oracle.com/products/oracleanalytics/discussion/20450/addressing-authentication-errors-nqserror-75006-with-oci-smtp-server-in-oac#latest

@User_RS68A , What do you call ODV? Oracle Analytics Desktop (the standalone desktop application)? Or the DV interface in OAS or OAC?

I didn't say to post a new idea, but a new question: it's a forum, it contains mostly questions... So, who can says what the original poster was trying to achieve? The 2 screenshot shows that everything works as expected. As an alternative, @Rose Decker feel free to provide all the details in here: what you are doing, how,…

@Sameer Wagh-Oracle , Would you mind creating a new question with all the details? (product name, version, what you are doing, how you are doing it and what you expect as result) This thread was abandoned by the author...

Hi, Could you please provide the full name and version of the product you are asking about? There isn't an OBIEE 19c, therefore it quite tricky to guess what part of the product (assuming it is the Oracle Analytics family) you are asking about: "classic" dashboard/analysis, DV workbooks, Publisher?