Using UNION in analysis you prevent various things to work. Your column on which you click isn't "Category Dimension"."Category" anymore, it's a 'virtual' column which has been generated by the union of the 2 subqueries. I suspect that's the only reason why it stop working after you add the UNION. Navigation in OBIEE sends…

Hi If you export as CSV or tab delimited all the columns of the criteria of your analysis will be included. If you expert in Excel format it will be an export matching the view you saw on screen.

ForSly wrote:an aggregate fact table .... They are both at the same level of details. How is that even possible? An aggregated table, at least in OBIEE wording, is generally a fact table having less data by being at a less detailed level for one or many dimensions. Just like the other thread: you really have to post more…

Ah, that one. The checkboxes are into the dropdown list. You first have to enter a name for the key, once at least a letter is in the column "key name" on the next empty row, you can click on "Columns" and the dropdown icon appear and there you can open it and select the column(s) you need. The name generally comes…

Can you please make an extra effort in adding context to your question a bit more? What version of OBIEE, what is your "fact table" (is it a logical table, a physical table, anything else). I really don't see where there would be a list with checkboxes for keys (expect for logical levels keys to define which one is a…

Add to Christian's questions: 3.) Which part of OBIEE doesn't start? Admin server, managed server, all the components, some of them (BI Server, BIPS etc.) There are many more log files than the output of the start command. Just a detail: are you sure about your database config? 192.0.1.0 is a public IP address, not a…

user12018538 wrote:The server (11G release 11.1.1.7) is under SUN SOLARIS. The server installation was done in 2015 and can't migrate to the higher version. It's weird that in 2015 the choice has been for OBIEE 11.1.1.7 as 11.1.1.9 was already available and even the very first 12c was released in October 2015. Maybe it's…

Install Virtualbox on your Windows 10, create a VM using Windows 7 and install the 11.1.1.7 Client tools. This the the way to go for your need. You can't use 12c tools for an 11.1.1.7 server. Any RPD you save with a 12c Admin tool will never work on your 11g server, the BI Server will not start. Job manager works because…

"same settings" : you are trying to connect to an OBIEE 11.1.1.7 with the 12.2.1.0 Catalog Manager? Because it doesn't work like that ... Relax, take a step back and simply describe what you are trying to do because right now it's fairly confusing. You have a Windows 10 desktop/laptop/environment, you install the 12.2.1.0…

Hi, Are you sure about the problem? You say you can't launch (start) Catalog Manager, while your screenshot (in French) says it couldn't connect to the OBIEE server. In general you get that message after starting Catalog Manager and entering the details to connect to an online OBIEE server, but Catalog Manager doesn't seem…