Posts

Posts

  • Ganesh Sankaran
    EPRCS Disclosure Management Issue1
    Topic posted November 21, 2019 by Ganesh Sankaran, tagged Application / Data, Narrative Reporting, Smart View, XBRL / iXBRL in Enterprise Performance Mgmt > Narrative Reporting public
    Title:
    EPRCS Disclosure Management Issue
    Summary:
    EPRCS Issue: After creation of disclosure master document we are unable to manage the individual doclets, at times get error: need to migrate doclet, xbrl tagging issue also
    Content:

    After creation of disclosure master document we are unable to manage the individual doclets added to the master document. We have multiple issues-
    1) we are unable to open a certain doclet which says file formatted not supported especially when trying to open xlsx format.
    2) At times when trying to access a doclet, it throws an error repository item unavailable and it gives error" Need to migrate the doclet".
    3) Once a disclosure master document is created and doclets are added during the first instance, we are unable to manage the doclets there after.
    4) Once the taxonomy is uploaded in taxonomy manager, we are unable to do XBRL tagging for that taxonomy.

    Please help.

    Version:
    SmartView Version: 11.1.2.5.900 (Build 093), MS Office 2016, Browser: Chrome
  • Jane Richter
    Named Ranges in Doclets15.0
    Topic posted November 13, 2019 by Jane RichterGreen Ribbon: 100+ Points, tagged Management Reporting, Report Packages, Reporting Workflow, Smart View in Enterprise Performance Mgmt > Narrative Reporting public
    Title:
    Named Ranges in Doclets
    Summary:
    Can named ranges be refreshed without checking out
    Content:

    Hi All,

    As I am creating demos of EPRCS and using the SmartView capabilities to highlight charts as named ranges. I am wondering if there is capability for named ranges to refresh in reference doclets without the user having to Check Out> Refresh> Upload & Check In. 

    What seems to be more user friendly is if there was a way to go to the Doclet and being able to click refresh there, and the chart (named range) refreshes. 

    Does anyone know if this is possible? 

    Thank you!

    Jane

  • Steven Getze, CMA
    Smartview ExtensionsAnswered2
    Topic posted October 21, 2019 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Smart View, Supplemental Data, Task Manager in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Smartview Extensions
    Summary:
    Grayed out items?
    Content:

    I downloaded the Smartview extensions for Close Tasks and Supplemental Data ... I have these in my FCCS application and can see the new ribbons for both in Excel, yet all options are grayed out.   In SmartView options, both of these are selected as "Enabled".  Anybody know what I'm doing wrong?????

  • Steven Getze, CMA
    Valid Intersection Configuration4
    Topic posted October 18, 2019 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Automation, Data Integration, Dimensions, Income Statement, Insertion Points, Reports, Smart View in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Valid Intersection Configuration
    Summary:
    Has anyone successfully developed?
    Content:

    In my Test application I have configured our full set of specific GL Account & Department Valid Intersections (each "rule" is composed of the account, its associated "valid" department combinations, plus the years of 2018 thru 2021).  This is necessary, because we occasionally see invalid combinations in entity loads but have no way to identify them; the presence of them causes FCCS's Net Income to be incorrect.  Now I am testing and viewing available reporting.   As a test, I loaded an entity load file to August 2019 via Data Management that includes an invalid account/department combination, and expect to see this invalid combination when I run an Invalid Intersection report.  But, I do not, even when I create the report that include the specific "invalid" intersection.   Additionally, when I run an "open" report with no optional dimensions, I only get data for FY2015.   This makes no sense, since I identify only FY18 thru FY21 within the rules .   

    I suspect my configuration is flawed - it seems straightforward so I have no idea what is flawed.   I can find nothing in Oracle publications to assist me. 

    Has anyone successfully developed Valid Intersections in FCCS who can tell me what I'm doing wrong?   I have attached an excel file that shows the invalid combo in an adhoc plus screenshots of my configuration.   I appreciate any guidance.

  • Amit Agarwal
    Inserting a Particular date in a Report with Web Reporting...25.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 KehliBronze Trophy: 5,000+ 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 ?