Calc Manager
Discussion List
-
Best practices for hotel and leisure industry.Summary: Best practices for hotel and leisure industry. Content (required): Hi We are implementing EPBCS for hotel and leisure industry. I'm looking for EPM Best practic…Lakshani Hettiarachchi 61 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning -
Compare Aliasname with a Textcell for a large memberrange - [[PlanningFunctions.getIdForStringSummary: to perform a selective datatransfer (@Xref logic) from source to target cube (where the location information is in a textcell in the source cube compared to mem…
-
IDESCENDANTS in AGGSummary: Content (required): We have an aggregation as part of our calc people plan rule using just an agg function. This doesn't seem to work unless @idescendants is in… -
Business rule run time takes longSummary: We have added 2 new dimension Future1 and Future2 recently. Earlier this script runs 45 mins now it is taking 1.2 hours. User is complaining the run time. Is th…
-
Data Export Header FormattingSummary: When running a data export in PBCS the file headers give you 12 amount columns, one for each period, and no period column. Is it possible to have 1 column for p…
-
What's New in 21.08?Summary More cool things plus some favorites of mine!Content Well, here we are again and I'm back on my normal release date as 21.08 is set to hit your test environments… -
Assigning a variable to a text member using EPBCS groovyContent (required): Hi guys! I am facing a small issue in assigning a variable which contains text using groovy. I have an array named "Teachers" which contains staff na…
-
Delete file REST API - GroovySummary: Has anyone successfully used the Delete Files (v2) API in a groovy business rule? Content (required): I am able to make the API call from Postman. However I kee…
-
Essbase Error(0): Error executing formula argument [3] can not be [LIST] in function [@_XWRITE]The below line of code has started to output the above error, since roughly 9th August, as I understand. It seems like the issue is related to the @NEXTSIBLING function:…
-
Launch a BusinessRule Template from Businessrule with multiple values for DesigntimepromptSummary: How to Launch a BusinessRule Template from Businessrule with multiple values for Designtimeprompt Content (required): We want to run a longer businessrule for t…
-
PBCS- Cannot see the Period mapping type in data load ruleSummary: PBCS- Cannot see the Period mapping type in data load rule Content (required): Hi Im performing a file based integration. And we have the global, application an…
-
EPBCS - How to check the last run details of business rulesSummary: We have many rules and would like to check last execution of rules in planning application to determine to delete the unused rules. I have checked job logs and …
-
Seeding data / Archiving data in ASO CubesWe have to do various data copies in our ASO Cubes. We have to seed actual data into Forecast, and do standard Version copying (Working -> 3+9 for example). As we know, …
-
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 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…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
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 …Lakshani Hettiarachchi 21 views 3 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…