OLAP Cube Not Pulling All Information

J

Jeff

We have been generated OLAP cubes however for some reason
when we try to create a report some of the information is
missing. Its clearly in project plans in the SQL database
and some of the information is reported but its as though
it doesnt pick up other pieces. The date range is correct
(earliest start to last finish) and all other settings
look correct. Any other ideas where to look to determine
why it isnt pulling in this information?
 
J

Jeff

We have set up project plan templates for resource
reporting with 1 task per department and all resources
within that department assigned to that task. We then
created one project plan for each project off of that
template. Basically the resource managers go in and enter
resource time for their resources on each project and
remove those resources who do not do any work on a given
project. The issue is most of the resources & their time
by project shows up when we generate an OLAP cube and put
together some reports. The problem is that some of the
resource time doesnt show up even though it is all entered
the same way. They are all enterprise resources, not
local, and most of the resources are fine. We have set up
outline codes by department so that we can view resources
by department/project/time. Again it just doesnt take in
some information when it compiles the data and its all
entered the same way. Could it be a mask in the table or
something or is this an OLAP issue on the SQL side? I cant
figure it out and Ive been looking at it for several
hours. Unfortunately we do not have any OLAP experts in
house which is why I am trying to definitively find the
cause so that I can justify bringing someone in.
 
M

Michael Patrick

I had a similar problem. Have a look in your application
error log. You may find that your views are not building
which will cause the cube to be out of sync. Most likely
this is caused by having a reserved character in either a
project name, resource name, task name or outline name.

Good Luck,

MP
 
Top