Calc Manager
Discussion List
-
Will switching to Hybrid BSO speed up retrieval time significantly?Summary: Slow retrieval time (including running web studio reports, forms, smartview) and calc mgr rule performance from existing BSO cubes. Content (required): Will upg… -
Smart view - Business rulesSummary: Content (required): Hi all, I'm not able to find documentation answering this question: when having an input form open in Smart View, does a user have to manual…
-
How do I return a member name where a value is at a MIN / MAXSummary: I need to find the MIN / MAX value of a given account across the cross dims shown below and I can do that using the @MINS / @MAXS functions. Next, I want to fin…
-
Restore Backup - Rest API Status CheckingHi, Has anyone here used the Restore Backup functionality via Rest API? We have successfully been able to use it via groovy business rule in one of our planning apps, bu… -
OOTB Workforce - Synchronize Default Business RuleSummary: Workforce OOTB - OWP_Synchronize Default Business rule run time issue. Content (required): I'm trying to execute Synchronize Default business rule for All Jobs,…
-
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 41 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…