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…

If you look for rules they are available easily in the FAQ: I would say the main one to check is and . The rule to not double (actually you did a triple) posting is because of everybody does this place will be a useless mess. The idea is to be helpful not for the individual but for the community (and the individual asking…

Aren't your technical reasons that you didn't setup content level correctly to define the conformed dimensions etc. ? Because if you think at your need from a row point of view you see that there is something that can't work: you want colA from an analysis next to colB from another one, but things are put one next to each…

First: does it still make sense to reply to this thread and try to give you hints if you just don't care and open new thread with the same question? How to retrieve a value based on a month selected by the user in Analytics I already wrote it once! You can't modify the value selected before to store it in a variable, so…

Your use case make much sense now, and it's where we were going... You just have to change a bit the order of your actions as it's not exactly how you imagine it: 3350649 wrote:for example. when a user select a month, in this case, January = 01/31/2017, or February = 02/28/2017, internally I want to convert this month to…

Hi, Again I believe you just missed part of my answer as it still apply .... You add a prompt, in your prompt instead of column prompt you select variable prompt and a presentation variable is more than enough. Then you have a query: the idea of OBIEE is not to write SQL but to model things and let OBIEE generate the…

Hi, Are you looking to use a presentation variable as filter condition in your analysis? Not sure why you talk about repository variable as it's probably the last option ... You add a prompt on your page, ideally the prompt just select a value from your time dimension so you avoid all the issues of formats etc. and all the…

Don't you have the "abbreviate" option to set to "none" in 11g? (I don't have an 11g available to test directly ...) I guess it was already there ... If not: what exact version of 11g?