none
Dynamic KPI RRS feed

  • Question

  • Hi,

    I have a multi-dimensional AS cube with the following structure:

    Fact:-
    -ID
    -ID_Time (links to dimTime)
    -ID_KPI (links to dimKPI)
    -ID_User (links to dimUser)
    -Actual
    -Target

    dimTime:-
    -ID
    -Year
    -Quarter
    -Month
    -Date

    dimUser:-
    -ID
    -FullName

    dimKPI:-
    -ID
    -Name
    -ID_Level1 (links to dimLevel1)

    dimLevel1:-
    -ID
    -Name
    -ID_Level2 (links to dimLevel2)

    dimLevel2:-
    -ID
    -Name

    So as you can see the KPI's are contained in a dimension as apposed to having fixed KPI values in the fact table.

    How would I go about dynamically assigning these KPI values in PerformancePoint so that I can create a scorecard with the following structure?
                               Actual Target
    -[Level1]             [Actual] [Target]
        -[Level2]         [Actual] [Target]
            -[KPI]          [Actual] [Target]
                -[User]    [Actual] [Target]

    Any information whould be appreciated :P
    Wednesday, March 4, 2009 9:57 AM

Answers

  • Unfortunately, we don't support dynamic hierarchies in scorecards in PPS 2007, we are looking to change this in the future.  You would have to manually reconstruct the hierarchy and manually indent your members today.
    Thanks,
    Alyson
    Wednesday, March 4, 2009 4:00 PM