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.
1 person found this helpful
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.
A nice round 10 threads
For Australia the Financial Year is 01 July 2017 - 30 JUN 2018
@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!
*** Moderator Note
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: Community Posting Etiquette
Respond appropriately when your question has been addressed
Proper 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