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?

Hi, For word clouds there must be an example in SampleApp using Oracle Database 12c functions (something they added in the 12c release and the highlighted the use in OBIEE SampleApp) or you can also use R to produce it. Both these 2 things are done at the time you open your analysis/dashboard page. Isn't that what you look…

Ah, interesting they suggest to hack their JAR as apparently it's one of the most illegal things ever Based on past past releases the client tool isn't patchable as there are few pieces of opatch but not the main files, so they just have to release a new one. But I guess they will just wait for the next release and in the…

Hi, Is the exported file a CSV? (or any kind of text file) Your characters looks like a UTF8 encoding issue, so if it's a text file use a text editor (not just notepad, something a bit more advanced, they all have encoding options) and save the file changing the encoding. There are chances it's enough to fix the issue.

What URL do they use to access? If I'm not wrong you can have the error because of a slash (or missing slash) like /analytics works while /analytics/ doesn't or the opposite ...

Hi @Jaco P. , You can actually fix the issue with your local Windows machine BI catalog manager by applying the same path you linked (the one you applied on the server). I just did it and it works fine Of course this isn't an official supported way, so backup any file you are going to edit before to edit them (or be ready…

It would be no fun if the name was perfectly readable The russian characters are just represented as UTF16 hexa characters, when you see # followed by 4 chars (0-9,a-f) it's a letter. For example one of your names has this: #043f = п #043b = л #0430 = а #043d = н #043e = о #0432 = в So it's " планов " something (plans?…

Yes, the query must be logged like any other query, that's why you can maybe find some hints there looking at what the server generate to try to find out the format.