6 Replies Latest reply: Oct 29, 2012 12:01 PM by John Witherspoon RSS

    Chart with one axis for multiple dates

    Arne Roßmann

      Hi @ all,

      I've a problem creating a chart with the following requirements:

      I want to show 2 formulas in a chart where on depends on the creation date and one on the closing date.I have a classical star schema with a fact table and surrounding dimensions, in special a dim_creation_time and dim_closing_time for handling the different dates.

      Now my idea was to have a third date_dimension called dim_date_range which is not connected to the fact table. This dimension should be the dimension in a line chart. But How do I connect this separated dimension to the other ones in the formulars?

      Thanks for your help.