Calc Manager
Discussion List
-
Can planning expression be used outside OEP_WFP, e.g. OEP_FS?Summary Can the planning expression [TimeBalanceSpread] be leveraged outside OEP_WFP?Content Is it possible to use [TimeBalanceSpread] in a business rule outside OEP_WFP… -
Business Rule is not workingContent Hi Experts, We have created a business rule to allocate rent expenses across departments based on the square feet. An example is attached for your reference and … -
Groovy to Get Metadata from Action Menu RowSummary Running a business rule from action menu on a row in a form and need to get metadata from that row.Content I am writing a custom employee transfer rule in groovy…
-
Groovy rule calling RESTAPI PLAN_TYPE_MAP - not workingContent I am working on a groovy rule to call a REST API for running a data map. I would skip the API and use a smart push, however I want to bypass dimensional security… -
YearTotal in rolling budgetContent Hi We are configuring rolling budgets on a 12 month basis. So for most calculations, summation of 12 months value is needed. For static budget, we use "Yeartotal…
-
Essbase Function for tolerance rangeContent Hi is there any essbase function to give a tolerance range. Like i need to use in an if condition. If the certain account value exceeds by the tolerance value, f…Lakshani Hettiarachchi 10 views 2 comments 0 points Most recent by Omar Shubeilat - ACE Pro Planning
-
Aggregation of the previous month value.Content Hi I have simple formula as follows. current month X = (previous month X for a relavant product) + (Y / Previous month X at the total product level) * (previous …
-
Is there a way to pass entity selection as RTP for data load rule in data integration?Content Team We have two separate instance like Finance and workforce due to security reasons. As part of monthly business activities 30 brand users are supposed to send… -
Summation of 70%,10%,10%,10% becomes 99.9999999%Content Hi, I have a simple input form to input allocation % and there is a simple rule to sum them up if it equals 100% Basically, all the situations work well to give … -
How can we round up a data using business rule in PBCS?Summary For Example 12.34 = 12 134.598456 = 135 Can someone please suggest me , how can we achieve this?
-
Execution of MDX for ASO CubeSummary Execution of MDX for ASO CubeContent Hi All, We are loading a specific KPI via Data Management into ASO Cube. But this data needs to be multiplied by 1000. This …
-
EPBCS Financials how can I use OFS_Trend Based Calculation on custom Form?Content Hi all, Tried to use the OFS_Trend Based Calculation on a custom form but apparently runs but does not produce any results. I use some custom driver accounts on … -
What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPMSummary What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPM toolContent Looking for some expert advice about the best app… -
Need to Delete Empty Blocks via Groovy RuleSummary Restructure & Clear Cube Not WorkingContent Hello, If possible I need to delete empty blocks from a BSO cube using a rule. The ClearBlock All function is not doi…
-
Need a essbase function to get the sum total of the prior month figureContent Hi We have a requirement to get the summation of the total of all the child products in the prior month for the budgetary allowance account. we tried using the f…
-
PBCS to HybridContent Hi All, How can we enable hybrid for PBCS, can it be for test Pod initially? Also is there an impact to existing calculations? Thank you.ioannisvossos 22 views 5 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Select Next Member In ListContent I'm working on a business rule to seed a forecast version with Actual from Jan:May & Prior Forecast for Jun:Dec. To make this business rule more flexible I wante…
-
OOB EPBCS Prepare Forecast Rule copies Actuals to "OEP_No Entity"Content Hi All, Can someone please explain why the Prepare Forecast & Rolling Forecast executes all the commands at the "OEP_No Entity" member? Then how are the data get…
-
Extract Text from Relational Database (PBCS)Content I have a dimension called Product Code that has a data type of Text. This dimension has been added to a form, and planners can add freeform text in the text box.…
-
EPBCS : Copy parent level data to Level0 Members having Multiple generation sparse dimensionContent Hi All, We have a Department hierarchy (Sparse Member) with multiple levels/generations. We have loaded data to the department parent members with the top down T…
-
Problem with aggregating percentage values against custom created ScenarioContent Hello guys, We have an issue with newly added custom Scenario member (Actual vs SPLY %). This member is supposed to calculate the % of Difference of Actual scena…
-
Planning - Data Management Replace Data FunctionContent Hello, One of our clients have a DM Rule with Replace Data to clear the cube before importing the data. The thing is that the ClearData is taking almost 3 hours …
-
Error on Groovy error Message: expected type found .Summary Converting rule to groovy rule. Rule fails to write RTP value to member. Trying to write text string entered through RTP on Action MenuContent I have a working r…
-
Ruleset's RTP shows the RTP number in front of the RTP TextContent Hello everyone, We recently migrated to Planning in the Oracle cloud. We encountered the issue with one of the Business Rules RTPs. The very last RTP in the Rule… -
Anyone has ever used "Allocation" system template successfully without any custom modificationContent Hi, I wonder if anyone has tried using Allocation system template successfully without the need to make custom changes in the system generated script. I tried di…
-
Business rule syntax errorContent Hi Everyone, I have the following relatively simple business rule that I am trying to create to attach to a form: FIX (/*DIM:Years*/"FY21", /*DIM:Scenario*/"OEP_…
-
Need to identify members that used inside BRs and Member formulasSummary Before edit or Delete Dimension member, we need to identify is it using inside any BR or member formula.Content We are facing difiiculty when we need to delete o…Surya_chittaranjan_01 17 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
EPM Automate script failing with new 5.02 runRuleSet commandSummary EPM Automate script failing with new 5.02 runRuleSet commandContent We downloaded the newest version of EPM Automate and changed the runBusinessRule command to r…
-
How to Extract Shared Parent member name for a member in a shared hierarchySummary We have an alternate shared hierarchy in the Product dimension. We want to extract the shared parent member name for a given product in the alternate shared hier…
-
What's New in 21.02?Summary We kick-off the new year in style!Content Faithful followers may have noticed I skipped the 21.01 update last month. The January update tends to be lighter given…