Sorry but if you have the analysis reference (which you have) you can't really go to a lower level, that's the same as LSQL hash in the end (you of course cover changes to the analysis somewhere else). 1 analysis = 1 LSQL = 1 LSQL hash 1 analysis = 1 absolute path to that analysis If you copy that analysis in 2 different…

Hi, They are different kind of things. "bi_server1" is a managed server of Weblogic. The AdminServer control it and weblogic can have many (or even none) managed servers. It is an application server where java apps can be deployed. The services are components running on your server and they are really the heart of OBIEE.…

Hi, Do you look for a solution in OBIEE or in general in your DB? OBIEE can definitely manage your 7 tables and query them all together (defining 7 LTS for your logical table) or you can just "unify" them at the DB level. The simplest way is a view. I would avoid an opaque view in OBIEE as that's really hiding logic.

The SampleApp just take the one based on the same OBIEE version you are using (11g or 12c), so you can easily copy/paste things and reuse them directly. For your 2 tables I don't see a problem if you have 52k items in one and 33k in the other, they are not supposed to be the same as they are something else. Also keep in…

Hi, If you look into OBIEE Samples there is an example of this impact analysis (column/subject area <-> analysis, prompt etc.). They also provide scripts to get the data and load them and of course you have the RPD model and the web catalog objects. If you want to do it with what you have of course you can't join at the…

What Christian said ... In other words: it's not OBIEE that must do something, it's the browser which must be able to understand the link and open the required app. In OBIEE all you have to do is to create links (like web links) by editing the formula or setting a custom format on the column format (or both if you need).

The OP wrote: saketsrv wrote:I have recently configured obi 12c application ver. 12.21.2.0 There is no opmnctl anymore in 12c, everything is done via the bitools/bin/status.sh command.

Hi, no config for that part, it's just there and work by itself ... Difficult to say based on what it build it as OBIEE has all the info of what people open or not, so it's some internal cooking.

Honestly it's more the data (the way you described it) looking like it's not proper. But as said you can still make it work (I gave an example of the kind of join you can try), but as said: poor performance, possible wrong behaviour (like 101 also joining to 1015 because of the 101% kind of join). The fact table with…

Hi, Your question is a database question (Oracle Text isn't OBIEE but DB). What sounds strange is why are you supposed to install it by hand, I don't remember having to do anything extra other than installing 11gR2 for an OBIEE 11g install. So what kind of database did you install? (detailed version)

Hi, dumb question but: do you see anything else in the UT table? Because it's not something you can configure: everything or nothing, so the kind of analysis (if a chart or a table) doesn't change from a usage tracking point of view.

Hi, OBIEE ideally works on a dimensional model with 1 or many facts rows pointing to one attribute. In your case you already have 1 fact pointing to many attributes (so you just reversed the logical relationship). I would highly suggest you normalize your data and use real primary key = foreign key relationship (at least…

Hi @user1254883 , Can you please post what you are exactly doing now? You started with an OBIEE 12c install on Windows 7 and now moved back to installing OBIEE 11g? (which at least is certified for development only on Windows 7) Because you are "hijacking" your own thread and people answer based on OBIEE 12c while this…

What Ahmad said, in OBIEE you can't add a custom visualization to the list of available views. In Data Visualization Desktop (and by extension Data Visualization or the old name Visual Analyzer) there is a concept of "plugins" which are visualizations based on javascript libraries. But there is a SDK mode in DVD to develop…

Hi, In general for these averages you can do it by summing the number of sickness days and divide by the total number of employees etc. So you generally use measures with calculations in the "Derived from existing columns using an expression" field as it's a post-aggregation calculation, instead of "Derived from physical…

If you have an Essbase cube have a look at OBIEE Samples , they have some examples about how to write values to the cube and how to execute a calc script from OBIEE. The only "issue" you will have to manage is that the calc script run independently and the code you use to execute it will tell it started but then it's up to…

Hi, Google is the best place to find out what a "what-if analysis" is. For example that's how Microsoft define it for Excel: What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. So what kind of what-if analysis are you supposed to…

Hi, It's perfectly fine to use a key / foreign key as measure, and actually what you want to do is the main usage of keys / foreign keys in a fact table : count occurrences of things. Now the question is more the relation between SALES_ORDER_NUMBER and SALES_ORDER_KEY : if this relationship isn't 1-to-1 then your measure…

Hi, Maybe would be better if make some prompts mandatory or at least set default values for some of your prompts as apparently by default there is little or no filter and so you return too many data and exceeding the maximum allowed number. You can of course increase these limits in the configuration of OBIEE, but it's…

You can actually do it in 2 way: editing the formula as suggest or defining a custom format for your column.