Past CFVUG Presentations

[Brian Meikle]

Posts of Presentations to the CFVUG

[Brian Meikle]

The attached presentation was given by Pete for the June 18, 2008 Central Florida Vision USer Group Meeting. If you have any additional questions, then Pete can be reached at the information located below.

Pete Nuffer, Senior Vision Technical Consultant
Jewell & Associates
Phone: 813-610-1555
pete@jewellassociates.com

[Brian Meikle]

Reference Materials for Analysis Cubes Presentation

References for Pivot Tables:

· http://office.microsoft.com/en-us/excel ... 51033.aspx

· Introduction to Pivot Tables: http://office.microsoft.com/training/tr ... 2058721033

· PivotTable I: Get started with PivotTable reports in Excel 2007: http://office.microsoft.com/training/tr ... 2058721033

· PivotTable II: Filter PivotTable report data in Excel 2007: http://office.microsoft.com/training/tr ... 2080371033

· PivotTable III: Calculate data in PivotTable reports in Excel 2007: http://office.microsoft.com/training/tr ... 2102791033


Parking Lot Items:

Q: Can you use manually calculated fields or custom fields in with Analysis Cubes?

A: Custom fields in Vision cannot be included in Analysis Cubes reports (the data warehouse and Cubes are formulated using the standard fields in the database to allow for multiple use scenarios). As for calculated fields in Excel, you can run calculations based on the values presented in the Pivot Table, but be aware that a movement of the data may cause your calculation to be modified and unfortunately changed. The ability to expand and collapse groups is one of the benefits of using Deltek analysis cubes, but this creates an issue when trying to hard code formulas based on cell’s locations unless you lock the spreadsheet.


Q: When key converting a project from a particular date, how can you rectify the inconsistencies between the Analysis Cubes report and the Vision database?

A: I will look further into this, but the cube will show the reflection of what the new Project number/organization is. By doing so it is behaving as it was designed to behave, and conforming to how the key conversion was run. I’ll let you know if I find any contrary information.

The presentaion on Analysis Cubes was recorded in WebEx. You will need the ARF WebEx player to view the file, available at https://jewellassociates.webex.com/clie ... player.msi


Best regards,

Pete Nuffer
Senior Vision Technical Consultant

Jewell & Associates
Your local Deltek Premier Partner
Celebrating 18 Years of Helping Our Clients Maximize Profits
Phone: 877-241-6431 x 711 / Fax: 877-241-6431
http://www.jewellassociates.com

[Brian Meikle]

Below is the Presentation on Revenue Generation provided by Martha Griffith with Jewell and Assoicates, Inc.

[Brian Meikle]

Below is the Presentation on MODI and Template Presentation provided by Sarah Mackley with Innovative Solutions Group.