OLAP cubes with Time scale : only 6 months

X

Xiao

Hi,
I built several OLAP cubes views (Data analysis) with the dimension Time. I
built the cube with a date range from 1st january to 31st December 2010.
In some views I can display the values for the 12 months of the year.
For some views, I can just display the first 6 months (2 quarters) while I
selected all the 12 months.
What could be the issue?
Thanks
 
G

Gary Chefetz

Xiao:

It would really help if you were a bit more specific when you post, such as
naming the cubes you're working with and specifying the version of the
software you're using, so I' have to guess a little that the totals columns
you are applying simply do not have data to display. One reason this might
be, is that you don't have resource availability settings extended as a far
into the future as you do the OLAP cube data. What are your capacity
settings under Server Settings > Additional Server Settings?
 
X

Xiao

Gary:

Sorry for being imprecise,
I'm running Project Server 2007 SP2 + December CU
In the Resource Capacity Setting (Additional Server Settings) I have:
- Months behind :1
- Months ahead : 12
The cube I'm using is "Resource Timephased" : it displays Base Capacity and
Capacity for Quarter 1 and Quarter 2 only. I assigned resources to tasks on
Q3 and Q4.
Thanks for your help
 
G

Gary Chefetz

Xiao:

I think the next step would be to see if the job is running by looking at
the log files at the time it's supposed to kickoff. If it was working and
then stopped at some point, it could explain the oddball data difference.
Sounds like yours might have stopped six months ago.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top