It isn't normal that in "online" mode you can't edit permissions, that's why I asked if you don't have a permission issue where your account isn't allowed to do that. In mine I can definitely change permission when online.

SJenkins wrote:online mode sees the roles and users, but of course your not allowed to make changes while online Why? Isn't it that you don't have the privileges? (so not using an account with enough permissions) Because online you can definitely make changes in permissions. And it's normal that when offline you don't see…

Honestly I don't see how the presentation cache could be shared is it makes OBIEE unusable. The presentation cache is personal, it's like browser cache in the end. When you see the wrong data with the user, what does the log tell you? The LSQL must be executed at least (the presentation cache doesn't even execute the LSQL…

Hi, You maybe want to look at OBIEE Samples which has some examples of custom javascript. OBIEE is a web app, so normal web things will with OBIEE as well, but OBIEE is a bit more complex than your standard web pages, so be careful on what you do and where you put your hands or do not complain if your system doesn't work…

Just for the records (and for the users looking for an answer in the thread): the correct answer is more the piece of doc @2715862 posted because "RTFM" is always a right answer

Hi, Do you really need to prompt for the currency? Can't you remove it as prompt and simply use it as condition in the analysis? A "dirty" workaround to cover this need would be to store in a variable (presentation variable) the value of the country, and then to match it by counting the number of commas "," you have inside…

I don't see any issue because even if the JAR collecting your metadata (RPD + catalog + security) wouldn't work you can still move the elements directly and migrating them on your 12c like the JAR would do. So you definitely don't have any link with the 32 or 64bit of your OS.

Changing the log level to 0 will only use a bit less disk, the space the log file took. Logging adding performance issues is a myth ... The load on your system highly depends on what your users does, the kind of model you have (if all the possible logic is pushed down to the database vs. having the BI server doing the job)…

First thing you still didn't say what version of OBIEE you are talking about, so you make it quite hard to give you useful answers! ( ) The presentation cache is personal, it isn't shared, so it can't be an issue. If it would be shared almost 90% of the OBIEE setup wouldn't work because it would destroy any security setup.…

That's not a supported usecase as things changed. The code is different (and can be different) and that's also why when moving from 11.1.1.7 to 11.1.1.9 you need to upgrade your catalog. If it's just for an object copy/paste of XML can be a way, trying to fix any mismatch in code.

If cache is off it is off, you can even set in the RPD the no cache info on each physical source object to make it even more "no". But you will anyway still have a browser / front-end caching. Cache off doesn't mean the analysis is executed again every time you refresh the page (in the same session), that's the front-end…

Hi, Did you try adding these things? Because if you create a prompt on your hierarchy and then in the analysis you add the hierarchy and say it is prompted it works. Don't you have a possible conflict in what you ask for? A prompt on time hierarchy but filter on last 6 months of data? Why don't you filter directly on the…

Just to be clear, you are both correct about the Direct Database Request (DDR) : it's in the RPD and in the front-end in manage privileges. It is simply 2 different kind of management ! In the RPD you set which connection pool accept DDR globally (the setting in the physical DB object) or by role (the permissions in "query…

You maybe want to read . So expose clearly your environment / version (detailed version including bundle patch), explain clearly what the case is. Because if you say you found the root cause being a filter in the report then change your filter, not sure what kind of other answer you expect ...

Can you try to exchange the 2 columns? So put the Y/N above and the date below? (just to check your rules are fine) Is the column with Y/N really useful on the screen or you just used to have a flag (Y or N) for the conditional formatting?

I assume you added that condition on the date column based on the value of the other column = 'Y' and it didn't work? Or I'm just not getting what you are asking for

Hi, Did you set that value in the file directly? Because, as the file says with "ENABLE = NO; # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control" this value is set by Enterprise Manager. So go in Enterprise Manager and turn off cache there.

Still, it isn't a LSQL valid query. Did you try, as suggested, to build the query as a report and then copy the LSQL? Do not get the filter in the analysis wrong: SQL expression doesn't mean physical SQL, it means LSQL expression. A valid LSQL is for example something like: SELECT "PC2"."Time"."Date" FROM "PC2" WHERE…

Did you give up on that one?

Hi, You have to set permissions on the column in the subject area. So you find the column in the presentation layer of the RPD, open the properties and there you find the permissions. Keep in mind that there "READ" win over "NO ACCESS", so if your user is also member of an application role giving him a "READ" permission he…