Configure time intelligence filter to work with SSAS cube and table data sources RRS feed

  • Question

  • Hi,

    I have a scorecard with two data sources, one is a table in an excel worksheet the other is an SSAS cube.  I want to show data from both sources i one scorecard with a time intelligence filter on the scorecard.

    I have configured time intelligence from both sources and can make scorecards work individually with their filters. However if I combine sources onto one scorecard and use one filter it won't work for both KPIs on the scorecard.

    Ican see the reason for this because the result of the Time intelligence formula in both cases resolve to a different answer so:

    SSAS cube - Month results in [Dim Date].[Heirachy].[Fiscal Year Month].&[FY2012-09]

    Excel table - Month results in [Date.Month].[2012-12]

    My questions are:

    is there an elegant solution to this?

    and if not, if I change my sources so they result in the same answers for my time intelligence forula will this work despite them being from different sources?



    • Edited by peego Thursday, December 13, 2012 1:07 PM
    Thursday, December 13, 2012 10:31 AM