Calc Manager
Discussion List
-
Calculation Manager - Explanation for Summary in the Errors and Warnings tab neededSummary: I'm trying to find an explanation for the Summary section in the Errors and Warnings tab in Calc Mgr Content (required): I've searched all the guides and have c… -
Weekend / Weekday Segregation in EPBCSSummary: Weekend / Weekday Segregation in EPBCS Content (required): Hi We have a requirement of weekly planning which the feature is available in EPBCS. But there is fur…Lakshani Hettiarachchi 51 views 5 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Script Suggestion to reduce timeSummary: Script Suggestion to reduce time Content (required): Hi Attached script is taking 15 min to run. Any suggestions that can be provided to reduce time? Applicatio…Lakshani Hettiarachchi 51 views 5 comments 0 points Most recent by Patrick Northcraft - Dropbox Planning
-
Groovy - Accessing Attribute Dimension MembersHi, We were doing some testing today and were trying to use .getEvaluatedMembers to access attribute dimension members (similarly to accessing dimension members using th… -
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…
-
Tp-EndDate is acting like Tp-Date and is breaking our Start Date calculationsSummary: After numerous tests, I can prove that the TP-EndDate member, though when retrieved is one value...when it is in IF statements it is another value Content (requ…
-
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…
-
How can I convert a member to a string to populate a Smart List value?Summary: I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension. Content (required): Below is an example …
-
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…