You can make a copy of the original cube, then replace Month with the weeks
dimension. You then update the default cube then the new cube and viola you
have your weeks data.
So yes it can be done quite easily though is harder to explain to a (not
saying you are) inexpienced OLAP user. Now I do have a document that walks
you through this step by step though with the screen shots its 60MG.
So here are the steps if you want to get my doc shoot me a mail at
[email protected].
Project Server Analysis Services
To display and process data not originally included in the MS Project
Portfolio Analyzer you must use the following step to create and process a
custom cube.
1.Develop a design document that includes:
a.Row parameters
b.Column parameters
c.Data Source information
2.Using SQL Enterprise Manager on the SQL server with the Project Server
2003 database open and review database, tables, and maps to determine if
desired information is available and if so note table and column names
exactly.
3.Log into the SQL Server running the SQL Analysis Manager as a
domain/systems administrator.
4.On the SQL server open SQL Analysis Manager
5.Browse to the default Project DB and right click saying copy.
6.Move to the container level and paste the DB creating a new DB
a.Name the new database the same as the old plus the primary added function.
7.Inside of the new DB open the cubes container and create copies of all
three containers pasting them back in the cubes folder using the same naming
scheme as the DB.
8.ON the new MSP_PORTFOLIO_ANALYZER_XXX cube select edit, in the new window
that opens select edit, structure. In the new window remove all the standard
cubes from the membership and add the _XXXX cubes to the include list.
9.Once these changes have been completed to establish the new cube you can
use the editor function to add either existing and/or new dimensions to the
database from the existing source.
a.The dimensions to be added will be determined in a report design session
which will provide a report layout and column/row item detail and database
table and row information.
b.In the shared Dimensions make sure that any calculations and/or queries
are updated to include valid dimensions, tables, and columns.
10.After you have completed your changes you will need to process and build
new storage for your cube.
a.Select Tools Process now for each cube with the MSP_PORTFOLIO_ANALYZER_XXX
being the last cube processed.
b.Select OLAP (Do not attempt to use ROLAP/RLAP with Project)
c.When prompted run the calculate storage wizard.
If you know what your doing this takes about 15 minutes, if not about a
week....
