No Data for KPI in Scorecard after adding a third member of a dimension

Hi,

I have a scorecard and one KPI. I put dimension members under the KPI (4 members), Then put on columns the date dimension, at  the week level.

If I only put two members for  weeks on column my KPI displays data, but as soon as I put a third week it displays as no data. It doesn't matter what weeks I choose.

The same thing will happen if I use limit the members on the rows. If I only show the all member or one member then the KPI works fine, if I choose more then it shows no Data.

What to look at?

March 12th, 2013 10:00pm

Please provide some more information like tool versions etc.

How are you adding the dimension under KPI, are they on rows? or the Actual values are filtered by these members?

If the data is shown as no data when you add a new member, it might mean that the aggregation set on your measure is not handling empty/null values. Which measure are you using and what is the aggregation (Sum, Average, max, min etc.) set?

The best place to start looking will be your cube.

Free Windows Admin Tool Kit Click here and download it now
March 15th, 2013 8:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics