You'll need to paste the entire SQL statement which you can get from the obis1-query.log file. As the excerpt you provided doesn't contain all information needed to work out what the D901 or c2 aliases are. Also look at this and see if this is of any help - https://support.oracle.com/knowledge/Oracle%20Cloud/2324936_1.html

Ttake a look at @Christian Berg‘s blog to explain your issue. In a nutshell, OBIEE will only run properly on a server OS.

In addition to @Gianni Ceresa & @Christian Berg, you may want to consider revising your logic to be based off the user rather than the machine as has been explained above, you won't be able to get that information from OBIEE

Just do something along these lines: CASE WHEN COUNT(DISTINCT "Manager Flag" BY "Employer Number", "Year") =2 THEN 'Y' ELSE 'N' END Substitute Names that I've put with double quotes with the actual Presentation column names

You’ll need to use the datamodel.sh/cmd script located in your DOMAIN_HOME/bitools/bin directory. First step is to use the listconnectionpools parameter to generate a json file which lists your connection pools. 2nd step is to migrate your updated repository to this environment and finally to use the updateconnectiopools…

You can achieve this with a Pivot Table view but not in a Table view. You'll need to check the fields highlighted in the properties window in image below:

It's best practice (in my humble opinion) to have similar catalog structures in order to avoid these type of issues. There is no straightforward way to change the references. One way would be to modify everything manually and the other would be to do an XML search and replace in catalog manager (please backup your catalog…

You should consider the reporting capability of Catalog Manager - https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-FF29B794-97F5-4975-A924-ED40319B9150.htm#BIESG3785 It also has a CLI which you can put a script around to automate what you need from it. Under the bitools directory, run the following to get some…

What version of OBIEE? What OS? Which log files have you looked at? Has this worked previously? Is it a new installation? As you can see, there are many questions which need to be answered before you'll be able to get any meaningful assistance from here.

Can you see the path in catalog manager? Does the user have access to this path?

Again, which version of Windows OS?

Run ./runcat.sh -cmd report -help to see what the Catalog Manager CLI can do in terms of generating reports based on catalog content.

Wwhat version of OBIEE? What OS? Which log files have you looked at? What exact errors do you see in these log files?

Do you have an Order By Clause in your call to the LISTAGG function? Have you looked at this previous thread? - How To get Distinct Records using ListAgg function in OBIEE Report ?

Look at @Christian Berg‘s blog post. This will have all sorts of issues if you’re installing on a client OS. It needs to be on a Server OS.

I'm not surprised. OAC & DV are normally ahead of OBIEE in terms of features I'm afraid. With Oracle Analytics Server (OBIEE's replacement), this will no longer be the case where OAC, DV & OAS will have the same features.

Is this what you're after? - https://docs.oracle.com/en/middleware/bi/data-visualization-desktop/bidvd/apply-map-backgrounds-and-map-layers-enhance-v… The functionality in DVD and OBIEE DV is similar.

If the "factors" aren't facts, then they should be derived from a dimension as dimension attributes.

looks like your measure has 2 sources: distinct T45303.N_LIFETIME_PD & sum(T45303.N_EXPOSURE_AT_DEFAULT_RCY)

How many logical table sources do you have in your logical fact?