Calc Manager
Discussion List
-
Calculation Issue in Business RuleSummary: Content (required): Hi Experts, In our implementation, we are having 9 dimensions as Years, POV, Time Periods, Version, Scenario, Account, Product, Cost Centre,… -
Get Previous Month Balance in CalculationContent Hi All, We have defined a business rule using the formula template to derive a value for an account (Business Rule details are attached for your reference). Our …
-
Data load mapping in data managementContent Hi I have one source value which needs to be mapped to two different target values. How to do this in data management Version 21.04.06
-
Can't see the Business Rules in Calc Manager after LCM importContent Hi All, I did LCM of a business rule in projects from Dev environment to Prod. After the LCM, in prod environment, I can see the business rule in the rules card,…
-
Refresh Database in Calc Script or Form?Content Hi guys, We have set up in our PBCS that an user can create a member via an action menu. That this member can used by the user in calculations, a refresh of the … -
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…
-
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.
-
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…