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…

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…