Narrative Reporting

Enterprise Performance Management

Comments

  • Dave Roberts

    Customers typically load data from one business process to another for reporting purposes.  For example, a report with Actual vs Plan data sourced from the different business processes.  If that's not what you are doing, then just using the reporting solutions on each business process should suffice without needing load data between them

  • Michael Krichevsky
    • posted via email reply November 1, 2019
    • Permalink
    Dave,
    
    I was comparing FCCS to EPBCS.
    
    I'm trying to understand what would be the main reason to replicate Budget data in FCCS if reporting capabilities between two modules are identical.
    
    Thanks,
    
    Michael.
    
  • Dave Roberts

    Hi Michael,

    I don't know if you are referring to Financial Close and Consolidation having more robust reporting, etc than Planning or Management Reporting/Narrative Reporting?

    Both business processes (Financial Close and Planning) can utilize FR, Smart View, Dashboards against the same data source its hosted on, not cross cloud. So, if you need that interactivity and specific dashboard features with data from both sources, it makes sense to load from one to another to combine them. In Smart View you can obviously use separate sheets to retrieve data from different sources and combine them via Excel formulas on a 3rd sheet.

    Narrative Reporting provides the workflow and framework for easily combining data and narrative in one solution, which the other business processes do not have.  Management Reporting has the cross-cloud reporting and other enhanced reporting features and authoring experiences over FR.

     Regards,

    Dave

  • Michael Krichevsky
    • posted via email reply November 1, 2019
    • Permalink
    Dave, Thank you for the prompt response.
    
    Based on what you said is it fare to say that FCCS has more robust reporting and dashboarding capabilities?
    
    Thanks,
    
    Michael.
    
  • Dave Roberts

    Hi Michael,

    I think this is dependent on your reporting requirements and how deep they are.  If you need to just show Actual vs. Budget in a few formatted reports, with no need to show this Smart View or dashboards, then pulling in a column from each business process source might make more sense.  Here are a few relevant doc links from the MR designer guide:

    Using Formulas to Reference Other Grids in the Same Report
    About the Grid Point of View
    Point of View Examples

    If you need to query and interact with data from both business processes in Smart View and Dashboards, it might make sense to load data from one business process to another.  I can't speak to the data integration aspect of it, as that's outside of my expertise.

    Hope this helps.

    Regards,

    Dave

  • Michael Krichevsky

    @Dave Roberts.

    Hi Dave,

    Just came across this post and your answer... it is the closest to my question. so I was hoping to leverage your expertise. 

    We are implementing parallel FCCS and EPBCS and I am looking for clues on best practice on the reporting side...

    EPBCS will be used for Budgeting and forecasting and FCCS for consolidation. Does it make sense to load budget into FCCS or keep it just in EPBCS, so all the MR to be done from EPBCS and all Statutory reports produced out of FCCS.

    Any advice/leads/materials related to it would be appreciated.

    Thanks,

    Michael.

  • Dave Roberts

    To clarify, on-prem Disclosure Management reached its end of life with the 11.1.2.4 release, there is no further Development being done on it.  

    In Narrative Reporting/Disclosure Management, Smart View would need to be used to connect to HFM.  Disclosure Management has never has direct connectivity to any data sources, it has always used Excel or Word based content via either Smart View or other ad-ins to 3rd party sources

  • Daniela Morais

    On premise could be Disclosure Management and HFM as Datasource?

    and in cloud as to be Disclosure and Narrative, and use Smart View + Excel, that's it?

     

  • Al Marciante

    For the ESEF format, you would use Disclosure Management within Narrative reporting, and use Smart View + Excel to format your financial statements to include.

  • Daniela Morais

    The purpose it's to generate reports in European Single Electronic Format (ESEF) with HFM data.

    So, we can do it based on smartview with HFM data? that's it?

     

  • Dave Roberts

    Hi Daniela,

    While you cannot connect Management Reporting to on-prem data sources, in a Narrative Reporting report package, you can use any Excel-based content (including Smart View against HFM) to insert grids and charts into report package doclets, or as a doclet in a PDF report package.

  • Opal Alapat

    HFM is currently not a supported data source in the Management Reporting tool. I’ll leave it to the Product Mgmt team to communicate whether or not this capability will be possible in the future.

    In the Narrative Reporting tool (of the umbrella suite also called “Narrative Reporting”), it is supported. Basically, if you can get it into Excel (via whatever version of Smart View, although the recent version is recommended), you can get it into Narrative Reporting. You just need to download and install the Narrative Reporting Smart View extension.

  • Cassandra Marcus

    What about adding a Month End Date as a UDA / Member Property or putting it in the Member Description in the time-based dimension in the report?  It prevents the need to update multiple reports, multiple times a year with the exception of a leap year. 

  • Amit Agarwal

    Hey Thanks Dave. I will give it a try and let you know how it went. 

    Cheers!!

    Amit

  • Dave Roberts

    Hi Amit,

    There isn't a text function in FR to return the last day's date, the Date function just returns the date the report was last run.  The only workaround I can think of is to manually populate a date measure in your data source with the end of month date every month, retrieve it using a hidden grid in FR, then display the value using the GetCell function.  I haven't personally tested this, but it should work.

    Regards,

    Dave