Category 101
Discussion List
-
Updated EPM balances are not reflected in ERP/GL essbase cubeSummary: We updated balances for a few accounts in EPM planning and pushed it to ERP GL using the ERP writeback job in DM. We are seeing all the balances are showing up … -
YTD Dynamic Calculations in ASO cubesSummary: Dynamic Member Formula not calculating correctly for YTD view. Content (required): I have a dynamic calculated account with a member formula that takes two acco…
-
New Data Map Functionality is erroring out because member mappings not supported in the releaseWe are trying to map data from WFP to Financials using the new Member Mapping benefits. We get the following error: Why is this an available feature if it errors saying …
-
Multiple calculation scripts from a single groovy scriptSummary: Can we run multiple calculation scripts from a single groovy script? Content (required): Hi, I tried running a groovy script with 2 cal scripts (base on 2 strin… -
ASO dynamic member formulaHi ASO Dynamic Member formula not resolving in certain retrieval scenarios. In the first screenshot, the expected amount is displayed in cell H8. However, in the second …
-
Use of MATCH Function in FR - Dynamic Reference to Current POVSummary: The general requirement is to use the MATCH function in the FR Reporting Web Studio in a dynamic fashion. Essentially, I want to use the MATCH function to pull … -
Cloud Data Management Flat File formatSummary: Content (required): When using Cloud Data Management for flat file exports, is there a way to rename the business dimension's field name when the default is "UD…
-
New video tutorial availableWe are pleased to announce the availability of the following new video tutorial: Performing Calc on the Fly in Cloud EPM Learn how to perform calc on the fly during ad h… -
Request for application snapshot for Healthcare Planning solutionSummary: As per the 22.05 release notes in What's New, making a request Healthcare Planning packaged solution snapshot Content (required): Need the LCM snapshot for 22.0… -
Snapshot for HEALTHCARE PLANNING SOLUTION WITH FINANCIALSHi Team, Please can you share the Snapshot for HealthCare Planning solution with Financials. Thank you! Cheers, Sucharit Narang
-
Groovy Data Movement Across ApplicationsSummary: Hi Experts, In the past, I have successfully used Groovy scripting to move data around within a cube, or between cubes in an Application using the GridBuilder o…
-
Push Data from BSO to ASO On Load of Dashboard - ASO Web FormSummary: The short version is that I need to be able to run a Smart Push of data from a BSO to ASO cube ON LOAD on an ASO web form/dashboard through Groovy. Content (req…
-
Best practice pertaining to application names and maintaining prod & non-prod environmentsSummary: Content (required): Hi Everyone, I'm looking for experiences/recommendations/best practices regarding application names and maintaining a prod & non-prod enviro…
-
Issue with data management Export step running too long.Summary:In Planning and Budgeting Cloud, PBCS, 22.04.64 . Issue with data management Export step running too long. Content (required): This step is currently taking 5 mi…
-
How many essbase cubes are available in old PBCSSummary: How many essbase cubes can be created in an old PBCS environment? I recently observed it was allowing to create 6 BSOs and 6 ASOs. Is this right? or am I missin…
-
Run time prompt issueSummary: Run time prompt issue Content (required): Hi I have taken entity dimension as a run time prompt value, so if a user can have the option of both running ruleset …
-
Error while loading Account Metadata from ERPSummary: Error in loading Account Metadata via BIP report Content (required): Hi All, Here i'm trying to load Account Metadata from ERP via BIP report. getting the below…
-
YTD calculation on parent levelSummary: Wrong YTD calculation at parent level (aggregation before YTD calc) Content (required): We are loading balance sheet data YTD except for one account (retained e…
-
#SQL counter mapSummary: Hello, I'm building a new DM integrations and I was wondering if it's possible to build a #SQL mapping like the following: The condition depending on the value … -
Rulesets running timeSummary: Ruleset running time is long. Content (required): Hi We are experiencing a long time to run rules. For one of our rulesets it takes around 1 and half hours to c…
-
New Member doesn't appear in ReportsSummary: When a new member is created and the database is refreshed, the new member doesn't appear in Reports. Content (required): Hi everyone. When I create a new membe…
-
How do I exclude the header row when importing dimension in a delimited file?Summary: I am importing a custom dimension using Data Management from a tab delimited file which has headers. The integration works perfectly, except that an error occur… -
Threshold Error in Financial Report (HFR)Summary: Hi All, We are facing the threshold limits issue for all the customers and Oracle is refusing to increase the limits from 500,000. Is there any workaround to co…
-
Copy data between versions in EssbaseWhat's the best way to copy data from one version to another in an Essbase cube? Preferably using web-based or SmartView front end, without writing scripts, no matter ho…
-
Adjusting max rows in Smart View (EPBCS)Summary: Content (required): Hi All, Is it possible to adjust the default max of rows to upload in Smart View for EPM cloud application (EPBCS in this case). I know this…
-
Removing reporting currencySummary: Content (required): Hi all, Currently I am encountering difficulties in EPBCS in deleting a reporting currency "M EUR_Reporting_Reporting" as this is has no use…
-
ERP Cloud BIP report data model schema integrate with EPBCSHi all, I need to create a metadata / dimension integration from our ERP Cloud GL to EPBCS via data management. Can you please help me find in ERP the SQL query on top f… -
Downloading CSV files from EPBCS Inbox/Outbox Explorer using Groovy scripting and REST APIHi guys, We are trying to download CSV files that are published in Inbox/Outbox Explorer in EPBCS application. We tried to download these files using REST API using Scri…
-
Master data automation from EPBCS to Fusion GLSummary: Automation of master data load from EPBCS to Fusion Content (required):We have a unique requirement where EPBCS is the source of one of the dimensions and new m…