locked
Dynamic Target in Scorecard??? RRS feed

  • Question

  • Hi,

     

    I want a dynamic “Target” in the scorecard under Dashboard Designer. Let me explain with an example, consider the following table,

     

    Service P

    Service C

    Priority

    Vertical

    Target

    S1

    S1-A

    --

    --

    90%

    S1

    S1-B

    --

    --

    90%

    S2

    S2-C

    --

    --

    90%

    S2

    S2-D

    --

    --

    90%

    S3

    S3-E

    P1

    V1

    90%

    S3

    S3-F

    P2

    V2

    80%

    S3

    S3-G

    P2

    V1

    80%

    S3

    S3-H

    P3

    V2

    70%

    S3

    S3-I

    P3

    V1

    70%

    S3

    S3-J

    P4

    V2

    60%

    S3

    S3-K

    P4

    V2

    60%

     


    Those Service, Priority and Verticals are my filters in the Dashboard.

    For “S1” and “S2”, no need to consider the “Priority” and “Vertical”. The “Target” has to be “90%”. For “S3”, need to consider the “Priority” and “Vertical”. For the combination of

     

    “S3 – P1 – V1” the “Target” has to be “90%”,

    “S3 – P2 – V2” the “Target” has to be “80%”,

    “S3 – P2 – V1” the “Target” has to be “70%”,

    “S3 – P3 – V2” the “Target” has to be “80%”,

    “S3 – P3 – V1” the “Target” has to be “70%”,

    “S3 – P4 – V2” the “Target” has to be “60%”.

     

    Whether, I can get a dynamic value for the “Target”?

     

    Help me out in this issue.

     

    Regards,

    Sujeev

    Wednesday, June 10, 2009 10:52 AM

Answers

  • Are these attributes all in the same dimension?  If so then you could place this target in the dimension and reference the member.  Take a look at this other thread - Weight to Target total?.

    If it is not then it sounds like you will most likely want to setup a SCOPE statement possibly in the calculation portion of your cube to be able to set the Target value dynamic based on the members that are being selected.  Would need a little more information as to where the first four columns are coming from in the cube if this is a SSAS datasource.

    SCOPE Statement (MDX)
    http://msdn.microsoft.com/en-us/library/ms145989.aspx

    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    • Marked as answer by Sujeev Saturday, June 13, 2009 5:01 PM
    Friday, June 12, 2009 2:23 AM

All replies

  • Are these attributes all in the same dimension?  If so then you could place this target in the dimension and reference the member.  Take a look at this other thread - Weight to Target total?.

    If it is not then it sounds like you will most likely want to setup a SCOPE statement possibly in the calculation portion of your cube to be able to set the Target value dynamic based on the members that are being selected.  Would need a little more information as to where the first four columns are coming from in the cube if this is a SSAS datasource.

    SCOPE Statement (MDX)
    http://msdn.microsoft.com/en-us/library/ms145989.aspx

    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    • Marked as answer by Sujeev Saturday, June 13, 2009 5:01 PM
    Friday, June 12, 2009 2:23 AM
  • Hi Dan,

    Service, Priority and Verticals are Dimensions. I am going through the links you have mentioned above. We have solved this problem by having a separate Fact table in the cube. It is working fine.

    Thanks for you effort.

    Regards,
    Sujeev
    Saturday, June 13, 2009 5:01 PM