Download - Enterprise Training
![Page 1: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/1.jpg)
Prophix Enterprise Administrator Workshop
Craig Cullum
![Page 2: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/2.jpg)
Agenda - Day 1
• Model Creation
• Building Account and Organisational Structures
• Data Import
• Version Manager
• Process Manager
![Page 3: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/3.jpg)
Agenda - Day 2
• Security Manager
• User Manager
• Workflow Process
• Data Entry
• Ad-hoc Analysis
• Report Library
![Page 4: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/4.jpg)
What is Prophix?
![Page 5: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/5.jpg)
Tell me the Actual Sales figures for all of the Nestle Widgets sold in Shops in Western Australia in the
month of January 2008 in AUD Dollars
![Page 6: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/6.jpg)
![Page 7: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/7.jpg)
OLAP Technology• Online Analytical Processing
![Page 8: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/8.jpg)
OLAP Technology• Online Analytical Processing
![Page 9: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/9.jpg)
OLAP Technology• Online Analytical Processing
Accounts
Departments
Regions
East
Finance
Expenses
![Page 10: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/10.jpg)
Data Dimensionality
You want to know the Actual Sales figures for all of the Nestle Widgets sold in Shops in Western Australia in the
month of January in AUS Dollar.
![Page 11: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/11.jpg)
Data Dimensionality
You want to know the Actual Sales figures for all of the Nestle Widgets sold in Shops in Western Australia in the
month of January in AUS Dollar.
![Page 12: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/12.jpg)
Data Dimensionality
You want to know the Actual Sales figures for all of the Nestle Widgets sold in Shops in Western Australia in the
month of January in AUS Dollar.
Version Account
Time CurrencyOrganisationProduct
![Page 13: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/13.jpg)
Exercise 1v6 - 37279 - 31733 - 78113 - 17702
v7 - 774104 - 124718 - 116113 - 455807
![Page 14: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/14.jpg)
DimensionsTotal
Company
West Head Office East
Perth Karratha Sydney Melbourne Canberra
![Page 15: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/15.jpg)
Exercise 2 - 3
![Page 16: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/16.jpg)
Time Conversion Method
1 2 3 6Sum
1 2 3 2Average
1 2 3 1First
1 2 3 3Last
![Page 17: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/17.jpg)
January February March Q1
Price $10 $9 $10
Volume 10 16 12 38
Revenue $100 $144 $120 $364
Weight By Example
$29
Avg. Price = Revenue / Volume
![Page 18: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/18.jpg)
January February March Q1
Price $10 $9 $10
Volume 10 16 12 38
Revenue $100 $144 $120 $364
Weight By Example
$29
Avg. Price = Revenue / Volume
![Page 19: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/19.jpg)
January February March Q1
Price $10 $9 $10
Volume 10 16 12 38
Revenue $100 $144 $120 $364
Weight By Example
$29
Avg. Price = Revenue / Volume
![Page 20: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/20.jpg)
January February March Q1
Price $10 $9 $10
Volume 10 16 12 38
Revenue $100 $144 $120 $364
Weight By Example
$9.58
Avg. Price = Revenue / Volume
![Page 21: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/21.jpg)
Weight By
• Typical use would be Revenue Calculation
• Rule of thumb, use denominator
![Page 22: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/22.jpg)
Recalculate
• Performs the calculation after a consolidation
• Important when using calculations that use non leaf members
![Page 23: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/23.jpg)
Prior Month
• Priormonth ([Account], Zero, Reset)
• Priormonth ([Account], Version, Continue)
![Page 24: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/24.jpg)
Exercise 4 - 5
![Page 25: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/25.jpg)
Versions
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010BaseYear
![Page 26: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/26.jpg)
Versions
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010BaseYearHistory (Actuals)
![Page 27: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/27.jpg)
Versions
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010BaseYearHistory (Actuals) Planning
1 Year Plan
3 Year Plan
6 Year Plan
![Page 28: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/28.jpg)
Exercise 7 - 8
![Page 29: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/29.jpg)
Reporting and Data Entry
• Data Entry
• Delta Analysis
• Line Item Schedule
• Ad-Hoc Analysis
• Report Library
![Page 30: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/30.jpg)
Exercise 9
![Page 31: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/31.jpg)
Exercise 10
![Page 32: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/32.jpg)
Exercises 9, 11 - 12
![Page 33: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/33.jpg)
Dashboard & Scorecard
• Current Year Actuals vs Version
• Scorecard view can be assigned to a user
• Trend Analysis & Exception Reporting
• Dashboards are driven from Scorecards
• Pretty Graphs and Charts
![Page 34: Enterprise Training](https://reader038.vdocuments.us/reader038/viewer/2022102902/558bfd5ad8b42af37e8b45dd/html5/thumbnails/34.jpg)
http://www.slideshare.net/craigcullum/enterprise-training