schedule the daily updates of *two* OLAP CUBES

[Gros Minet]

Hello,

How to schedule the daily updates of *two* OLAP CUBES ?

Thanks ahead.

 

[Guest]

Hello Gros,

I presume that one of the cubes you refer to is the default cube
supplied with Microsoft Project Server and that you are not having
any difficulty getting it to build on a regular schedule.

The recommended process for adding an additional cube or
content to the standard cube, is to extend the standard process.
This ensures that the additional cube is built along with the
standard cube.

If you extend the cube some other way, you will also need to
invent your own scheduling system. This isn't particularly
difficult, but I would need to know more about what you have
done and are trying to accomplish.

I went down this path myself and ultimately went back to the
Microsoft recommend process for extending the cube.

There were a few things that I had to figure out the hard way and
in the end I wrote a white paper to help others through the same
knot holes. The paper can be found at:

http://bsege.com/white_papers.htm

Bob Segrest, PMP
Microsoft Project Blackbelt

 

[Ray McCoppin]

The way that I have done is:
1. Let the default cube build as normal, this will rebuild the cube staging
tables.
2. use SQL DTS to schedule the build of the second cube after the defualt
cube builds.

This works unless the second cube requires a different data set than the
default cube.

Hope this Helps.

 

[Gros Minet]

Hello Ray,

I don't know what is SQL DTS ;-(

I did the following :
Admin / Manage Enterprise Features
In the page "Update resources tables and OLAP Cube", in the "Name and
description of the OLAP cube" section, I had already a Cube name, such as
"MyCube". It took in account all the data from the Earlier Start of the
first project, to the Latest Finish of the last project.(Range of dates)
I changed the Cube Name as "MyCuble2006" which takes in account only the
data of Year 2006.
I clicked the Update button.
I am not sure, but it seems that this works. The S curves look fine for the
2 cubes with different Ranges of dates.

1° - Was it the good procedure?
2° - If Yes, do the 2 cubes will obey the updates frequency and the 2 ranges
dates?

Thanks for your help!

 

[Ray McCoppin]

SQL - DTS is SQL Server Data Transformation Services. It is used alot of the
time by programmers to process and build OLAP cubes outside of Project Server.

But in your case try this.
1. building a cube from project server creates a XML file in your view drop
folder.
2. stop the views notication service on your project server
3. use the admin page to generate your two cubes.
4. copy the two xml views in your view drop folder to a new folder on the
project server.
5. restart the views notication service
6.create batch file the will copy these two xml files to the viewdrop folder
7. use the windows scheduling service to schedule this batch job to run
8. don't use project server to schedule your OLAP cube build.

This should create your 2 OLAP cubes.

 

[Gros Minet]

Ray,
Thanks for every thing. I'll work on it!

SQL - DTS is SQL Server Data Transformation Services. It is used alot of
the
time by programmers to process and build OLAP cubes outside of Project
Server.

But in your case try this.
1. building a cube from project server creates a XML file in your view
drop
folder.
2. stop the views notication service on your project server
3. use the admin page to generate your two cubes.
4. copy the two xml views in your view drop folder to a new folder on the
project server.
5. restart the views notication service
6.create batch file the will copy these two xml files to the viewdrop
folder
7. use the windows scheduling service to schedule this batch job to run
8. don't use project server to schedule your OLAP cube build.

This should create your 2 OLAP cubes.

--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts