Reports
Discussion List
-
How to get member aliases from row dimension set as "Children of" in ReportsSummary: Planning - Reports Content (required): Hi, I have a report with 2 row dimensions. The first row dimension is set as "Children of [Total Expenses]", the second o… -
IfThen formula function Management reportSummary: Hi All, For a specific report I have been using the formula function "IfThen", but I am struggling to have the falseparameter defined properly. The goal is to g… -
Announcement: Financial Reporting change in behavior for valid intersections in 23.05UPDATE: This will no longer be an issue in 23.05, a bug related to this has been addressed. In the 23.05 release, Financial Reporting (FR) will now filter and restrict d… -
Oracle Reports Output to ExcelSummary: Working in Oracle EPM Cloud (Planning) and have reports the users want defined in Excel but, it limits to 100 worksheets when we need a 110 worksheets to genera… -
Is it possible to have an FR report in the Enterprise Planning pod get data from multiple apps?Summary: Content (required): We are migrating Hyperion on-prem applications to Enterprise EPM cloud. There is one Enterprise Planning application with custom cubes and o…
-
Map Smart List in BSO to Dimension in ASO - Text Account Display as Text not Essbase IDSummary: We are exploring the use of the functionality to map a Smart List to an ASO dimension via data map so that a report can be pulled in Management Reporting using … -
How to design the report in Financial Reporting Web Studio ?Summary: In FRS , when giving a custom heading to a dynamic calc member , how do we avoid the children taking up the same custom heading as the parent member in the HTML…
-
Group columns for expand / collapseSummary: In excel grouping columns / rows so you can expand and collapse them is often used function for reports. Is there an equivalent in Oracle Planning? Content (req…
-
Suppress Missing Blocks - Identify intersections of data that exist, but have missing blocks?Summary: Using a form, we are suppressing Missing Blocks to ensure that we do not hit the data governor. In validating the forms, we discovered that the checkbox "Suppre…
-
EPM Budget Revisions - Reporting ideasSummary: How are Budget Revisions users reporting on the revisions? Content (required): I have had many requests to build EPM reports that show various revision data aft… -
White space added in PDF book reportSummary: For some of our users, when they generate the PDF output of a book in some of the text boxes white spaces are added. When they run the individual report, the te…
-
Best way to match Scenario with the corresponding Year members in Management Reporting?First, our situation: We have a Scenario dimension containing members such as: FY23 Budget (Budget created in FY23, for the years FY23 and FY24) FY23 Forecast 2 (Forecas… -
Migrate reportsSummary: Report not being updated when migrated to different environment. Content (required): Hi all, We have encountered an issue in the following situation: Goal is to…
-
Management Report Export in ExcelSummary: Content (required): Hello, We have a requirement that client want to export the report in the different tabs of the excel for cost centre dimension. We have mor…
-
Batch Scheduler in PBCSSummary: Looking for way to kick off 45 batch scheduled reports at once Content (required): We have 45 scheduled batch reports that currently run as "Perform Monthly" on…
-
PDF output not the same as HTML output reporting 2.0Summary: Report output in HTML is not the same as the report output in PDF. Formatting is different for some of the rows. Content (required): For 2 reports, the PDF outp…
-
Best method for reports to maintain a user's last entered POVSummary: Our users would like the last POV entered when running a report to come up every time. We're looking at user variables but this seems like it may take some work… -
Enable "save as smart form" button in SVSummary: Hi All, I'm doing some testing on the subject of smart forms as I believe this form type might be of relevance for a customer. Then again, Smart View does not s…
-
Non-Aggregating Statistical Accounts and Weighted Average in Sparse DimsOk Team... We have a variety of Workforce statistical accounts that we want to report out of an ASO Cube (we technically push the data from WF to FS, then report out of …
-
any prebuilt ESG application to download?Summary: Deep Dive into an ESG application/package Content (required): We are looking to deep dive on ESG and see what can be leveraged in EPM Planning. Version (include…
-
Is there an alternative to using Use Allow Expansion and Suppress Missing Blocks in FR reports?Summary: We have a FR report for payroll with one column called Other Compensation in which one of the grid POV is an alternate hierarchy for Earn Code which is set to A…
-
Bursting Definition - Security IssueSummary: Bursting Definition - Security Issue Content (required): Hello, We have one report where we took cost centres on a row. When user select parent cost centre then…
-
EPM performance score cardSummary: As part if enterprise edition, do we have performance scorecard as out of box feature? Content (required): As part if enterprise edition, do we have performance… -
Suggestion for an easy method : Financial reporting studioSummary: Suggestion for an easy method : Financial reporting studio Content (required): Hi We are using a PBCS Application, and is in the process of creating an income s…
-
Dynamic time series feature in Financial reporting studioSummary: Dynamic time series feature in Financial reporting studio Content (required): Hi This is a PBCS Application and We are in the process of creating a FRS report. …
-
Formula rows/columns from reports in ad hoc gridsSummary: Hi all, As I was opening reports in Smartview, I noticed that my formula rows / columns from the reports are not imported (everything is there accept for the fo…
-
Is there any way to change the order of displaying prompts in Run Time Prompt Window - ReportsSummary Looking for option to change the order of displaying prompts in a Run Time Prompt Window (Financial Reports)Content Hi All I'm looking for option to change the o… -
Referencing Smart List (Created from Members) Value in FR ReportSummary: The requirement is to perform conditional suppression based on a Smart List value within the body of the report. Normally, this would not be an issue because we…