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…

Using SampleAppLite is generally a simple quick way to make sure your install works. If you load your whole OBIA content and OBIEE doesn't start or you have other issues (at the product level), it will be difficult to know if it's your install having a problem or your OBIA content broke it. With SampleAppLite you have a…

Can you please avoid double posting? It's against the forum rules and double posting generally lead to less replies and more abandoned threads.OBIEE 12.2.1.4.0 installation uploading jar file from biapps project Pick one, stick to it and close the other. OBIEE 12.2.1.4.0 installation uploading jar file from biapps project

For some obvious reasons you don't really want to embed something delivered directly from OBIEE in your website. Just because your OBIEE will be hacked or taken down in 10 minutes. I also doubt you want to run a query on OBIEE for every single user on your website, your analysis is probably a daily or hourly or whatever…

OBIEE has webservices which allows you to execute a logical query against the BI Server and get your data (so not even need to go via a SFTP: the app can come and query OBIEE directly). You can also connect by ODBC or JDBC to the BI Server and execute logical queries directly. If you look at the doc they cover most of…

It is just next to the CSV export. The same limits as CSV applies, a tab separated export is just like CSV: not based on views because it can only contains data. It's based on the dataset retrieved from the criteria of the analysis. As there isn't any human who is going to really read a CSV or tab separated export, it…

As said CSV is purely data. It simply has columns headers and that's it. Even doing a dirty UNION to add a row from another query, it would be in the file as 2nd line. The first line is and will always be the column heading. That's what CSV is for: just the dataset split in columns with the column headers. The idea of a…

The Excel and PDF export are exports based on the "views", based on the visualization of the analysis. The CSV export is based on the criteria, it exports the dataset the analysis get from executing the request but doesn't care at all about the visualization (because CSV can only contain data). So all the titles or headers…

2 random questions: why do you want to use the admin tool remotely when you have it locally? The fun thing is that the admin tool doesn't seem to be certified on Windows server (because it's a client tool, so they certified it for client OS only) Any particular reason to use that folder? Deploying a RPD in 12c isn't…

There have been multiple threads on this topic. If you set the prompt as auto-submit as soon as you pick a value for the first one the page reload and the variable exists. So you can use it in the second query. Just make sure to manage default values correctly so that the second query still work with or without variable…

One checkbox in the "emp" column prompt: "Limit values by"

Hi Michel, First a little detail: could you edit your post and delete the part with the content of the MOS document? This forum being public it's forbidden to post any content coming from MOS (which is a paid support). If you want to freely be able to post content of MOS documents you would have to move the thread in…

Sorry but ... it's a bit confusing. You say that the default behaviour you aren't happy with it, but when you protect the filters you say it doesn't work as the default behaviour anymore and you are, once again, not happy with it. What do you really want? Do you want your analysis to display ONLY the selected year when you…

I see it as 2 different things: certifications vs product development. Certifying the "old" product with new versions of either OS or single components is one thing. It's the only possible way for the product to not have to be uninstalled (as you would have to run it on a server with a old OS which run out of support…

As far as I know OBIA 7.9.6.4 has no direction. It will not go anywhere else. New OBIA is focused on ODI (which make sense: supporting a 3rd party ETL vs an internal one, it's clear the direction). I don't work for Oracle, so this just my own personal opinion I imagine it isn't going to go anywhere and you will be able to…