Posts

Posts

  • Amit Agarwal
    Inserting a Particular date in a Report with Web Reporting...5.0
    Topic posted October 11, 2019 by Amit AgarwalBlue Ribbon: 750+ Points, tagged Reports, Smart View in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Inserting a Particular date in a Report with Web Reporting Studio
    Summary:
    Insert Date in a Report
    Content:

    Hi Champions,

    I have a specific requirement. I have designed reports in Web Reporting Studio and at the top of the report I want to insert the date as last day of the month whenever the report is run. For example - for October report whenever its run irrespective whenever I run the report, I want the date to be as 31st October, 2019.

    What Function do I use for this purpose?

    Thanks for your help in advance,

    Amit

  • Nouria Kehli
    FCCS with SV: How to display the parents of shared members...Answered2
    Topic posted October 8, 2019 by Nouria KehliGold Medal: 3,500+ Points, tagged Forms, Smart View in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FCCS with SV: How to display the parents of shared members in ad-hoc analysis
    Content:

    Hi all

     

    Anyone has a trick / settings where I can defined the display of the same Dimension which has 2 separate parents under a Smartview ad-hoc analysis?

    We have Entity xxxx under the main hierarchy and in the Geography hierarchy too, like a shared member. 
    When we do an ad.hoc analysis with Smart View, we can select the entity with one parent or the other one, but when we  refresh the parent is no longer displayed and we can no longer tell from which parent is the entity xxxx displayed comes from.
     
    Is there a way to see the parent and the xxxx so we have a clear analysis?
     
    Thank you 
    Nouria
     
     
  • Elisa Fernandez
    PJTD in Smart View1
    Topic posted September 25, 2019 by Elisa Fernandez, tagged Essbase, Smart View in Business Analytics > Essbase public
    Title:
    PJTD in Smart View
    Summary:
    Select PJTD as AMOUNT TYPE
    Content:

    Hello All

    New to Oracle Fusion and the Smart View world.

    Quick question is it possible to select PJTD (Project to date) as the AMOUNT TYPE ?

    As it is not included in the drop down.

    Scenario = Actual

    Thank You

    Elisa

     

    Version:
    Oracle Cloud Application 19B
  • Ayeshan Peiris
    FCCS_Mvmts_Total of base entities doesn't aggregates to...7
    Topic posted September 24, 2019 by Ayeshan PeirisSilver Medal: 2,000+ Points, tagged Consolidation, Dimensions, Smart View in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FCCS_Mvmts_Total of base entities doesn't aggregates to FCCS_Mvmts_Total of parent entity only for Aug
    Content:

    Hi All,

    I have come across an issue where FCCS_Mvmts_Total of base entities doesn't aggregate to the FCCS_Mvmts_Total of parent entity only for the month of Aug. Prior months are aggregating correctly. I have tried all the operations such as running force/regular consolidation,refresh database, clearing out all the data for the month and reload then consolidate,but didn't resolve the issue.

    Note: consolidation operator for the all the entities have set to "Ignore"

    Why is that? any settings I have missed? appreciate your help on this matter.

    Please refer the screenshot

    Regards,

    Ayeshan

    Image:
  • Jenny Tan
    Smart View Error message "The data entered is wrong, so...3
    Topic posted September 6, 2019 by Jenny TanBlue Ribbon: 750+ Points, tagged Smart View in Business Analytics > Essbase public
    Title:
    Smart View Error message "The data entered is wrong, so it will revert to the previous value"
    Summary:
    The data entered is wrong, so it will revert to the previous value
    Content:

    I have created a smart view file that has a lot of columns.  There formula involved that aggregate the values retrieved from essbase as well as grouping of rows to collapse the rows..

    I have been getting this error later when I clicked on to expand the rows.  What did I do wrong?

     

    The data entered is wrong, so it will revert to the previous value

  • Richard Chan
    Performance problems1
    Topic posted August 1, 2019 by Richard ChanSilver Medal: 2,000+ Points, tagged Narrative Reporting, Report Packages, Smart View in Enterprise Performance Mgmt > Narrative Reporting public
    Title:
    Performance problems
    Summary:
    Users are reporting performance problems across the board
    Content:

    Users in India have reported timeout issues e.g. when checking doclets in

    Anything involving building the complete report pack e.g. Preview/review activities takes a while (pack has close on 100 doclets now) (India and Australia

    Has anyone else experienced performance issues ?

     

  • Laura Ferris
    See What's New in Narrative Reporting for 19.085.0
    Topic posted July 31, 2019 by Laura FerrisSilver Medal: 2,000+ Points, tagged Management Reporting, Narrative Reporting, Smart View in Enterprise Performance Mgmt > Narrative Reporting public
    Title:
    See What's New in Narrative Reporting for 19.08
    Summary:
    Read about what's included in Narrative Reporting release 19.08.
    Content:

    Read about the updates for Narrative Reporting in the What's New document for release 19.08.

    The new functionality available in this update includes:

    Conditional Text in Management Reports: You can use the Conditional Formatting framework to generate dynamic text based on predefined conditions and a combination of static text and text functions, which return member labels and data values to complete the resulting text. The Conditional Text results can be displayed in a text box, row, column or cell utilizing a new text function.

    New Narrative Reporting Smart View Extension: The Narrative Reporting 19.08 Extension for Oracle Smart View for Office is available. This update includes an improved Embed Contents dialog, along with general performance improvements and bug fixes.

  • Lilas Qu
    Essbase connection on Smart View change to newAnswered2
    Topic posted July 29, 2019 by Lilas QuGreen Ribbon: 100+ Points, tagged Smart View in Business Analytics > Essbase public
    Title:
    Essbase connection on Smart View change to new
    Summary:
    Is there a quick way to update SV connection on existing Essbase retrieve files?
    Content:

    We upgraded the Hyperion applications and users need to change to new connections on Smart View.

    When they open a Essbase retreive file, it still prompt them to connect to the old database (even though the old connections have been removed from Smart View already). They have to go to each tab, connect to the new database, click on "Ad hoc analysis" so that it takes the new connection.This only needs to be done once per tab. But it's still a lot of work.

    It seems the Essbase connection is stored as a "memory" in the files? Is there a way to quickly switch the files to the new connection? Thank you!

     

     

  • Arcanus Prime
    SmartView Backwards Compatible with older version of Excel1
    Topic posted July 22, 2019 by Arcanus PrimeGreen Ribbon: 100+ Points, tagged Essbase, Smart View in Business Analytics > Essbase public
    Title:
    SmartView Backwards Compatible with older version of Excel
    Summary:
    Is SmartView 11.1.2.5 900 compatible with older version of Excel
    Content:

    Hello Essbase World,

    I have a question about SmartView and Excel when connecting to Essbase.  Is the newest version of SmartView (11.2.5 900) backwards compatible with older versions of Excel?  If so, what is the oldest version of Excel that it works with?  We are looking to troubleshoot some problems with SmartView, and need to know compatibility.  I do know from the compatibility matrix that it states in text that SV 11.1.2.5.000 onwards supports Office 2013, 11.1.2.5.520 onwards supports MS Office 2016, 11.1.2.5.900 onwards supports Office 2019.  It doesn't state whether newer versions of SV will support older versions of Excel.  

    Any help would be greatly appreciated.  

  • Richard Chan
    The formatting changes between the Word doclet and the Excel...Answered25.0
    Topic posted July 16, 2019 by Richard ChanSilver Medal: 2,000+ Points, tagged Narrative Reporting, Report Packages, Smart View in Enterprise Performance Mgmt > Narrative Reporting public
    Title:
    The formatting changes between the Word doclet and the Excel Reference Doclet
    Summary:
    The formatting changes between the Word doclet and the Excel Reference Doclet
    Content:

    The formatting changes between the Word doclet and the Excel Reference Doclet

    e.g. positioning of the labels, data lines and some degradation of quality (resolution has dropped)

    So image in the Word doclet looks different from the Excel Reference doclet, this is using a names range and Embedded object

    This appears to be the label length that causes the non-resolution format issues as having one character works