Solution Starter Files
The following table lists and briefly describes the files contained in the Portfolio Analyzer OLAP Extensions Solution Starter file pj11OlapExtensions.exe, which is available from the Microsoft Download Center. The installation and use of these files is described in other topics of this solution starter.
If you execute the pj11OlapExtensions.exe download and extract to the default directory, you will find these files in C:\Program Files\Microsoft Office 2003 SDKs\Microsoft Office Project 2003 SDK\Solution Starters\Portfolio Analyzer OLAP Extensions.
| Subdirectory | File | Description |
|---|---|---|
| pj11OLAPExtensions.chm | HTML Help file, contains all of the topics in the solution starter. | |
| Files for the Pay Period OLAP extension | ||
| PayPeriodDimension | ExtendOLAPTables.sql | Transact SQL script to add staging tables for the Pay Period OLAP extension. |
| " | OLAPDemoGroup.vbg | Microsoft Visual Basic® project group, contains the MSPOLAPBREAKOUT and OLAPBreakoutTest projects for the Pay Period OLAP extension. |
| " | MSPOLAPBREAKOUT.vbp | Visual Basic project file, creates the user breakout DLL for the custom OLAP processes. |
| " | UserOptionalCode.cls | Visual Basic class file, includes the code templates for the user breakout functions UserStagingTablesUpdate and UserOLAPUpdate. |
| " | MSPOLAPBREAKOUT.lib MSPOLAPBREAKOUT.exp MSPOLAPBREAKOUT.vbw MSPOLAPBREAKOUT.dll |
Library, library export link, and Visual Basic workspace files for the MSPOLAPBREAKOUT project and compiled DLL of the user breakout functions. These are for the Pay Period OLAP Extension. |
| " | OLAPBreakoutTest.vbp | Visual Basic project file, creates the OLAP Breakout Test application for the Pay Period OLAP extension. |
| " | Form1.frm | Visual Basic form, contains the user interface and code for the OLAP Breakout Test application of the Pay Period extension. |
| " | OLAPBreakoutTest.vbw OLAPBreakoutTest.exe |
Visual Basic workspace file and compiled executable for the OLAP Breakout Test application in the Pay Period OLAP Extension. |
| Files for the Task Issues and Risks OLAP extension | ||
| TaskIssuesRisks | OLAPDemoGroup.vbg | Visual Basic project group, contains the MSPOLAPBREAKOUT and OLAPBreakoutTest projects for the Task Issues and Risks OLAP extension. |
| " | MSPOLAPBREAKOUT.vbp | Visual Basic project file, creates the user breakout DLL for the custom OLAP processes. |
| " | UserOptionalCode.cls | Visual Basic class file, includes the custom code for the user breakout functions UserStagingTablesUpdate and UserOLAPUpdate. These are for the Task Issues and Risks OLAP extension. |
| " | MSPOLAPBREAKOUT.lib MSPOLAPBREAKOUT.exp MSPOLAPBREAKOUT.vbw MSPOLAPBREAKOUT.dll |
Library, library export link, and Visual Basic workspace files for the MSPOLAPBREAKOUT project and compiled DLL of the user breakout functions. These are for the Task Issues and Risks OLAP extension. |
| " | OLAPBreakoutTest.vbp | Visual Basic project file, creates the OLAP Breakout Test application for the Task Issues and Risks OLAP extension. |
| " | Form1.frm | Visual Basic form, contains the user interface and code for the OLAP Breakout Test application of the Task Issues and Risks extension. |
| " | OLAPBreakoutTest.vbw OLAPBreakoutTest.exe |
Visual Basic workspace file and compiled executable for the OLAP Breakout Test application in the Task Issues and Risks OLAP Extension. |
| TaskIssuesRisks \Utils |
PromoteTemplate.bat | Batch script to install the Task Issues and Risks template on Microsoft Windows® SharePoint™ Services, for use by Microsoft Office Project Web Access. |
| " | solutionstarter.stp | Windows SharePoint Services template, creates Issues and Risks pages in Project Web Access. |
| " | WSSCubeSetup.bat | Batch script to execute the Transact SQL script that creates the staging tables for the Task Issues and Risks OLAP extension. |
| " | createWSSCubesTable.txt | Text file that contains the Transact SQL script for the Task Issues and Risks staging tables; used by WSSCubeSetup.bat. |
| Files for the task earned value OLAP extension | ||
| TaskEarnedValue | OLAPDemoGroup.vbg | Visual Basic project group, contains the MSPOLAPBREAKOUT and OLAPBreakoutTest projects for the Task Earned Value OLAP extension. |
| " | MSPOLAPBREAKOUT.vbp | Visual Basic project file, creates the user breakout DLL for the custom OLAP processes. |
| " | UserOptionalCode.cls | Visual Basic class file, includes the custom code for the user breakout functions UserStagingTablesUpdate and UserOLAPUpdate. These are for the Task Earned Value OLAP extension. |
| " | ProjectCubeAccess.bas ProjectDatabaseAccess.bas |
Visual Basic code modules, contain all the functions needed to access the Analysis Server and the Project Server database. |
| " | OutlineCodeInfoManager.cls | Visual Basic class file, contains methods that simplify management of the information collected about task outline codes. |
| " | TaskOutlineCodeInfo.cls | Visual Basic class file, gets and sets the unique task outline code value ID. |
| " | TaskOutlineValueInfo.cls | Visual Basic class file, validates a task outline code name and ID. |
| " | MSPOLAPBREAKOUT.lib MSPOLAPBREAKOUT.exp MSPOLAPBREAKOUT.vbw MSPOLAPBREAKOUT.dll |
Library, library export link, and Visual Basic workspace files for the MSPOLAPBREAKOUT project and compiled DLL of the user breakout functions. These are for the Task Earned Value OLAP extension. |
| " | OLAPBreakoutTest.vbp | Visual Basic project file, creates the OLAP Breakout Test application for the Task Earned Value OLAP extension. |
| " | Form1.frm | Visual Basic form, contains the user interface and code for the OLAP Breakout Test application of the Task Earned Value extension. |
| " | OLAPBreakoutTest.vbw OLAPBreakoutTest.exe |
Visual Basic workspace file and compiled executable for the OLAP Breakout Test application in the Task Earned Value OLAP extension. |
| TaskEarnedValue \Utils |
extendViewTaskTable.bat | Batch script to alter the task view table. |
| " | extendViewTaskTable.txt | Text file that contains the Transact SQL script to add fields to the MSP_VIEW_PROJ_TASK_TP_BY_DAY view table. Used by extendViewTaskTable.bat. |
| " | EarnedValueCubeSetup.bat | Batch script to execute the Transact SQL script that creates the staging tables for the Task Earned Value and Enterprise Task Outline Codes OLAP extension. |
| " | createTasksCubesTable.txt | Text file that contains the Transact SQL script for the Task Earned Value and Enterprise Task Outline Codes staging tables; used by EarnedValueCubeSetup.bat. |
| " | qylibsql.txt | Text file that contains an extended query ID 50800, to replace the 50800 query in the QYLIBSQL.SQL file in the Project Server \BIN directory. |