0

Switching time hierarchies on dashboard

Hi Folks!  Wondering if anyone knows of an easy way to switch time hierarchies on a dashboard.  

Example is 4 different dates with time intel, Date Born, Date Married, Date Divorced, Date Died.  I am looking for an elegant way for user to switch all the data in the dashboard to any of those dates.  

1 reply

null
    • Senior Consultant BI & Data Management
    • Markus_Loy
    • 5 yrs ago
    • Reported - view

    Hi Dawn Fink ,

    I usually realize such requirements with ONE time dimension and another dimension as a switch ("Kind of date") containing the 4 elements "Date Born", "Date Married", "Date Divorced" and "Date Died". (Usually in real world these are e.g. "Booking Date", "Order Date", "Shipment Date" etc.)

    In "relational speech" it's a step of normalization - instead of one set with four date fields you will then have four (almost) identical sets with one date field and one field for "Kind of date".

    Does that meet your requirements?

    Regards
    Markus

Login to reply

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 1Replies
  • 53Views
  • 6 Following