Calc Manager
Discussion List
-
Is there a way in Groovy to getEvaluatedMembers / get ancestors with Administrator permissions?Summary: Would like to know if there is a simple way of using getEvaluatedMembers (or similar) with admin permissions, to pull back names of members in the hierarchy des… -
copy data from many POV to one POV.Hi, I need to right a business rule function to change the 9 accounts with currencies to no Currencies, its similar to datacopy @RELATIVE("Input Currencies",0) To "No Cu… -
Issue with dynamic calc parentHello experts, I have issue doing a dynamic calc in PBCS: The calc is very easy: "Final Balance Typ2" / "Final Balance Typ1"; At level 0 from Entity I can see correct da… -
DTP Prompts are not coming up when saving a formHi guys, I am very new to DTPs and trying to study its behavior trying different scenarios. One of the scenario that I am testing is that "User will select company from …
-
Prior balance (Spanning in years and months)Summary: Content (required): Hi I need to do the following scenario, where i need to get the prior month balance + current month balance. but when it spans over the next…
-
If condition for variables.Summary: Content (required): Hi i have an account with date format where we enter the loan start date. for ex : 1st may 2020. Then i pass the loan fixed rate which user …Lakshani Hettiarachchi 31 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Copying data for period rangeSummary: Content (required): Hi I need to copy data for a period range as below. Ex: i have a loan start date : 01-may-2020. and loan end date as 31-apr-2026 (72 no of p…
-
date in calc managerSummary: Content (required): Hi I want to copy a certain to a specific month and year, based on the date entered by user in "loan start date" (MM/DD/YYYY Format) For ex:…
-
Groovy - Using getEvaluatedMembers with Shared MembersSummary: I am attempting to generate a custom metadata export file using Groovy to feed into some reporting solutions. We want to be able to generate a clean csv that ha… -
Is it possible to invoke rest from a groovy template?Summary: I have done an api call from a groovy business rule and it works fine. If I use the same code within a template, it gives me 403 forbidden error. Is there a lim…
-
Drill through regions stop workingSummary: Drill Through Definitions stop working randomly and need to be "refreshed" and I can't figure out why or how to fix this. Content (required):We have defined Dri…
-
amortisation schedule scriptSummary: Content (required): Hi I'm trying to build a loan amortization schedule in OEP_FS, with opening balance, repayments, interest and closing balance. Does anyone h…Lakshani Hettiarachchi 13 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…
-
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…
-
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…
-
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 32 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 31 views 2 comments 0 points Most recent by M. Kyle Goodfriend-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…