9 Replies Latest reply: Oct 5, 2014 3:49 AM by Marco Wedel RSS

    Generating dimensions values depending on another dimension values

    Marcelo Hernandes

      Hello everyone,


      I have two dimensions: "ID" and "Activity". For each distinct ID there is a lot of activities. When one activity is finished, we add a value called "Done".


      I'd like to create a new dimension called "Status", in which we can have a "Done" value associated to a IDs that contains the "Done" value in one of the "Activity" values. If we don't have it, the other value is "Undone".


      Bellow, you can see more clearly what I'm looking for:


      Is there a way to do this?


      Thanks in advanced!