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.

You can also consider to create them in a way matching the requirements of sequence numbers for time dimensions: https://gianniceresa.com/2017/01/sequence-numbers-time-dimensions-new-obiee-12c/ In case you plan to maybe implement this at a later stage, the same columns can definitely be used to sort the months as well.

The style can be defined at the dashboard level by going into "dashboard properties".

If you got what you were looking for you can maybe close the thread? It will help others looking for the same or similar things. Right now it's still This question is Not Answered.

Hi, Create a "guest" user in OBIEE, triple check the permission you set to make sure it can't do anything unwanted (more or less no access to anything and not allowed to create any content) and use it by adding the username/password in the URL (avoiding OBIEE to prompt the user for it). So using the NQUser=<your guest…