Friday, December 13, 2013

Month Start Date in OBIEE 11g

We have the common need for Year Start Date, Month Start Date  and Week Start Date when we are working in OBIEE 11g. This is a basic need when we are working with measures like forecasting and lags.

The below are the codes which we can directly use to get the different dates from the date available.

For instance i'm taking the system date ........CURRENT_DATE
Year Start Date :

        TIMESTAMPADD(SQL_TSI_DAY,-       (DAYOFYEAR(CURRENT_DATE)-1),CURRENT_DATE)

Month Start Date :

       TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFMONTH(CURRENT_DATE)-1),CURRENT_DATE)

Week Start Date :

      TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFWEEK(CURRENT_DATE)-1),CURRENT_DATE)


By at No comments:
Labels: , , , , ,

Wednesday, December 11, 2013

Pop Up Message in OBIEE 11g

Popup is a general thing for us as we see a several popup messages coming when we are browsing over the net . This is a general way of advertising by not disturbing the base page. We can even say it as information window where it will display a window with a proper message.

Even we can use the same popup to show information on OBIEE dashboards. This might come handy if you want to display a general information about a dashboard page.

For instance lets consider a scenario of a Company having the Sales Dashboard for "Late Orders".

The Late Orders dashboard does not contain Internal Sales Orders of company and you want to display this information when a user comes to that Page. We can simply display it as a note ,but how many users will actually read it. There is always a chance that we miss to read NOTES.

But if we display it as a popup user will definitely read the message.

How to setup popup:

Add a text section to the dashboard. and write the below code in the text and save.
              <body onload="obi_popup()">
              <h1>Welcome to the world of BI</h1>
              </body>

Run the dashboard and you will see the popup.
By at No comments:
Labels: , , ,
Subscribe to: Posts (Atom)