Scorecard with multiple dates (OrderDate & ShipDate) RRS feed

  • Question

  • Hello.

    First of all, sorry for my poor english.

    I am developing a scorecard with two types of KPIs. 6 of them are sliced by OrderDate and 4 are sliced by ShipDate. I need to create a dashboard with only a date filter and it must work like this example

    DateFilter: Jan-2013

    * OrderDate based KPIs: show the number of orders, etc. made in Jan-2013

    * ShipDate based KPIs: show the number of orders, etc. shipped in Jan-2013

    All the KPIs are based in the same Fact Table.

    I think the solution is to use a ConnectionFormula + LinkMember MDX function between the filter and the scorecard but i don't know how to implement this funcion based on each KPI.

    Thanks for all

    Wednesday, April 2, 2014 7:00 AM