Other "trick" is to expand it in the left-panel when you can select columns to add to your analysis and then edit the formula of your column and move the edit window enough on the right to still see in the background the expanded hierarchy so you clearly see the names of the levels (table name, hierarchy name, level name).

Hi, Soheil Star wrote:I wanna simply import "Country" Table from SH (Oracle sample) databasI created new Data source with "DataDirect 7.1.4 Oracle Wire Protocol" driver in odbc application to use it in "Select DataSource" phase. Why? Why ODBC? There isn't anything worse than a ODBC connection for an Oracle database, and…

There isn't any web-based tool for that. Admin tool is the official supported way to do that, so yes: install it locally and do the changes.

Hi, A bit vague as question ... For sure the Admin Tool is the official way of doing things. There can be other ways depending on what exactly you want to do (by command line there are some ways) and last but not least could also use a NQS call but ... I would avoid that one except if you want to test your backup/restore…

Nice that you manage to solve it So can you maybe do a last "administrative" thing ? Mark your "solution" as the correct one which will mark the thread as answered? Right now it's still This question is Not Answered.

Nope, you can't upgrade ODI, for that you will need to wait the next major release of OBIA (no idea what kind of release date to expect). As OBIEE only display things it's kind of independent and that's why you can upgrade it with no problem (and still have a certified system). ODI is really the heart of your OBIA and so…

Hi, You can't install directly in 12c because the content (rpd & catalog) is installed for 11g. Changing from 11g to 12c isn't like adding a patch, it's a real upgrade, rpd and catalog need to be upgraded as well. That's why you can upgrade after installing on 11.1.1.9 but can't skip that step until a native obiee 12c OBIA…

user4109719 wrote:I have an analysis that navigates to another analysis in the dashboard in OBIEE 11g. There are 3 values that need to be passed from the first analysis to the second. Two of the filtered column values are equal to column values from the first table. I used "is based on on results of another analysis" for…

+1 to Christian with analyticsRes: it will works fine as it's served from the same domain as OBIEE (=> no CSP). In case you need details it's here: https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/

Hi Marco, If images comes from a different domain than OBIEE you are hitting the CSP security (Content Security Policy). It's a protection not loading objects from other domains to avoid XSS & co. You find details on how to whitelist your domain to allow to load the images in the doc:…

Hi, The admin tool is more supposed to be used on a client than on the server, so you can of course just install it on your workstation/laptop and connect to your server. You can also check if you have the files installed and just the shortcuts are missing, in that case create the shortcuts yourself and done ...

You know that searching the forum would take less time than writing a post? Same topic 3 times per week in the last 2 months ... https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

Isn't this the exact same thing as getting error while installing OBIA 11g you posted 4 days ago? Please avoid double posting: the result is 2 threads with their own life which will probably not get any follow up ...

Great decision Dimensions is really something making the difference in OBIEE and the analysis you can do, and I'm sure the benefits of this dimensions (with the 2 levels) will easily compensate the extra work now to create it.

PavankDatti wrote:you would have create fake join here between D1 and F2 and map to Total Level No, a fake join is useless, content levels exist for something. And if with "fake join" you think at a 1=1 I don't believe you really want a cartesian product between a fact with millions of rows and a dimensions that can easily…

First thing: conformed dimension. I hope all your dims are confirmed or I would ask you what they do there if nobody confirmed they want these dims. 3231180 wrote:my question is without throwing any error here Is that a test? What do we win if we answer right without having anything as input? I would bet on a wrong…

The "Implicit Fact Column" is defined by opening the properties of the subject area in the RPD. As said only one column can be defined as implicit per subject area. So you must manage to identify a measure being the most generic as possible.

The question was more about what kind of source you wanted to use to point you in the best direction (like OCI instead of ODBC if Oracle etc.). But you fixed, so enjoy

What is your "External Source" ?

Based on https://community.oracle.com/docs/DOC-891037#jive_content_id_1322_Helpful_and_Correct_ you must have a button to mark an answer as correct and this will also flag the thread as solved/answered.