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…

Sorry but I don't get what you are asking .... If you took paths from the filesystem, there are many other things which are different on disk than what you see in the GUI, not just "_filters" being nicely shown as "Subject Area Contents". So what is your concern with the real path of things in the catalog? How are you…

4104637 wrote:Thank you for your inputs.I am trying to approach it in a different way.Creating a folder directly under Root folder.I was wondering about the challenges with this approach.appreciate your inputs.Catalog Root--> New Folder(X1) Shared Folders System Folders User Folders.one of the concern is, it will be shown…

Mr. C wrote:> What OS?Linux 7.2 with 3.10 kernel Do you mind sharing the full name of the OS distro you used? Is that a RHEL? An Oracle Linux? A CentOs? There are many "7.2". What kind of install di you perform? GUI? Response file? I'm really trying to getter a better view of why you could have issues. I find OBIEE 12c to…

Different question: any specific reason for wanting to "change" that? When you start OBIEE with the start script you will have tons of "info" messages, but that's just what they are: informations. Because behind there are tons of things starting, each one will have some debug output about what happens and what the tool is…

As extension to Joel, if you look into Sample App 607 (https://www.oracle.com/middleware/technologies/obiee-samples-downloads.html ) you find some scripts and dashboard to display those information. If you really want to go down to the physical table, once you have the info from the catalog you also need to get the…

There would be a way, which I would highly suggest you will never adopt because you will regret it soon or late: create shortcuts I almost feel bad even just mentioning it. That would be a quick fix while you start doing the proper changed (as Joel said, manually or by search&replace). Do not keep shortcuts on the long…

I don't see why OBIEE would use a LTS knowing it doesn't have a column. Did you check all the content levels are set correctly?

You can set the priority group for LTS1 and LTS2 to make LTS2 a higher priority than LTS1. Priority group numbers rank your logical table sources in numeric order, with 0 being the highest-priority source. In your case you seem to want to use LTS2 when only A1, B1, C1, M1 are selected, and use LTS1 only when D1 is part of…

Hi, The 2 solutions are at different levels. OBIEE is the analytical platform itself: it comes out of the box empty. No database, no model, no analysis or dashboard. You can link various sources to it, model those sources into logical models and use the result to create your analysis and build your dashboard. It's really…

Programmer Analyst wrote:Talking to myself: Why does Oracle want to make it so complex? No wonder other BI tools are dominating now. Why is an enterprise analytical platform any different than Excel? The answer to your "why does Oracle make it complex" is as simple as defining the difference between a client application…

First thing first: what version of OBIEE are you talking about? Do you want the permissions associated with every analysis or do you want to resolve all the security dependencies and, for every single application role, get the list of all the analysis they are allowed to open? Because this is something totally different…

First, there isn't a "correct" way because there isn't really a wrong one. There also isn't a "best" way. Your database can be as you want, and it's generally not the BI defining it but more the DBAs and the security rules you have in place. I would say that a "not good" practice for me is creating synonyms to have all the…