Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Display all month names

Received Response
21
Views
3
Comments
3586388
3586388 Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

Hi There,

I have a requirement like within the selected Date Range, if we don't have data then also need to display the months in report.

In my case i have taken Date_From -  Date_To are 01/01/2017 to 31/12/2107, and i have the data in July and Dec only. But i want to see all the months which i don't have the data also.

Here report is displaying the months which have the data in date range.

PFA,

pastedImage_6.png

Thanks In Advance!

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    A quick fix would be to check the checkbox to include NULLs in the analysis. But you can have a side effect that also all the partners will be on screen.

    Other plans would require changes in the RPD, and being OBIA ... I guess it isn't really something you look for.

  • 3586388
    3586388 Rank 3 - Community Apprentice

    Thanks for your reply Gianni,

    I have enabled the check box for include Null Row in pivot table property. Then also i dint get all the months but i get all partner values.

    pastedImage_0.pngpastedImage_1.png

    When i enabled check box for Include columns with only Null values, then i got result like below

    pastedImage_4.png

    I have a date range for 1 year only i.e, 2107. but am getting 2018 months as well.

    Other plans would require changes in the RPD, and being OBIA:

    Please suggest what changes need to do in RPD , so my requirement can full fill.

    Thanks

  • 3586388
    3586388 Rank 3 - Community Apprentice

    Thanks you Gianni,

    I got solution , enabled the check box for include columns with only null values.

    Ramesh