Category 101-2
Discussion List
-
How to sum the data of alternate hierarchy?Hello everyone, I have one question about the function for sum data of alternate hierarchy. I have Hierarchy which is like this: And member A4 appears under both hierarc… -
Mac Smartview Manifest AddinSummary: Dear all, For a customer I'm configuring Smart View for Excel on a Mac PC in order to have the ability to connect to Planning information (ad hoc, forms, report… -
Validation Rules not working on forms in Smart ViewSummary: Content (please ensure you mask any confidential information): When creating a validation rule on a form and selecting cell styles in Smart View (default), the …
-
Access for sensitive data EPM WorkforceHi We have selected level of workforce detail to manage at the Employee and Job level. and decided to upload actuals of employee compensation. But as per the HR policy n…
-
How to give user access to edit dimensions but not give the service administrator role?Hi, We have a EPBCS planning application. We want to give users access to edit the metadata through web application dimensions editor. But we do not want to give them se…
-
Is it possible to purchase an additional BSO cube for an EPM Standard subscription?Summary: I have a Standard subscription, and I need an additional free BSO cube to consolidate two models.
-
Not able to see data row(s) in HTML preview in Reports in EPMI created a report under Reports in EPM. I can preview and see the data rows in PDF and Excel preview but row header or data show up or display in HTML preview or format…
-
EPM SWPI am looking for guidance on how to effectively implement the Oracle EPM SWP module. Your expertise in this area would be invaluable in ensuring a successful integration…
-
How to setup Project Budget Approval Workflow by converting the budget amount into USD currencySummary: How to setup Project Budget Approval Workflow where Project Currency is different from Planning Currency (USD) and approval threshold is in USD. Content (please…
-
How to delete seeded report from SM Model?Summary: I have created a model using Standard Template in Strategic Modelling. I can see there many seeded report available (please find below screenshot). Is it possib… -
Special Character in Narrative Reporting Bursting POVSummary: Users encounter Smart View error "Member [xyz] is an invalid selection for POV dimension [Department]" when opening a narrative report created by a bursting def… -
How to re-calculate YearTotal based on requirement when it is dynamic memberHello everyone, I am trying to calculate the % of net sales for my GL accounts. All my GL accounts are setting Account Type is Expense/Revenue and Time Balance is flow: …
-
SWP Module - Gap Closure Forms, related SWP Gap Closing Accounts, Dashboards are missingSummary: We set up SWP and configured SWP (not WFP) some weeks ago. Without Currency, but with 3 Custom Dimensions. Forms, Dashboards, Calculationlogics appeared to work…
-
Adding a custom dimension to Planning does not show in the Planning Admin extensionSummary: When I add a custom dimension, either through DM or manually, the added dimension does not show in the Planning Admin Extension in Smartview under dimensions. I…
-
Burst Report FormatSummary: I've created a book that bursts to multiple pages. By default, the Report Format shows PDF. I know users can opt to change it to Excel when they run the report,…
-
What does the displayversion mean in the Smartview XML file?Hi, In smartview, we have the option of creating a XML file containing all required connections. The syntax for Planning connection is below: Oracle doc: Setting Up t…
-
custom planning performance suggestionsHi, We are on EPM Cloud planning – custom workforce module of employee level planning. (~12k employees). Wanted your guidance on the design perspective, from performance…
-
IRR (internal rate of return) and NPV (net present value)Client need to have these features - IRR (internal rate of return) and NPV (net present value) in EPBCS. Are these features available in any of Out of Box modules like S…
-
Shared Member Security inherited even when Shared Members not in CubeSummary: Confirming the expected behavior for Shared member security provisioning in Entity Dimension Content (please ensure you mask any confidential information): Addi…
-
Is there a way to allow member selection in SmartView form?Summary: Is it possible to enable "member selection" in a dimension in the page section of a form in SmartView like it is enabled in the web in the same form? Content (p…
-
Using new Reports, how can you create with a prompt and also POV?In the old Financial Reporting, you could create a way to select a member via a Prompt and have it show up in the POV returning the selected dimension member, and then c… -
Trouble when using Calculate Currency in PBCSHello everyone, I am trying to convert the local currency to the reporting currency in PBCS by using "Calculate Currencies" . Step 1: I input the exchange rate in the sy…
-
Smartview: drill region is not available, operation is cancelledSummary: I have a power user attempting a drill-through on actuals to which they have access (they can see the value). However, when he tries to drill-through, he gets t…
-
How do you favorite webforms to show on the EPBCS Home Page?We are looking for a way to allow users to favorite webforms in EPBCS so that these forms appear on their home page for quick access. We found that dashboards can be add… -
Auditing of Users Running Financial Reports/Management Reports in Oracle EPM Cloud PlanningOur institution is seeking a way to retrieve how often our users run Financial Reports and/or (Management) Reports and the names. We understand that there is an Activity…
-
How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?Summary: I need to integrate the p_start_date and p_end _date parameters into this query in BI Publisher Content (please ensure you mask any confidential information): V…
-
Push Sparse Dynamic Calc BSO data to store member in ASOSummary: I have a member formula in Plan Element to calculate for % Sales. This member in Plan Element is a Dynamic Calc. I want to push the data to a store member in AS…
-
Cannot export YTD Period's data when using data exportHello everyone, I am using PBCS (which does not support Groovy). When we tried to export data from Navigator » Overview » Actions » Export Data to export YTD data: It sh…
-
Advise on Member formula for Average of an accountSummary: Hi Team, We have Account 1 = "Number of people" Account 2 = Average of Account 1 We have set Account 1, time balance property = "Balance" Account 2, time balanc…
-
Power user is not able to insert data at Year total in SmartviewSummary: Power User is not able to submit data when opening a form in SmartView. The cells are yellow but on submitting the data and running the business rules attached …