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.

Actually the first option posted by @Robert Angel is probably what you need. Action link accept parameters only in the query part of a url (so it means after a ?, so your target must have be able to understand the parameter like if you call http://mstg/Store/?uscode=1400007 ). OBIEE refuse parameters as part of the URL…

Just in case give a try to OBIEE 11.1.1.9 with your version of Firefox (you can just use OBIEE Samples V506 for a quick test). As OBIEE 11.1.1.9 is older than Firefox 52 you can't 100% exclude the issue will not happen again But the decision to upgrade will definitely bring you the additional benefit of having a current…

Souvik Sarkar wrote:Any other workaround? As said: no. Because attributes vs. measures and the measures will always be repeated for every single attribute. That's how the pivot view work in OBIEE.

Will already give you few bits of the possible solution ... You get the global idea: you set a variable in the first prompt and use it in the LSQL populating the second. The issue is that query you are trying to write, there are 2 things it must do: - limit periods for the same financial year of the period selected in…

Eimis Pacheco wrote:Well, I understood that the tool Analytics does not allow me to do what I was asking for, but you answered my question.So, how can I convey that Analytics does not allow us to do what I wanted as I asked for, in this community tool? You do that by marking the replies as "correct" or "helpful" :…

Good you got what you looked for. So like the other, would be cool if you can close the thread as that's what actually help others (as they generally are close because provided a useful information). For now it is This question is Not Answered.