To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Narrative Reporting
Discussion List
-
calculate percent of total on a dynamic set of rowsSummary: i'd like to have a row on a report where the member set is dynamic (i.e. bottom level or children) and have a formula that calculates the % of total for each ro… -
How can I SUMIF greater than zero? In Excel the formula is =SUMIF(C6:C22,">0")Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):User_2025-02-11-09-50-09-390 21 views 3 comments 0 points Most recent by User_2025-02-11-09-50-09-390 -
The "Cur" member in Text Function doesn't appear to exist in Mgmt ReportingIn the Financial Reporting Tool, I was able to reference a Current Row on a Report to get a dynamic member to pull. It would look something like this: AncestorName("Posi…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.04What’s New in EPM Cloud Narrative Reporting and Reports Release 22.04 Please refer to the April 2022 What's New Guide to understand the new features included in EPM Clou… -
Unable to add Group on for Cost center on the FRS reportSummary: I have a FRS report with entity, Cost center and Account with row access. Column A- "Scenario B-Version B " Column B- "Scenario B" as column access for &CurrBud… -
Reports using the Except FunctionSummary: I have a list of all P&L accounts. I want to allocate them into three buckets. I want to add some members manually to the first 2 buckets and then have a list o…
-
Was "Download as Excel Ad-hoc" option decommissioned?Hello, Here is what I had yesterday in our production environment: Here is what I have today: What happened?
-
Error when creating a book in Narrative ReportingI tried to create a book. Added a report to the book and clicked OK. And got this error message: What does this error mean? I've been building books in an EPBCS environm…
-
How can I make columns not visible without hiding them?I'm trying to build a report that will be both viewable through a web browser and exportable to Excel as an ad-hoc. I have years, scenarios, and versions in columns; ent…
-
Automatic grid sizing into the pageSummary: Guys I have a question. We are creating a report for the report package and there are some grids that need to show only the months that have values. The grid is… -
Merging multiple word doclets into a single page in report packageSummary: Option to merge multiple word doclets into a single page number in report package Content (required): We have a requirement to split sections of the annual repo… -
Typeahead using aliasesIs it possible to configure typeahead to use aliases instead of member names? For instance, I'm trying to find "Total Income" account that has a member name that doesn't…
-
Proper environment for building reportsWhat is Oracle's position/recommendation on the proper requirement for building the reports? Should the reports be built in the Test environment first and then migrated …
-
Changing default settings for a book TOCSummary: Is there any way to have MemberAlias in the TOC section as a default option instead of MemberName? Thanks!
-
Times Series Function on Quarters, i.e. N quarters ago?Summary: We need time series functions on quarters, i.e. last quarter, 2 quarters ago etc. When doing the below this does not consider the year dimension and loop within…
-
Is it possible to copy/paste multiple members?Summary: I want to put several accounts into one row. I have a list of these accounts: If I just copy/paste them like that I will get this error message: Is there any wa…
-
Book POV selectionAdding this idea as Narrative Reporting but please move or let me know to resubmit if it belongs elsewhere. Would like Reporting books to have a book POV where reports i… -
IfThen provides incorrect result in combination with conditional formatting/replacementSummary: I have accounts with some UDAs assigned. I'm using text function MemberProperty("Account", "UDA") to pull these UDAs, and then I'm using conditional formatting …
-
Can I use Member Selection functions in combination with dimension POV?Summary: I want to build a report where I will select a member (say, POV for Entities), and the report will display this member and its children. Something like that: Th…
-
Can I migrate a report from Planning and Budgeting Cloud to EPM Cloud Narrative Reporting?Summary: That's basically it. I will need to build a report using an Essbase cube, but this cube is not ready yet. I have a cube with the same structure in an EPBCS envi…
-
Question on Available Charts / Chart Types and Displaying IconsSummary: Display icons to show "increase" or "decrease" in values / amounts Content (required): Wondering how we display icons to show "increase" or "decrease" in values… -
Is it possible to limit the scope of Zooming?Summary: In the report I have the following design: Account A.1 Account A.2 Account A.3 Account A Accounts A.1, A.2, and A.3 are children of account A. I want the users …
-
Narrative Reporting - background home pagecan I use an image from Oracle ERP as a background image in NR? or is there a copyright issue?
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 22.03What’s New in EPM Cloud Narrative Reporting and Reports Release 22.03 Please refer to the March 2022 What's New Guide to understand the new features included in EPM Clou…
-
Report FormattingSummary: Is it possible to combine different orientations in the same Report? For example, I want my first 2 pages to display in portrait mode and the 3rd page in Landsc…
-
ERP Access needed in narrative reportingSummary: in Narrative Reporting, we are using a generic user to connect EPRCS to ERP. But we have a data access issue. A user with no ERP access cannot view ERP data in …
-
Can I group columns for zooming?Summary: My report has three columns - Scenario 1, Scenario 2, and in-report calculated variance. Both scenarios have multiple selection options, so adding calculated in…
-
Busting Definition - Sending All reports in one meailSummary: Can we use the Target Distribution file to send multiple reports in one email? Content (required): As I know we can distribute the reports using either Target D…
-
Reports usage analysisSummary: Is there any way to analyze usage of Reports? Who ran them, when, what reports, POVs/prompts, if possible? Thanks!
-
Narrative reporting/EPRCS performance and capacity questionSummary: Need some information on EPRCS performance and capacity Content (required): We have an EPRCS instance where we have circa 200 users who work on around 250 repor…