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…

CURRENT_DATE = SYSDATE, so doing CURRENT_DATE-2 and CURRENT_DATE-3 you aren't getting there ... Stop thinking database, OBIEE is database agnostic, so use the OBIEE functions for the calculations on dates to have a chance it keeps working the day your source change and doesn't get anymore +/- on a date. SYSDATE 08:45 =…

Hi, Would help if next time you also provide some context and at least the tool you talk about. I assume it is OBIEE ... TIMESTAMPADD(SQL_TSI_MINUTE, 525, CAST(CURRENT_DATE as timestamp)) That's 8h45 AM of the current day. 525 = 60*8 + 45 CURRENT_DATE doesn't have any time component, it's only the date CURRENT_TIME(0)…

Is the "new" owner the same all the time everywhere in your system? Does it changes at the same time of the day all the time? Who is that guy, the new owner: any special role or function in the system / organization? In your screenshot it's probably inheritance, just like with permission where you can make all the objects…

Hi Sam, This limitation is new in 12c but it makes sense from a logical point of view. When you mix columns of different levels, using a column of the "day" level to sort one of the "month" for example you can have an issue from a logical (and practical) point of view because your month will have multiple days associated,…

Good start, but not exactly the right place You must not do this work on the "edit dashboard" page, because that one has spaces just to make it possible to structure the page by moving objects around etc. It's a "fake" view. Execute the real dashboard, with the real analysis inside, and do the same. Also a detail: do not…

You are welcome! Please come back once done to close the thread if it worked, so others with the same questions will find useful information easily.

Just a note for the OP: if you create users even just to send content via agents ... you need licenses for all these users

Helan Kumar wrote:nothing wrong with the downloads, my downloaded files are here Nothing wrong? Really? It's 2 screenshots you posted that show what I said: your files have the wrong names!!!! If they would be named *.001, *.002 etc and not like now *.001.zip , *.002.zip etc Windows wouldn't assign them an icon of an…