Reports
Discussion List
-
How to Extract Text that doesn't has a fixed length of characthers using Text/ Conditional F.Summary: Using EPM Management Report I see this options for Mid Text Functions: Left/Right/Mid Left, Right, and Mid allow you to trim text from the results of other text… -
EPM reports - how to assign a grid row to a bar and another grid row to a line in combination chart?I'm migrating reports from report studio to reports but cant seem to find the option in the new reports to allocate a grid row to a bar and another row to a line. I have… -
grid sharingSummary: Content (please ensure you mask any confidential information): Hi In FRS, there was the option to save as a grid in report, and then use that grid in another re…
-
Is there a dashboard, report, or audit log that shows which users accessed which modules and when?Summary: Is there a dashboard, report, or audit log that shows which users accessed which modules and when? Content (please ensure you mask any confidential information)…
-
How do i create a member formula to pull for children as wellI would like to create a scenario member with a member formula that will calculate the variance between two columns in my management report. Then when I drill into the, …
-
Report Formatting - Dynamic Portrait vs Landscape or Book overrideSummary: When building a report, is there any way to have it dynamically set portrait vs landscape based on POV or to have a book override the page orientation that is s…
-
I want to automatize the collection of query data for query tracking aggregation processSummary: Optimize ASO aggregation by enabling query tracking Content (please ensure you mask any confidential information): Hello the community, we want to automatize th…
-
Users are unable to run batches / books in Explore RepositorySummary: Users are unable to run batches / books - failing with "The Database Connection could not be found: DTS" . Kindly help resolve this issue . Content (please ensu…
-
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
EPm Cloud new Reports logo positioning is incorrect after migration from FRSummary: Content (please ensure you mask any confidential information): Hi all After the migration of FR reports to the new REPORTS, the logos do not remain in position.… -
grid promptSummary: Content (please ensure you mask any confidential information): Hi I migrated FRS report to Reports folder. The report consits of multiple grids, with every grid…
-
We want to dynamically change the formula for a Total based on the Month of the Calendar Year(FRS)Summary: Hi Team, We have a formula Cell in FRS Report where the sum is multiplied by the Number of Months. Right now the formula is Static, but we need the formula to d…
-
Is it possible to have dynamic columns in FCCS/Planning reportsHi Team, We are trying to built report in Planning with the dynamic columns but seems there are not much options. We wanted to populated completely different set of colu…
-
Converting Forms to Reports:Similar to Dashboard ConversionSummary: We have a requirement to view forms as reports. We've noticed an option to convert forms to dashboards, and we would like a similar functionality. This would al…
-
Descendants before childrens option in ReportingSummary: Content (please ensure you mask any confidential information): Hi all Can someone please confirm if there there is an option to display "descendants before chil…
-
Copy URL functionality in Reports not loading the report since updating to redwoodSummary: We have been using the copy URL feature in EPBCS for some time but since updating to redwood we have found that some of our reports are no longer loading throug…
-
Oracle Fusion ERP Cloud Receivables Transactions Integration with EPM CloudNeed: Steps or processes to be followed to integrate Receivables Transactions from Oracle Fusion ERP Cloud. Summary: We have a requirement in which we want to get Fusion… -
alignment issues in EPBCS reportsSummary: While trying to create a report in epbcs, I am trying to put a graph and grid side by side and they will always have alignment issues in size though size, width…
-
EPBCS Report BuidingWhat is the best way to create a report from different cubes from epbcs, Where we have different prefixes for the metadata from account dimension members? Eg : TPF_ABCD(…
-
Text String to Number Function in Management ReportingSummary: We have a report requirement for which I need a substring of a number from a member name to use in a formula in the report. Is there any way to achieve this wit…
-
Burst Reports with Custom Email FromHi All The default email is no.reply@epm.oraclecloud.com for all our epm planning environments. If I'm bursting reports to various users its easy to get confused as to t…
-
Is it good idea making all Dimensions Dynamic calc for Freeform application (Hybrid BSO)Summary: Is it good idea making all Dimensions as Dynamic calc(Parent members) for Freeform application (Hybrid BSO). Single BSO cube application. We have one large cust…
-
Possibility to have several logos associated to the same reportSummary: REPORT Module - Dynamic Logos Content (please ensure you mask any confidential information): Hi all Is there a way to associate several logos to the same Report…
-
oracle epm narrative reporting, can I choose a specific day for running reports. e.g 31/12/2022Summary: My client wants the ability to run a report, and the two grids on the report show for example, 31st June 2023, and the second grid to show 31st Dec 2022. Is thi… -
How to get dimension security groups working in the new reports module?Summary: The new reports module seems to not enforce dimension security and our users are able to see entities outside of their security group that's assigned in the dim…
-
Management Reporting: Function for Trailing Twelve Months (using Range & Period Offset NOT working)Summary: I have a TTM (trailing twelve month) P&L report that works perfectly when i pick any period except DECEMBER. When I pick December, it gives me some strange outp… -
Report with Multiple Prompts or Current POVSummary: I want the user to be able to select their POV for more than one dimension. Content (please ensure you mask any confidential information): I'm trying to create … -
Edit prompt option not working in smartviewHi Team, We have generated MR report in the smartview but the option of Edit Prompt in the Smartview ribbon is appearing as greyed out , not able to select the prompt in…
-
planningI have loaded data into preproduction and am able to retrieve those in smartview but I am unable to fetch the data in Narrative report instance. However I have checked t…
-
How to change the result of OEP_CurQtrSummary: We have this substitution variable called OEP_CurQtr that does change based on whatever is selected for current month. If I were to change OEP_CurMnth to Jul, i…