1 / 12

Managing Data with:

Managing Data with:. Management Reporter Business Portal, Business Analyzer, and SharePoint. May 9 , 2013 – User Group Meeting Claude White 302.384.9767 ( office) cwhite@intellitecsolutions.com 302.383.8952 (cell). Overview. Management Reporter – Key Features

desma
Download Presentation

Managing Data with:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Managing Datawith: Management Reporter Business Portal, Business Analyzer, and SharePoint • May 9, 2013 – User Group Meeting • Claude White 302.384.9767 (office) • cwhite@intellitecsolutions.com 302.383.8952 (cell)

  2. Overview • Management Reporter – Key Features • Business Portal – Impact GP/MR from the Web • Business Analyzer – Meaningful Analytics Inside and Outside of GP • SharePoint – Foundation of MR/BP Implementation • But Wait! There’s More!!!...Helpful Tips/Tools

  3. Today’s Goals… • Review Key Features of Management Reporter • Publish to SharePoint • Automatic Notification to user from SharePoint • Multiple Links to Row Definitions • Dimension Sets • Charts • Comments • Review MR reports without MR viewer • Security Groups • Report Scheduler • Limit access with Trees, One Report for Many Users • Links to other MR Reports • Link to External Spreadsheets • Send a report link via email to another user

  4. Today’s Goals… • Impact GP/MR from the Web with Business Portal • Make a Journal Entry • Perform a Customer Inquiry • Review Analytics from Business Portal

  5. Today’s Goals… • Deploy Business Analyzer for Quick Graphic KPIs • Select Metrics to view from within GP • Within GP (GP for last 12 months) • From BP/SP, SSRS-KPIs • Choose how metrics are viewed • Setup/view metrics from Outside of GP • View reports on SharePoint • Reports can be customized

  6. Today’s Goals… • Configure SharePoint to Maximize use of MR/BP/BA • Setup SharePoint to allow publishing from external sources • Key considerations for security/setup/naming conventions • Use SharePoint to notify users of updates • View MR reports on SharePoint without a MR viewer

  7. Let’s Begin… • Key Features of Management Reporter • Publish to SharePoint • Configure in MR • Configure in SharePoint • Automatic Notification to user from SharePoint (Library >> Alert Me) • Multiple Links to Row Definitions • Dimension Sets • Useable in Rows, Columns, etc. with regular dimensions. • 01 – Dimension Set in a Column • 02 – Dimension Set in a Row (Same Dimension Set) • 03 – Dimension Set in a Column (Same Dimension Set) • Charts, Comments (appear in excel extracts) • 01 – Dimension Set in a Column (Bar Chart in Excel Extract) • 04 – Monthly Income Statement for Bar Graph in Excel Extract)

  8. Let’s Begin… • Key Features of Management Reporter • Review MR reports without MR viewer • Security Groups • Discuss Bug, Pre-RU5, note Lumbergh in Summary and All Access Groups • Limit access with Trees, One Report for Many Users • Report Scheduler • Send a report link via email to another user • Link to External Spreadsheets* • Edit >> Row Links >> New • Links to other MR Reports*

  9. Let’s Begin… • Impact GP/MR from the Web with Business Portal • Make a Journal Entry* • Perform a Customer Inquiry • Review Analytics from Business Portal

  10. But wait, there’s more… • Report Groups before MR service pack RU5 cannot have a user in more than one group. Result: The user sees NO reports, not all they are assigned to. Scripts are available for pre-RU5 users to search for users in > 1 group. • Failed MR report notifications can be cleaned out of the notification window.A script is available. • RU5 defaults the reports to the web viewer. The option must be changed per each workstation. A registry edit is required to change this default. • The Legacy (xxx-curr) database is still required if you use multi-currency. This is due to change in RU6 (June, 2013). • The Legacy (xxx-curr) database has MOST but not all of the formatting fixes for MR. • The service account required for MR installation should to be a domain admin. Minimum requirements for non-domain service accounts include 1) Domain User, 2) Explicit, full access to the MR program directory. • Changing from the Legacy to DDM databases is time consuming. Yes, a script is available to help with that also. • Some MR installations may fail if the *.ldf and *.mdf files are notin the same directory. This is still under research… • Segment names in MR should match GP. Normally you change GP account format, but you can also make the change in MR with this script. (update ReportCompanySegment where…) in the MR database.

  11. Questions?… Surprise…Document Imaging, a very Quick Look. Formal presentation to come.

  12. Thank youfor attending The May 2013 User Group

More Related