Calc Manager
Discussion List
-
Why does @parentVal return #MISSING?Summary: Can someone help me understand why @parentVal("Period", "Working") returns #MISSING for the sample code below? Content (required): I have set up a simple exampl… -
How to get @PARENTVAL on Sparse Dimension working in Hybrid BSO?Summary: We need to use @PARENTVAL for our calculation, we have checked the documentation it is not supported for Hybrid BSO. Documentation also mentions that if these f…
-
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 33 views 5 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-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…
-
How to exclude intersections of different dimensional membersSummary: How to exclude an intersection of different dimensions within a FIX statement? see example below Content (required): Calc Script: In the FIX Statement is the wh…
-
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 31 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Groovy Code to Determine Valid IntersectionsSummary: We have a valid intersection to define the business unit for each department (every department belongs to only one BU). To make business rules more efficient, w…
-
Groovy BR REST API Send Email v2 AttachmentsSummary: Groovy business rule to send email using v2 is working except attachments. Content (required): Cannot seem to get the parameters syntax correct. Version (includ…
-
@CalcMgrSLMember not recognized?In the october update it brought 4 new functions : @CalcMgrLogMessageTrace: Adds custom messages to the Log Messages tab after launching a rule in Calculation Manager. @…
-
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… -
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u…
-
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…
-
Cannot submit date after 2042Summary: Cannot submit date after 2042 Content (required): I try to submit date data in a member on 1/1/2052. However, when I submit it, it automatic go to 1/1/1952. I h…
-
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…DylanPauwels 12 views 1 comment 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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…Scott Ezzard 11 views 7 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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…