Calc Manager
Discussion List
-
Can you copy supporting detail and comments using calc manager or groovySummary: Can you copy supporting detail and comments using calc manager or groovy Content (required): Hi Everyone, is there a way to use calc manager or groovy to copy s…RichardBrazil 11 views 1 comment 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Why is the Log Messages tab in Calculation Manager not visible to me?Summary: When I launch a business rule in Calc Manager, I receive the confirmation message indicating that the rule ran successfully. However, I'm not seeing a Log Messa…
-
Can I make a runtimep prompt optional?Summary: Want to offer a runtime prompt that is optional for users to populate Content (required): Have a cube with a large number of dimensions. The main rule takes a l…
-
NEXTSIBLING in fix using Period dimensionHello experts, I have a question about NEXTSIBLING using in FIX. I would like to see FIX("FY23", @MEMBER(@NEXTSIBLING("ClosedMonth")):"Dec","E01") Mycode... ENDFIX My pe…
-
How to reference an Attribute dimension member in a Member Formula in ASOSummary: Trying to reference an attribute member in a member formula in an ASO cube but database refresh is failing. Content (required): I have an attribute dimension 'C…
-
Deleted Business Rule Still Appears in ListSummary: Content (required): I asked this before, but cannot remember what the fix was, so apologies for the dup question. I have a few Business Rules that I have delete…
-
How to call a cube level Sub variable in a groovy ruleSummary: How to call a cube level Sub variable in a groovy rule Content (required): I am trying to call a substitution variable CurrYear from groovy rule which is define…
-
Recursion Limit Error on account not in FormulaSummary: Content (required): I'm getting the following error when trying to run a rule (in test environment): Cannot calculate. Essbase Error(0): Error executing formula…
-
renaming entity and cost center membersSummary: Content (required): Hi We need to rename entity code and cost center members - first four digits. (Ex: old code is 503010001 and new code is 803010001) We teste…
-
Groovy - awaitCompletion - An error occurred while processing this page.Hi all, Hope you guys are doing well. We are trying to use REST API to trigger a data integration from Calc Manager (EPBCS application). We have created the connection, …
-
invalid intersection report : red highlighted cellsSummary: Content (required): Hi Any idea why invalid intersection report contains some data in red, and some data in grey. What does the color indicate Version (include …Lakshani Hettiarachchi 31 views 3 comments 0 points Most recent by Naveen_Bonakurthi-Oracle Planning
-
Calc Rule Error for @avgmissingHi Receiving the following error when using @avgrange essbase function in my rule. "LKR_Reporting"=@avgrange(skipboth,@Relative("Input Currencies",0)); Error message is:…
-
Business Rule Using Wrong PercentageSummary: Content (required): I have a business rule that calcs year over year based on input into an account. However, it is multiplying 900 times what is entered. The r…
-
How do I add an IF to this Business RuleSummary: Content (required): I need to add an IF statement to the below rule to change the calculation based on Entity. (There is more accounts in the rule, this is just…
-
Sumrange for all periods/years in cubeHello, experts, I need a dynamic calc than summarize all data from the beginning of years. I have a Year dimension and a Period dimension, and also a DataType dimension …
-
Rule taking timeSummary: Content (required): Hi Rule is taking quite a time. 8 minutes. Any Suggestions. (PFA) Version (include the version you are using, if applicable): Code Snippet (…Lakshani Hettiarachchi 21 views 2 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
PBCS CALC Script - SET FRMLBOTTOMUP ON; issueSummary: calculation not working when SET FRMLBOTTOMUP is ON Content (required): Hi everyone, I have a calculation script that will calculate expenses based on 3 month h…
-
Enabling Job Console or NotificationsSummary: Content (required): Is there a way for non-admin users to know when a business rule completes? I saw some information on the Job Console in SmartView but I don'…
-
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…
-
PBCS - Business Rule AssistanceSummary: Business Rule (Calc Script) Assistance Content (required): Hi everyone, I've written a business rule that will calculate the expenses based on historical expens…
-
DATACOPY Rule taking a long timeSummary: Content (required): I have a DATACOPY business rule that copies one version to another. However, it is taking up to 15 or so minutes to complete. I have a simil…
-
Run of Merge Slices Job via Business Rule on Form-Level Action Menu - EPM Automate/GroovySummary: I am attempting to run a merge slices job as part of a ruleset that is triggered via a form-level action menu. The script shown below works perfectly when run d…
-
Unable to create blocks for Allocation LogicSummary: Unable to create blocks for Allocation Logic Only Period and Account are Dense and rest of all are Sparse. FIX(&CurYr, &CurMnth,"Actual","Final", @RELATIVE("All…
-
Ruleset and Rule Variable Prompt OrderSummary: The order of my variable prompts within a Rule and a Ruleset are not updating regardless of how I have the order setup within Calc Manager. Content (required): …
-
Import Rates from ERP to EPBCSSummary: Form subvars off imported ERP rates and reference them in business rules. Content (required): Currently we are manually hard-coding our period average and perio…
-
@ATTRIBUTE and @WITHATTR in @SUMRANGE FunctionCame across something interesting and wondered if anyone else has experienced this. I'm working on an allocation model based on headcount and leveraging attributes to ta…Patrick Northcraft - Dropbox 21 views 2 comments 1 point Most recent by Patrick Northcraft - Dropbox Planning
-
Can Run-Time Prompts be set to Ignore Valid Intersections?Summary: Run-time prompts are restricted by valid intersections. But we would like to disable this as needed. Content (required): We need to be able to run some rules th…
-
Copy data using XREF from different members to unique member (Fastest way)Hello experts I have a requeriment to do. I have to catch some data using XREF. I have one dimension that is available for both cubes (Product: Sparse Dimension) and I n…
-
Unable to copy data from one member to another using groovy script in Hybrid EPBCSSummary: Content (required): Unable to copy data form one member to another using Groovy Version (include the version you are using, if applicable): Code Snippet (add an…
-
FRS IssueSummary: FRS Issue Content (required): Hi We have an FRS Report with 2000 rows, and we are bringing a dimension to the which was not earlier. For this dimension member v…Lakshani Hettiarachchi 21 views 1 comment 0 points Most recent by Komala Reddy-Support-Oracle Planning