How to fit a week into a calendar time hierarchy?
As is usual with cubes, the users want things that don't fit into a hierarchy to be displayed hierarchically. They'd like to see Day > Week > Month > Quarter > Year as the hierarchy, but the problem with weeks is they can be part of 1-2 months, not just 1 month (and by extension part of 2 quarters, semesters, years).
So my question is: how to set up the attribute relationships, and how to set up the hierarchy? Here is what I have, but I know it's not optimal.
Hierarchies (cycle == weeks):
Attribute Relationships:
There is no Cycle -> Year, because it is a many-to-many relationship
There are four types of weeks to concern yourself with:
Week of Year (1-53). Hierarchy: Year > Week
You should decide whether you want Week 1 to begin on Jan 1, or follow the ISO standard
Week of Month (1-5). Hierarchy: Year [> Quarter] > Month > Week
You should decide whether you want Week 1 to begin on the first day of the month, or the first Sunday/Monday of the month.
Week of Fiscal Year (1-53). Hierarchy: Fiscal Year > Week
Week of Fiscal Month (1-5). Hierarchy: Fiscal Year [> Quarter] > Month > Week
- Do I need to use timezones with timedelta and datetime.now?
- Format TimeSpan to mm:ss for positive and negative TimeSpans
- Hour difference between 2 DateTime objects in Decimal Format
- Given day, month, year calculate day in year
- joda time plusDays forPattern("dd/mm/yyyy") does not switch to the next month
- MIDI file NoteOn time in ms using DryWetMidi
- Anylogic INtroducing time fluctuations in a dynamic variable
- How to get the time hh:mm:ss of any state starting by seconds from midnight without changing date_default_timezone_set regardless of the state I am in
- Hiding zero times in Excel
- clock() precision in time.h
- Interval synced to Time
- How do I measure execution time of a command on the Windows command line?
- Python loop to run for certain amount of seconds
- Outputting Date and Time in C++ using std::chrono
- Why does the basic string formatting outperforms the built-in re.compile() function?
- Date Time in Java - How to find how many milliseconds from a certain date to 1970?
- How to get the today's and tomorrow's date in swift 4
- exceeding time limit in a minesweeper program
- Find out a work around to bypass Java.time bug with spelling of name of month
- How can I draw a line of a specific candle in a specific time of a specific character?
- Linux command to get time in milliseconds
- time.sleep sleeping too much on python
- Is it possible to wait a few seconds before printing a new line in C?
- Chart with hh:min format in the horizontal axis instead of hours
- performance.now() vs Date.now()
- How do I create a session that runs from friday till sunday the following week?
- php get future date time
- c++ use strftime to get a url encoded string?
- How do I get the current time in milliseconds in Python?
- Does Python's time.time() return the local or UTC timestamp?