nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to impliment this in OBIEE? Financial year for India is April to March

user652652

Hi Experts,

We have to implement a solution where we have different countries like India/USA/UK etc.

For India financial year is April to March and for rest other countries it is January to December.

We have prompt Country Start Date End Date Year. Start Date /End Date are quarter start date(1-Jan/1-Apr/1-Jul/1-Oct) and quarter end date(31-Mar/30-Jun/30-Sept/31-dec).

When user select Country=India and Quarter =Q4 and Year =2016. Then the data should be filter for Year=2017(because India's Q4 is lies in next year.)

As user can select multiple quarters , so always for India for Q4 the year should be next year.

If you have any suggestion, Please share.

Thanks,

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Hi,

You can snowflake the table with countries and start/end of quarters by country with the time dimension (day between start and end). So when you select the country it will automatically join and apply the right filtering on the time dimension based on the country etc.

[Deleted User]

To add to Gianni's reply: It all is dependent on you actually posessing a well formed data Dimension which comprehends your Interpretation of the "Fiscal Calendar".

You'll find that with almost all time topics the physical time dimension is crucial.

asim cholas

Please close the threads you opened if it is answered, so that it will be helpful the other users in the forum.

Gianni Ceresa

@user652652 : How to close thread and mark answers

As you never closed a single one and so you are just using the community forum without giving anything back I thought an "how to" was maybe helpful

[Deleted User]

A nice round 10 threads

OMAR_BI

For Australia the Financial Year is 01 July 2017 - 30 JUN 2018

[Deleted User]

@OMAR_BI What's your point? Every region has its own definition of "Fiscal Year" and depending on legislations corporations may choose their own fiscal year.

That doesn't add any information to this topic and just reinforces the main point: It all depends on how you model your physical time dimension and how many different calendars you register in it.

@user652652 Nice going by the way on again abandoning a thread!

BluShadow

*** Moderator Note

@user652652

As others have indicated, it's good community etiquette to respond to, and reward, people who have answered your question threads.

Please see the FAQ:

Respond appropriately when your question has been addressedProper etiquette is that the poster should provide feedback to those who provide answers to questions; mark responses accordingly as “Correct” or “Helpful.” You can only mark one answer as Correct, though as many as you like as Helpful.

By marking a correct answer in your threads, this will mark the thread as "Answered" and allow members to focus on unanswered questions. If you feel that nothing is particularly correct, then you can just award helpful marks to people, and click the "Mark as Assumed Answered" link on your thread if you now feel there is no need for any further discussion.

By following this etiquette, members are more likely to help you in future (rather than pull you up on the fact you don't do this, as has happened here).

Please also consider changing your display name to something more recognisable, as it gives a better sense of identity on the community: https://community.oracle.com/docs/DOC-889070#jive_content_id_How_can_I_change_my_Display_Name

***