Category 101
Discussion List
-
What is the "Set Current Period and Year" Options?Summary: What is the "Set Current Period and Year" option in the Period dimension of the Classic Dimension Editor? Content (please ensure you mask any confidential infor… -
Listing of all possible upload locations and their uses for EPBCSSummary: I'm looking for a listing of all possible upload/download locations and their uses for EPBCS. For example, locations such as inbox/outbox etc for use with EPMAu… -
How to perform Data Integration without using Period Mappings?Summary: If the linked data contains Year and Period information (columns), we would like to perform Data Integration using the data in these columns without using Perio…
-
Excel array formulas and Adhoc Smartviews?Hi, Do excel array formulas work with adhoc Smartview? We are using Office 365. When we refresh an adhoc smartview (23.1) with an array formula it changes the array form…
-
Difference between Revenue/opex/capex working version and OEP_Working version?Hello everyone, When I enabled modules in Planning, it generated many related versions: But what's different purpose of these versions? Hope there are some documents abo… -
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… -
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
power point slidesSummary: How to generate slide using data from EPM Cloud with a pov Content (please ensure you mask any confidential information): The use case asked by the users, is to…
-
assiging values to rtpSummary: Content (please ensure you mask any confidential information): Hi I have written the below script, but it does not work. basically i want the rule to run only i…
-
Using Groovy, need to select upper level members to push data to other cubesSummary: Using Groovy scripting, when pushing to other cubes, need to select upper level members to push data. Content (required): Using Groovy scripting, we need to sel… -
The Block size exceeded threshold. Error Threshold: 1000000, when I added the new members in AccountSummary: I have added under Account -> OWP_Employee Properties custom properties (fields in the form) for client. And faced with error Employee Properties OEP_WFP ERROR …
-
Change the time zone inside Pipeline or Data Integration log filesSummary: How can we change the time zone inside log files created under Process Details when a Pipeline or Data Integration job is executed. Content (please ensure you m…
-
Hide Invalid Intersections in POVSummary: Hi Experts, We have defined Invalid Intersections. E.g. For Entity ABC and Customer 123 is invalid, but 123 is valid for other entities, i.e. only for ABC > 123…Naveen_Bonakurthi-Oracle 31 views 5 comments 0 points Most recent by Dan Gagnon - HyperionDan Planning -
How can we restrict data to the logged-in user?We aim to display data in web forms based on the logged-in user. We have created "Users," grouped them, and assigned application roles such as Data Integration - Drill T…
-
"In order to restructure database OEP_GREP all data must first be cleared."Snapshot Import : We have downloaded the backup of the application along with its snapshots, ready for upload into the Planning Migrate Application. When attempting to m…
-
Execution of the specified job type Merge Data Slices is not supported by this method.Hi Folks, I'm trying to call merge data slices through groovy and it throws error "Execution of the specified job type Merge Data Slices is not supported by this method.…
-
Integration of data between cubes.When integrating Quota Planning with Advanced Sales Forecasting to transfer the target value from the OEP_QTP cube to the OEP_GSP cube, we execute the "Push Data" rule f…
-
Cannot see new EPM Cloud instance in MyServicesSummary: Client has just created the first EPM Planning Cloud instance in MyServices, and added me as a user as member of the Administrators group. When I log in I can't…
-
Period mapping show wrong dateHello everyone, After EPBCS updated to version 24.06.70 , we found something wrong with Period Mapping of Data Integration. When we exported the Period Mapping: It showe…
-
Cannot find a universal way to input Date formats via Data Grid BuilderSummary: Hi, We are working with data grid builder in groovy rules. We need to upload today's date once a modification is performed. Though, we are noticing different be…
-
interop/rest/security/v2/report/roleassignmentreport/user returns errorSummary: I was trying to get Role assignment report for users for EPM Planning and budgeting cloud service, but it is showing the same error as the requested resource co…
-
budgetary control revisions :"File "<string>", line 1666, in exportCustomAppDataFusion TypeError: caHi, Is there a limit to the budget control revisions? Thank you -
Database "CUSTOM" does not existHello everyone, I tried to run the integration but it showed the database does not exist. How can i fix it? Thanks!
-
Base Forecast Push FailedAfter Finalizing the Target from quota planning we wanted to push it to advanced sales forecasting So we followed the below steps : When the quota plan is complete, an a…
-
Query on provisioning the accessSummary: Hello Experts , We are looking at provisioning access to users wherein they should have access to run and schedule books and batches, but they should not be abl…
-
Strategy for integrating EPM Cloud with SAP BW On Premise?Hi everyone, I would like to know if there is a functionality that allows to integrate EPM Cloud with SAP BW on premise. What is the best strategy for accomplishing that…
-
Form Design(Spliting the column in Act and Fcst with dynamically change of the period)Summary: A basic type of requirements(I guess). We have a requirement to redesign one of the form and to split the periods in column to have different combination of act…
-
Groovy script with comand epmautomate after save data formSummary: Groovy script with comand epmautomate after save data form Content (please ensure you mask any confidential information): Hello, I need to align data from one i…
-
How to get lost WorkBench information from Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all We used a snapshot as a backup not knowing that this did not contain the Data Management d…