Oracle Analytics Cloud and Server

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

Fiscal Year Date Column computation

Received Response
33
Views
1
Comments

Hi All,

My organization is on different Fiscal year i.e from Oct 01 through to Sep 30 of the following year. For Anaytics we were using the another Calendar dimension table that held that data for our fiscal year calendar essentially. Is there any easier way to do this in DV or do we have to use bring in the FY table that we used for the classical model ?


Any ideas would be really appreciated.


Thanks

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi User_3YQO6 ,

    Welcome to the Oracle Analytics Online Forum!

    To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

    If you are using custom time dimension tables, you need to use the same in DV to do the visualization as per our business need.

    do we have to use bring in the FY table that we used for the classical model --> Yes.

    Regards,

    Arjun