See -> https://docs.oracle.com/javase/tutorial/essential/environment/paths.html You will need to restart your system / services post reboot.

See -> https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-15ED681D-DEE7-4AB4-A9B2-01A3A5F1757A.htm#BIESG1745

Try moving your question here ->

Hi Manoj, datetime includes time, so it is expecting; - So if you cast anything to datetime then it needs the 'extra' detail like this; - 2018/09/21 00:00:00 If you have have to compare dates to datetime, first of all my sympathies, but second make sure you convert them to be the same datatype first, never rely on implicit…

https://gianniceresa.com/2017/03/obiee-12c-agents-enable-them-by-code/

Hi, not as standard functionality no. Think about the logic of this, with bank holidays, etc etc - it would be difficult to say the least. But if you have the inclination you could build a very brief subject area that has a time dimension with 'LastWorkingDayFlag' and values to be set to 'Y' for all the appropriate days.…

Excerpt from the OBIEE documentation that I take it that you are alluding to; - "If your password column is in plain text (that is, if the result of the query supplied for the SQL Get Users Password column is not hashed or encrypted), select the Plaintext Password Enabled option. If the Plaintext Password Enabled option is…

If this is against Oracle DB then default date data type typically has default date format of DD-MON-YY i.e. '21-SEP-18' - have you tried this? The bottom line is that this will not work; - (and in IT relying on implicit conversion is never wise!!!) * ON T59551.END_DATE > '2018-09-17' * AND T59551.START_DATE <=…

Hi Dennis, I have not experienced this but just wanted to share a couple of thoughts - I suspect if it has been a month you might have already thought of these, but you never know. 1. Do the parameters have to be parameters? - if the URL is in the body of an analysis as a column - which I think is what you are describing -…

Have you tried experimenting with a known change(s) and varying to see if putting the changed file as 'original', 'modified' or 'current' to see if any variation works for you. It has been a while but I remember having to do similar and when I found the variation that did what I was looking for thinking it counter…

Sorry, one member banana from the bunch was missing. Personally - mude - no, never. Online mode - even more so, never! So practical compromise? Each person works on their own version of the rpd. We agree on some ground rules before hand to avoid clashes. When you have completed you deploy to dev and test it. When you have…

You forgot; - - is it wise to allow users to self-manage security - No - will it wind up in a mess which will take some rectifying by IT at a later date - Yes

Hi, see this for guidance => https://gerardnico.com/dat/obiee/obis/fact_table_baseline

Not sure if this applies to your version of OBIEE, but worth a try; - Workaround: 1) Edit an analysis on which the error is encountered. 2) Go to the advanced tab and on the Prefix section add: SET VARIABLE FILTER_METRIC_SPLITTING_LEVEL=1,DISABLE_PLAN_CACHE_HIT=1; 3) Apply the SQL. 4) Save the analysis 5) Rerun the…

p.s. recovering physical layer would not work as business model would not automatically recreate the mappings that it has lost. You would have to recreate the physical to logical mappings also - but as I said I would not recommend trying to recover it by rebuilding, go back to your back up, it is safer and worth losing any…

If you have a backup it should just be a case of revert to back up and go from there. Any other approach is to construct a potentially unknown position which may be error free but may not be correct.

Hi Joel, re: 'ideal solution' - I don't live in an ivory tower - but I do have the battle scars of sub-optimal solutions which invariably wind up costing more time and money in the long run, and can destroy the reputation of the BI solution in question.

"as the data will keep on growing" - maybe now is the time to take a step back and reconsider basing your reports off a large excel data source - I know some companies centre their BI solutions (sic) entirely around excel uploads, but excel; does not scale, does not tune, has no partitions, no indexes; should really only…

When you download to excel using the 'all combinations' option - how is it presented in excel~?

Hi, have you tried creating a report where there is a prompt area corresponding to your lower level and filtering the report based on your level1. Then download and select the all combinations option?