Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to impliment this in OBIEE? Financial year for India is April to March
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,
Answers
-
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.
0 -
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.
0 -
Please close the threads you opened if it is answered, so that it will be helpful the other users in the forum.
0 -
@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
0 -
A nice round 10 threads
0 -
For Australia the Financial Year is 01 July 2017 - 30 JUN 2018
0 -
@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!
0 -
*** Moderator Note
As others have indicated, it's good community etiquette to respond to, and reward, people who have answered your question threads.
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
***
0
