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…

OBIEE 11.1.1.9 is so old I don't remember if it was already possible (and don't have an Admintool to see if the entry was there already in the menu). If you look at OBIEE tips and tricks: Using Apache Drill as a JDBC data source in OBIEE 12c there is an interesting piece: I will be experimenting with an approach based on a…

Hi, The link to the doc you posted is to connect from a 3rd party tool to the BI Server to run queries against the BI Server. If you said you already tested OCI and ODBC it sounds more like you want to use a JDBC driver as source inside the RPD, it's a totally different topic. So what direction are you looking for? JDBC as…

Mr. C wrote:Didn't know CentOS is certified with any Oracle soft, but I learn every day. Don't get me wrong: it isn't ! But you would be surprised by the number of people who take a certification matrix has a useless document and complain OBIEE 12c doesn't install on Windows 10 or Windows 7 (like the last one asking for…

Yes and no: adding a column? Sure. Displaying comments/notes users entered somewhere else and have been stored in a source and modelled accordingly with the business models? Yes. Adding a column where users add comments directly and save them in OBIEE isn't an out of the box feature. You would need a 3rd party tool like…

As we now all agreed it isn't possible, let's go back to the original need: Rai Qaiser Hussain wrote:...based on this Client Machine I have to select User Code and User Name.regards So the logic is: somebody login into OBIEE providing username/password (or a SSO token), once the login is performed the sessions variables…

Search & replace will not move anything, that's sure. When you move things, OBIEE doesn't update references. All the internal references between the various objects (pages, analysis, filters etc.) are full paths. With search & replace you can update all those references easily instead of having to manually update tons of…

In addition to what Christian said, even assuming you could have a prompt in the GUI setting a request variable, it still doesn't work. Luckily they forbid browser scripting languages like javascript to mess with the client on which they run and give away information. Would you be happy if any website could have access to…

You are looking at the wrong problem. You are trying to solve something which can't be solved because of OBIEE catalog not being a bunch of folders and files but an entity by itself. 3521884 wrote:My main concern is that if someone give me list of objects having the path listed as it is visible in GUI, how one can get the…