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…

Hi, Web access is in a way Weblogic ... You will need both access to the AdminServer port and the bi_server1 managed server (by default 9500 and 9502). But yes, in general you will manage to do all you need with that list of access. (You can even remove Essbase if you don't plan to use it for now as well as javahost if you…

https://docs.oracle.com/middleware/1221/biee/BIEMG/datasource.htm#BIEMG4679

Do you have an ODBC driver and an ODBC connection pointing to your sharepoint list? Do you have a JDBC driver? If you don't have any of these ... OBIEE can't really help you: it needs a source it can connect to, and in general "exotic" sources uses ODBC.

The out of the box styles are deployed from ORACLE_HOME/bi/bifoundation/jee/analytics.ear . So you learnt a good lesson: never mess with the default styles, create your own custom style if you want to customize things ! That's the official way to customize the UI in OBIEE, it takes 5-10 minutes and avoid that kind of…

What are you asking exactly? Because you have these files (the original one), so I don't really see what you are asking for ... I can imagine you customized them without following the correct process of a custom style, so go to the source and get them from the EAR from where they come from and do not touch them anymore but…

Open the Selection Steps panel and delete it there.

Your files are named wrong!!! Look at the original files on the webpage, look at the file names in the Deployment Guide and look at your files : yours have the wrong names. Files are named *.001 , *.002, *.003, *.004, *.005 while yours are *.001.zip, *.002.zip etc. Display the real extension of your files in your Windows…

Hi, "Public holiday" already don't mean a lot as your public holiday are different than mine and each place has its own. So you can easily imagine a tool, which job is to do analysis and reports in an agnostic way, has no idea of what a public holiday is. This must come from your data, or of course you can add by hand…

Open the developer toolbar of you browser and analyse the HTML code to find out the source of the spacing. I would say you will always have a space, even if just 1-2 pixels because different tags. So it will require some nice CSS work (and the developer toolbar let you test "live" the CSS you will need to use).

anything with a / will generate an error "division by zero". In general people ask how to make NULL a 0. In this case the "less worse" crossing my mind is really a CASE WHEN "...." = 0 THEN NULL ELSE "...." END.

The good point is that you managed to confirm the issue happen also when running the query directly on the DB side, so in a way it isn't OBIEE's fault (at least this time ). (English below) Beh, purtroppo tutto dipende da come la tabella è fatta, dal database, dai parametri, dalle dimensioni, indici o meno etc. Visto che…

I would definitely prefer the format mask approach, but it requires to first transform the 0 into NULL. Actually a CASE WHEN to make the 0 a NULL and then using the format mask would be the cleaner approach I guess ... (mainly because the column stays a number). I just generally do not like these kind of things as 0 and…