Category 146
Discussion List
-
Merge Incremental Cells and Compact CubeSummary: We are using Merge incremental slices (merge all into main slice) and there is improvement when using this, the cost of querying inc data also reduced from 0.9 … -
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…Mueller 153 views 4 comments 0 points Most recent by Luis Autrique Profitability and Cost Management
-
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…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 82 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 61 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 23 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 -
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 78 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 31 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 161 views 9 comments 0 points Most recent by Anantha Krishnan Profitability and Cost Management
-
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 81 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…NK2025 254 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 11 views 1 comment 1 point 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