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.
Profitability and Cost Management
Discussion List
-
Level 0 Members in MDX (equivalent of @Relative)Summary: Dear All, I look for an equivalent of @Relative in MDX. My search only let me find Descendants and Level functions. Although for level function the documentatio… -
How to define output cell in CASE Member FormulaSummary: How to define output cell in CASE Member Formula Dear all, I need to write a conditional rule to make sure all values on the parent member P1000 are 1. This 100…
-
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…
-
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 -…
-
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 … -
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…
-
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…
-
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… -
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…
-
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…
-
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 …
-
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…
-
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 …
-
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…
-
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…
-
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… -
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…
-
Please suggest SmartView link that can be used to connect/test to PCMCS OCI temporary URLs.Summary: SmartView link that can be used to connect/test to PCMCS OCI temporary URLs provided by Oracle to validate the env before migration. Content (required): PCMCS U…
-
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…
-
Export Data With Attribute EPCMCSSummary: Hi All, Can we export data form data management with attribute value?? Let Say I have 10 Dimension out of that I tag Attribute Dimension with segment dimension(…
-
Does EPCM Custom Calculation supports String Operations on left side (Target) of the script?Summary: Targeting the results to certain ICP Dimension members ICP_**** from an alternate hierachy of Product Dimension whose parent will be CP_****. Content (required)…
-
Are Smart View Admin Extensions available for PCMCS?Summary Are Smart View Admin Extensions available for PCMCS?Content Are Smart View Admin Extensions available for PCMCS? I am able to use it when connected to a Planning…
-
Can allocations be triggered using Data pipeline in EPCM?Summary: Is there a way to trigger the allocations within EPCM using Data Pipeline? If yes, could you please help with steps? Content (required): Version (include the ve…
-
MDX Formula with Avg function is not working in Groovy Business Rule in PCMCS ASO cubeHi, I am creating Groovy Business Rule to calculate Average of an Account from Jan to Current Month and assign this value to other account. ([ACCT_AVG]) := (Avg(({[Perio…