Calc Manager
Discussion List
-
Updating substitution variables via REST API broke with 23.03 updateSummary: In performing regression testing, I am having trouble using the REST API to update substitution variables. The rule results in a null pointer exception. Content…
-
Assign Values Stored in Smartlist to another memberSummary: Assign Values Stored in Smartlist to another member to compare years Content (required): Hi All, Here i'm comparing the In service date & Plan Start Year, Withi…
-
How can I improve Aggregation Rule running very long?Summary: The business rule I have right now aggregating All Entity, all currencies, all months (Jan-Dec), all accounts and taking around 45 minutes. Can this be improved…
-
Need to Improve Aggregation Run TimeSummary: Want to decrease time it takes to run an agg. Content (required): Currently takes about 40 minutes to agg one period, one scenario, income statement only. Would…
-
Importing Text through data management (Non Numeric)Summary: Importing Text through data management (Non Numeric) Content (required): Hi I have setup data management import format "Delimited All Data Type". And Load metho…
-
Using parent members as cross dims in FIX is taking long time for script to completeSummary: We are trying to fetch parent values in a business rule to perform spread calculation. But since these are top level members and having storage property as dyna…
-
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…
-
Convert and assign date and year to a variable using business ruleSummary: We need to convert start date to month and year format. Content (required): We are trying to get month and year from OEP_Start Date member. Can someone let us k…
-
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita…
-
Error while finding Count of Members between range:invalid argument in function [@_BPROC]Summary: Encountering invalid argument in function [@_BPROC] Content (required): Hi All, Here we are trying to find count of Members between Start Month & End Month in a…
-
Non-Groovy: Transfer of Member Value into Smart Lists created from MembersSummary: Using a Smart List, I am attempting to capture the value of a member that is designated within the RTP prompt into a separate Smart List Account created from th…
-
Groovy Business Rule - crossDimCell across Multiple Dimension Members (Account and Scenario)Summary: We are attempting to use Groovy to assist with custom validation rules to run prior to save on forms in our application. However, the form in question uses the …
-
Error:Error parsing formula for [FIX STATEMENT] (line 9): expected [(] found [@_AT] after function nSummary: Content (required): Hi All we are seeing this error under the PROD server. Works fine under the TEST server. ---------------------------------------------------…
-
Calculation Manager differences between test and ProdContent (required): Hello, i'm trying to optimize a business rule in Calculation Manager. I noticed that there are some differences in Error & Warnings section. When I a…
-
Calc Command/Function to pick strings from right of a memberSummary: We have a requirement to pick member names from a concatenated member from the last. Need command/function which can be used in calc script to achieve this. Con…
-
Essbase calc - shorter way to write a script based on Prior PeriodsSummary: Content (required): I'm working on a rule that requires the cumulation of prior month values (tax in this case) to be calculated into the current forecast month…
-
ASO Dynamic Calc Member MDX ConversionSummary: We are in the process of setting up an ASO cube. I have 1 account that doesn't seem to work. Currently in the BSO cube I have the following: if (@ismbr("Jan"));…
-
[Integrations & REST API] Struggling with updating Source Filters via REST APISummary: I am trying to create rules that utilize the REST API to override source filters when running integrations in Planning. Unfortunately, I cannot seem to get the …
-
How to Groovy for copying data in PlanningSummary: Trying to create a script in Groovy to copy data from one scenario to another, so far unsuccessful Content (required): I am running Planning Cloud. For various …
-
AggregationSummary: Content (required): Hi We have a plan element called "Adjusted total" which has a formula as below. "OFS_Direct Input" + ("OFS_Direct Input" * "OFS_% Increase/(…
-
CREATEBLOCK - Script diagnostics generates error if you do not FIX on all dimensionsSummary: In the monthly update notes, there is recurring mention of a future update where script diagnostic errors will prevent the launch, validation, and/or deployment…
-
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…
-
Failed IF condition is still producing a value that is used by a subsequent ELSEIF functionSummary: I am using IF/ELSEIF within a fairly tight FIX. The logic is as follows: FIX(&PeriodVar) IF(@ISMBR("Jan")) perform X calculation in Jan ELSEIF(@ISMBR("Feb")) pe…
-
Period dimension Mapping DMSummary: Content (required): Hi I want to use OEP_Yearly Plan to upload annual figures to each year. We need to use this in data management. How to do this? OEP_Yearly P…
-
Issue in Calculating Accumulated Depreciation for New AssetsSummary: Accumulated Depreciation not calculating for New Assets Content (required): Hello All, I'm trying to add a new Tangible Assets, calculate Depreciation for the A…
-
Generating a sequential, unique ID for a record/tuple?Summary: Generating a sequential, unique ID for a record/tuple? Content (required): I need to generate a sequential number for a field to have a unique ID for a record. …
-
Display Data of type text and copy using business rules (Version bottom up)Summary: Looking for some best practice using members of type text in combination with Version Bottom up Content (required): We set some accounts (dense dim) to type tex…
-
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…