Calc Manager
Discussion List
-
How do I extract a label from a Smart List and load it as a text value into a text account?Summary and Content: Using a Smart List, I want to be able to extract the label for a given Smart List value and load the Smart List label as a text value into a separat…
-
How to uncheck "Apply values to the rule" checkbox a business rule with RTPI have a business rule for which I have 2 variables as RTPs, when I validate or run I get the attached pop-up, I chose "Apply values to the rule" once and saved it, from…
-
Data Export not pulling level 0 descendantsSummary: I am pulling some data from pbcs using a data extract for one of my customers at zero level but there are a number of zero level members not being returned, ins…
-
Using a Groovy template can you reduce Member DTP scope in 2nd step from Member DTP in 1st step?Summary: I have a dimension hierarchy with multiple levels. I have a Groovy template and created a Member DTP in step one, where a parent level is selected using a formu…
-
Hide Columns validating a condition through groovySummary: I would like to validate a condition of row member and hide columns which does not satisfy that condition. Content (required): Looking for a groovy logic to see…
-
Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dyn parentSummary: Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dynamic parent Content (required): we are trying to make the code dynami…
-
Can you use a cell string value in RSIBLINGS rule calc to make it dynamic off user input?Summary: I am working on a custom cube that allows us to track type of employee additions/reductions/promotions, transfers easily for our planning cycle. I am trying to …
-
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…
-
Triggering an event scriptSummary: Can someone share point me to how to create an event script in data management? I am looking to execute a clear prior to export data from DataManagment into Pla…
-
Adjust Merit Month in Workforce (OWP_Merit Month)Summary: Our Merit is loaded per employee in our ePBCS cube, we load OWP_Merit Month as Apr and we would like to modify it to Jul. I'd like to create a calc instead of r…
-
@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. @…
-
Sandbox enabling,and Plan1 cubeSummary: Sandbox enabling,and Plan1 cube purpose. Content (required): Hi I read regarding sandboxes, and im having some issues related to it. and im strictly speaking fo…
-
How do you surface the currently running business rule's Job ID?This should be really simple but I can't seem to work it out. I initiate a business rule which uses REST API calls to kick off multiple child jobs. At the moment, these …
-
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 31 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 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…
-
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…