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…

Good point the LSQL to get your values isn't the most obvious one ... I have some "dirty" ways crossing my mind for now but I prefer to find something a bit more clean before to post it ... Let's see if others are also inspired

Hi Eimis, Breath in, breat out (and do it few more times ). There isn't anything wrong in asking something you searched and you aren't sure about. But ... If you look again (it's not my document, Timo wrote it, you "met" him on one of your duplicated thread yesterday). Really try to keep in mind the 10 points listed there.…

dileraco wrote:What do you suggest us to solve this problem in the best way? Not at all ... Right now you don't know what the problem is and the suggest approach is a way to identify the problem so that you can look for the best solution. Also following the reply from Sherry George: do you see something in the logs? More…

So you are using the latest possible version of Firefox, and as Chrome stopped working with OBIEE 11.1.1.7 until a bundle patch fixed the problem during an upgrade it can definitely be the case here as well. Ideally find another browser and test with that one (IE11 also has issues with your version and I guess the fix was…

Souvik Sarkar wrote:Adding columns would increase the no. of columns in Total after field as well, how do I control that? I do not have direct control over the Total columns individually. If you create independent measures for everything your totals will also be the same: you will have to create them by hand as columns…

Hi, Your requirement is understandable, but what are you asking exactly? Which part couldn't you manage to do? What have you tested and tried so far?

Hi Dilek, Isn't your browser the problem? 11.1.1.7.140114 is quite a old one and has issues with new browsers (just because the browser has been released 3+ years after OBIEE and changed the way it manage CSS / JS etc.). So what browser are you using when having issues? Do you allow auto-update of the browser? Did someone…

That's what I said: if you want your design you must forget attributes and make everything measures. (go back to Christian's comment : attributes and measures act in a different way in the pivot view) If you create measures for everything is the way to get the closest to your requirement (closest <> exactly the same).…

Hi, As you saw the pivot view can do some nice things but follow a simple rule: always there or never there. So if you have 6 columns per quarter (your 4 + 2 calculated) they will be there all the time for all the quarters. Your quarters is an attribute and so all the measures are replicated for each quarter. An…

Not really, a presentation variable can be set by using the "SET" syntax in LSQL and most frequently by prompts. OBIEE 10G/11G - How to set a presentation variable ? [Gerardnico] (first result in Google for "obiee+set+presentation+variable") Eimis Pacheco wrote:Apart from this, How can I filter this direct database request…

Did you check the documentation about variables? Using Variables in the Oracle BI Repository A repository variable has a single value at any point in time. There are two types of repository variables: static and dynamic. The important thing here isn't the static or dynamic but the first one: a repository variable has a…

Hi, The way to model degenerated dimensions didn't change between 11g and 12c, so it's supposed to work just fine. As I don't know the nQS error code by heart (and I hope to continue like that ), what is the text coming with "nQSError: 43113"? If you just try without adding the hierarchy same issues or it works? (not…

Hi Ibag, No luck they are all gone ... They stopped AWS images, they moved to OAC but there isn't a real SampleApp image somewhere for now (they are probably working on moving content from SA to an OAC instance or things like that). So for now it's your own local virtual machine or an image you host yourself somewhere. Not…