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…

select "Other Table"."Other Column Date" from "Other Table" where ID = {ID_variable} This isn't a valid LSQL, ID isn't a reference to a column and {ID_variable} isn't a reference to a variable. Fix your syntax and you will have more chances. Actually you better build an analysis which represent the subquery, copy the LSQL…

Actually the most important question is: does it work? You ask because OBIEE doesn't start or work fine anymore or just to find out because you saw the timestamp of the file changed or something like that?

Weblogic can definitely be the one doing things in that file. But it isn't a file you are supposed to touch by hand, so ... no need to care about it. It is updated if you do something in weblogic requiring to write there inside, but it's managed by the system itself.

Hi, https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG253 You can use agents, use your ETL process, use crontab. All these options allow you to schedule the jobs and make it automatically based on your strategy. So depends on what cache management strategy you decide to adopt.

If you connect directly to weblogic does the HTTPS one works? If it doesn't it isn't IIS in front which will fix it and you have to first debug that. If you then want to have IIS connecting to weblogic over HTTPS you maybe have to make sure IIS accept the SSL cert used by weblogic as a valid one.

MDS-XML is an alternative format for the RPD, where the RPD is saved as a ton of XML files instead of a single binary file. So to go from the MDS XML back to a RPD file you can just open with the Admin tool the MDS XML version and then save it back as .rpd . There is also a command line way to make the job, but doing it…

Just apply De Morgan's laws : you want a NOT(A=0 AND B=0 etc), so the filter is A<>0 OR B<>0 etc. Build a filter with all your columns in that way (with <> 0 and OR between the conditions), if the row is only 0 it isn't returned.

Depends on what your columns composing the rows are. Are they independent measures? If yes => add a filter to not select when they are all zeros.