I have a table with three dates:
My active date relationship is Open Date. The other two HHD Open Dates and Maturity Date are inactive relationships.
I want to use a date hierarchy in both the Open Date and Maturity Date in my visuals but that measurement group is not showing up. Both fields (Open Date and Maturity Date) are configured as date type = Date:
How can I activate the date hierarchy for both the Open Date and Maturity Date?