How can i display the value of "Current Month" in a report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can i display the value of "Current Month" in a report

Received Response
144
Views
9
Comments
John305
John305 Rank 5 - Community Champion

Hi everyone ,

IF i want to display the measure of the current Month and the current month in a report , without updating it every month ? what is the easiest way to do it ??

Thank youu !

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    rpd variable

    or

    MONTH(CURRENT_DATE)

    MONTHNAME(CURRENT_DATE)

    Screen Shot 2017-02-15 at 12.01.55 PM.png

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    *if* that variable exists...

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    *if* everything exists!

  • Joel
    Joel Rank 8 - Analytics Strategist

    "if" the model has a time dimension...

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    select sysdate from dual;

  • John305
    John305 Rank 5 - Community Champion

    i have a time dimension , in cognos i used to do smthg like :

    IF [Dimension ... ].[..]..[Month]= Current month , then ("Total of my measure") else 0

    i dont wanna just display the "Month" But the measure of the month   , if we are in february " I should display the february results " , in march ... and so on .

  • John305
    John305 Rank 5 - Community Champion

    okey , and if i want to filter on the measure of the month ?

  • Use CURRENT_DATE and all the existing OBIEE functions on dates to generate the required filter based on your data (depends how you need the filter to look like, if "Feb 2017" or "201702" or 2017-02-28 as a date etc.).

    A filter in an analysis is not just a static value, you can add functions etc.

  • Walter de Wit
    Walter de Wit Rank 2 - Community Beginner

    You can use the filter in the filter section preferably I think. Not in the column formula if I understand your question correctly

    pastedImage_0.png