Calc Manager
Discussion List
-
Invoking a Cube Refresh via Business RuleSummary I am trying to create a business rule that executes the Cube refreshContent I am trying to create a business rule that executes a cube refresh. I have created a … -
How can I use a Smart List member to generate a target Period and Year?Summary: To try to dynamically create a mapping generic months to a Period and Year for each of the different Entities. Content (required): Hello, I have a requirement t…
-
Loading high number of account dimension members.Summary: Loading high number of account dimension members. Is it recommended in the long run. Content (required): Hi Do you recommend uploading chart of account members …
-
Groovy - Acting on Edited Cells IssueHi, We are running a basic groovy rule on save to act only on edited cells. The form in question is a spin off of the OOB expense trending form, but with additional dime… -
Troubleshooting Pulling in Smartlist DataSummary: Issues with pulling in @MEMBER(@CONCATENATE("HSP_ID_",@HspNumToString(Smartlist_Value))). Content (required): I am creating an allocation in which I have a form…User_2025-03-10-23-52-55-073 42 views 4 comments 1 point Most recent by User_2025-03-10-23-52-55-073 Planning
-
Improvements to ruleSummary: Content (required): Hi There is a rule which is taking around 4 hours to run. and biggest contributor is following section i have attached. Pls help to reduce t…
-
@prior not executing as expectedSummary: @prior not executing as expected, need to get the value 12 months back from the current month which im calculating. Content (required): Hi Im using @prior to ge…
-
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… -
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 …
-
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…
-
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…
-
How can I clear OFS_Trend assumption values in data formsSummary: OFS_Trends are used in our planning forms and values selected in all our forms are for UAT purposes. Now we would like to clear all data values as well as Trend… -
Encountering issue while calculating Assets with Monthly and Yearly PlanSummary: Issue while calculating Assets with Monthly and Yearly Plan Content (required): Hi All, I'm trying to calculate assets on two methods - Monthly and Yearly.First…
-
Using Groovy to Pass a Smart List Value from form rows (need to pass WITHOUT quotes)Summary: Is there a supplemental Groovy function, or other technique, that can convert a pulled smart list value from a form WITHOUT quotes? Content (required): We are t… -
Ruleset Validates/Deploys and displays success message, but isn't runningSummary: We have a rule set of 5 rules that validates and deploys without issue. It is connected to an action menu item and when I select it from the right click menu, i…User_2025-02-11-06-55-16-264 21 views 2 comments 0 points Most recent by User_2025-02-11-06-55-16-264 Planning -
Error while calculating loaded Exisiting Employees dataSummary: Encountering error while calculating compensation for loaded existing employees data. Content (required): Once i loaded the existing employees data from HCM to …
-
Encountering error while calculating All Existing Tangible AssetsSummary: Facing issue while executing All Existing Tangible Assets Business rule. Content (required): Hello All, Here i tried to calculate Depreciation for all my loaded…
-
Dynamic Member formula to compute ACTUAL (YTD values) + BUDGET (Remaining YTD)Summary: Good morning, I'm trying to learn how to develop a member formula in the dimension editor that will compute the following SCENARIO: The YTD ACTUAL for a given r…
-
Capturing Base salary by Position & Grades in WorkforceSummary: Capturing Base Salary by Position in Workforce Content (required): Hi All, Here we have a requirement to capture the Base Salary by Position in Workforce, By De…
-
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
Checking for NULL in getattributeValue in Groovy EPBCSSummary: we are trying to check if attribute is attached with dimension and if attribute is tagged then users should get a custom message and script execution will stop.…
-
OOB Calculation logic of Existing and New Asset in Capital PlanningSummary: Would like to know the high level logic of calculating Existing Asset and New Asset in Capital Planning. Content (required): Hello All, I have added the existin…
-
@CalcMgrExcelXIRR with @XRANGESummary: I am trying to implement excel's XIRR function using @CalcMgrExcelXIRR. When I run this function within the year (using XRange) it works fine but XRange across …
-
Groovy code questionSummary: How can I test for a value in one column in a grid and retrieve the value of the second column if it passes the test? Content (required): I have a grid iterator…
-
Use of cross dimensional operator in the FIXSummary: Use of cross dimensional operator in the FIX Content (required): Hi i need to give a range of specific month and years in a fix. what im expecting to pick using…
-
Substitution Variable error in ASO RuleSummary: Need solution to pass Period range to ASO rule Content (required): We have an ASO Rule where we pass a variable &ActualsRange for period and the rule complains …
-
Rule formula to get balance valueSummary: In business rule, we need to get the balance value of an account skipping zero and missing. Content (required): The business rule needs to get the balance value… -
Update UDA using API/GroovySummary Updating member UDA upon runnen calc ruleContent Hi all, For one of our customers we want to update (assign/remove) a UDA for the entity dimension, triggerd by a…
-
How to best use @CREATEBLOCK in a business ruleSummary: Using @CREATEBLOCK is not working when faced with block creation issues Content (required): When running my calculation rule, I realized that it wasn't working.…
-
Issue with Groovy RuleSummary: The requirement is to transfer the data from one department to another and if in the target department entered headcount is more than available headcount in sou…