Category 146
Discussion List
-
CASE Statement-EPCMCSSummary: Hi All, How we write case statement in member formula Is this possible??? Can any one share some example from where I can refer. Thank in advance -
Is it possible to reference PCM_Rule as a source dimension in an allocation rule?Summary: Content (required): Hi. I have a custom calc rule that moves dollars from multiple markets to a single market prior to allocating the dollars. I would like to u…SAW23321 81 views 7 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Allocation Amount (Operating Expenses - Revenue) in PCMCS AllocationsSummary: Content (required): Hi All, We have a need to reference the account (Which should be the result of Expenses – Revenue instead of Net Operating Income (Revenue -…Ashok Kumar Raya 81 views 12 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Custom Rule cannot be enabled because it has failed Validations. Invalid dimension memberSummary: I have a member name with periods e.g. 3543.1001.100004. I can use this member as source, target, driver in Allocation rules. However, I cannot use this member …Dinesh Chand 63 views 4 comments 0 points Most recent by Dinesh Chand Profitability and Cost Management -
EPCM - Divide by proper and improper zeroSummary: While performing an allocation if denominator encounters a proper zero and an improper zero how does the calc be treated/performed? Content (please ensure you m…
-
Unable to Refresh DB-EPCMCSSummary: Hi All, I am getting this error to refresh the DB. "Cube refresh failed with Essbase Cube: PCM_CLC, Error code: 1042017, Message: Network error: Timed out befor…
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…Avtar 21 views 1 comment 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc formatSummary: Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc format. We have a requirement to extract nearly 40,000 lines of dat…Vikasitha 21 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
PCM_Adjustment InSummary: Hi All, I want to allocated my cost which is store in PCM_Adjustment In but when I create normal allocation rule and run the rule it take PCM_Input member value…
-
EPMAUTOMATE command doesn't exist to launch pipelineSummary: EPMAUTOMATE commands are not available to launch Pipeline. Content (please ensure you mask any confidential information): Unable to launch pipeline job. Version…Sreenivas Rayala-Oracle 31 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management -
XML edit for a modelSummary: Incomplete changes in the model after XML import Content (please ensure you mask any confidential information): While using the XML export-make changes-import p…
-
Export Data RuleSummary: Hi All, I am looking for some document link for how to create export data rule in EPCMCS from Data Exchange interface in .csv format. Thanks in Advance
-
I get an error adding duplicated members from UISummary: I'd like to add duplicated members across different dimensions. Content (please ensure you mask any confidential information): I'd like to add duplicated member…Marco T 31 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Error in loading PCMCS data to EPBCS financialsSummary: Trying to push data from pcmcs to epbcs but facing a issuse in transform step. Content (required): We tried mapping the target application values(EPBCS Financia…
-
Need help in writing member formula in ASO cubeSummary: Trying to write a member formula for an account member but it's not working Content (please ensure you mask any confidential information): Trying to write a mem…Sanchari Chakraborty-Oracle 31 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
Unable to refresh members from source (EPBCS) application in an EPBCS to EPCM integration.Summary: In Data Management I am unable to refresh members from the source application (EPBCS Reporting cube) after registering the EPBCS application. In error log it's …Sanchari Chakraborty-Oracle 31 views 4 comments 0 points Most recent by Sanchari Chakraborty-Oracle Profitability and Cost Management
-
How do I copy rates from one member to multiple members with UDA?Summary: Attempting to copy rates from a default department member to departments with a specific UDA Content (please ensure you mask any confidential information): It f…SAW23321 32 views 5 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
EPCM - YTD from PTD source data for every periodSummary: In EPCM, all of my current month calculations require previous month YTD data for calculation. we have not created any additional period type dimension and its …Anantha Krishnan 162 views 9 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
Unable to use Rule dimension in EPCM to populate Journal Line Description in Integration with ERPSummary: We are sending data from EPCM to ERP as a single journal using Data Integration. The requirement is for the user to be able to see in ERP which allocation rule …
-
Groovy Script for Copy Data in EPCMSummary: Dear Expert, Need your help about groovy script. Right now, we are copying data from 1 intersection to another intersection using DATA COPY Feature in EPCM as b…
-
Rule Dimension sync issues between Front-End and Essbase in EPCMSummary: Getting error while running rules in EPCM related to Rule dimension member sync up Content (please ensure you mask any confidential information): We are getting…
-
quick mode EXPORT from EPCMhi All from our EPCM application, we want to extract the data set and send to target systems for reporting. We have extremely huge volumes of data (approx 1 million of r…Sucharitnarang 82 views 3 comments 0 points Most recent by Sucharitnarang Profitability and Cost Management
-
Recommended way of loading Metadata to PCMCS from EDMHi All, I need to load Metadata to PCMCS from EDM. I am aware of running Extract to get Metadata file and then upload and load file to PCMCS using EPM Automate. What are…RakeshRanjan 11 views 2 comments 0 points Most recent by RakeshRanjan Profitability and Cost Management
-
How to move data from PCM_CLC to PCM_REP cubeSummary: Content (required): Hi all As per documentation, we have just migrated from Standard PCM to EPCM and we wanted to take advantage of the REP cube. However, I can…Nkehli 231 views 12 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
Standard Target Version Use CaseSummary: I notice that the Version dimension allows for set up of a Target version. What is the use case for this in EPCM given all the cubes are ASO? I presumed you cou…Dinesh Chand 12 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Historical data change in PCMSummary: Our historical "Input" and "Allocated" data in PCM Prod got changed, could I get some suggestions on it's cause and how to fix it? Content (required): Our histo…Parul Pardhi-282807 51 views 4 comments 0 points Most recent by Johanna McGrath Profitability and Cost Management