Calc Manager
Discussion List
-
Passing Month varialbe through Data Managment - ErrorSummary: Setup rule "OWP_Process Loaded Data" run after load in Data Management Rule. Set to run After Load with all the prompts set. Calc Mgr Rule RTP "Month" is set to… -
Projected 12 does not skip none when calculating the averageSummary: Projected 12 does not skip none when calculating the average in rolling forecast Content (required): Hi Im using projected 12 to calculate the sum of current mo… -
Some shared account members are not cloning from one instance to anotherSummary: Some shared account members are not cloning from one instance to another Content (required): Im having a cloning issue, where some of the account members in the…
-
Exclude members from @sumrange?Summary: I am working in a labor cube, and I have a pool of bonus dollars that is to be split among upper level management, but not among non-mgr employees. Is there a w…
-
Workforce Planning: FTE larger than 1Content Hi, The default range of FTE for adding requisition is 0 to 1. Our client has a requirement to expand this range. I changed it to -100 to 100 in both the custom … -
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.…