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.

So, based on what the FAQ and OTN rules suggest, you can maybe close the thread? For now it's still This question is Not Answered.

Gianni Ceresa wrote:But it's not something like "take the result of this query, select the value of this column in the first row (or unique row) and assign it to the session/request variable". that's why ... You can't.

As said the answer is to model it in the RPD via a lookup table (or at least have the table with the exchange rate available). As apparently you can't touch the RPD (but then what's the point of having to do a job if you can't do it the way it's supposed to be done?), something that was also posted earlier in the thread is…

You can, in a way, set it using a variable (so using a variable to set a variable), look at this: OBIEE - How and where can I set a Request variable (SET VARIABLE) ? [Gerardnico] But it's not something like "take the result of this query, select the value of this column in the first row (or unique row) and assign it to the…

Yes, it's not a system one. You set it from a prompt, that's why I gave the "second name" also : in the prompt they call it a request variable. But it's just a session variable in the RPD: OBIEE - How to set a server variable with the session type via a dashboard prompt (with a request variable) ? [Gerardnic…

You can get values from the front-end back in the RPD, but not using a repository variable. It will be a session variable (also called request variable sometime) and you allow everybody to set it's value. In that case the user can assign a value to this session variable and it's available in the RPD (in columns formulas,…

From "Business Intelligence" you go to "Subspaces", there you go to "Business Intelligence Foundation" and then into "Business Intelligence Suite Enterprise Edition (OBIEE)". Or just click here: Do not underestimate the number of people joining this forum with a query and asking "how do I make this one work in OBIEE" ? So…