dimension week

[Hernandezz]

Hi, I use project server 2003 and SQL server 2005. I created OLAP Cube
portfolio analyzer, but this cube doesn't show the dimension week. I created
a new data source view with the table CUBE_Time_by_day and a dimension based
in this source view but I don't work with the cube, because I can't create
the relationships.
How can I display dimension week in portfolio analyzer cube with Analyzes
Services 2005? Do you have any idea?


Thanks in advance & Happy New Year!
Regards

 

[Gérard Ducouret]

Hi Hernandez,

You can try that:
http://www.interprojet.com/9_2_week.htm

Gérard Ducouret