Data Analysis view displaying data incorrectly

[tlempicki]

Hi,

I am trying to create a pretty simple Data Analysis view. I want to
display Capacity and Work for each Resource grouped by their Resource
Group. Resource Group is a custom field.

When I create the report and add Work everything is fine. The
Resource Groups are displayed and each Resource that belongs to that
group is displayed in the group. However, when I add Capacity to the
view, it then displays every Resource in the enterprise under every
Resource Group. I can't understand why this is happening and haven't
been able to reproduce this problem in a separate environment.

Has anyone seen this issue before or might know why this occurring?

Thanks,
Todd

 

[JenniferW]

I am getting the same view - all resources, including generic, in all groups.
Even have the filter set to generic = false.

The IU has been applied ...

Any ideas?

Have you applied the service packs and infrastructure update to this
environment?

You can created a custom Capacity field in the Cube Configuration page

True Capacity = iif([Work]=0 or [Work] is null, null, [Capacity])

This might fix the problem as it will only show Capacity when there is work.
But this probably will still show the wrong summary value for Capacity in
your summary groupings.

Jonathan

Hi,

I am trying to create a pretty simple Data Analysis view. I want to
display Capacity and Work for each Resource grouped by their Resource
Group. Resource Group is a custom field.

When I create the report and add Work everything is fine. The
Resource Groups are displayed and each Resource that belongs to that
group is displayed in the group. However, when I add Capacity to the
view, it then displays every Resource in the enterprise under every
Resource Group. I can't understand why this is happening and haven't
been able to reproduce this problem in a separate environment.

Has anyone seen this issue before or might know why this occurring?

Thanks,
Todd