Calc Manager
Discussion List
-
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 11 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… -
How can I convert a member to a string to populate a Smart List value?Summary: I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension. Content (required): Below is an example …
-
OOTB Workforce - Synchronize Default Business RuleSummary: Workforce OOTB - OWP_Synchronize Default Business rule run time issue. Content (required): I'm trying to execute Synchronize Default business rule for All Jobs,…
-
Invoking a Cube Refresh via Business RuleSummary I am trying to create a business rule that executes the Cube refreshContent I am trying to create a business rule that executes a cube refresh. I have created a …
-
How can I use a Smart List member to generate a target Period and Year?Summary: To try to dynamically create a mapping generic months to a Period and Year for each of the different Entities. Content (required): Hello, I have a requirement t…
-
Loading high number of account dimension members.Summary: Loading high number of account dimension members. Is it recommended in the long run. Content (required): Hi Do you recommend uploading chart of account members …
-
Groovy - Acting on Edited Cells IssueHi, We are running a basic groovy rule on save to act only on edited cells. The form in question is a spin off of the OOB expense trending form, but with additional dime…
-
Alternative to LOOP or any other improvementsSummary: Alternative to LOOP function is needed. Content (required): Hi Attached rule is taking 15 minutes to run. it is taking that much of a time because of the LOOP. …Lakshani Hettiarachchi 21 views 8 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Troubleshooting Pulling in Smartlist DataSummary: Issues with pulling in @MEMBER(@CONCATENATE("HSP_ID_",@HspNumToString(Smartlist_Value))). Content (required): I am creating an allocation in which I have a form…
-
Improvements to ruleSummary: Content (required): Hi There is a rule which is taking around 4 hours to run. and biggest contributor is following section i have attached. Pls help to reduce t…
-
@prior not executing as expectedSummary: @prior not executing as expected, need to get the value 12 months back from the current month which im calculating. Content (required): Hi Im using @prior to ge…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
Push Data from BSO to ASO On Load of Dashboard - ASO Web FormSummary: The short version is that I need to be able to run a Smart Push of data from a BSO to ASO cube ON LOAD on an ASO web form/dashboard through Groovy. Content (req… -
Run time prompt issueSummary: Run time prompt issue Content (required): Hi I have taken entity dimension as a run time prompt value, so if a user can have the option of both running ruleset …Lakshani Hettiarachchi 1 view 3 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Rulesets running timeSummary: Ruleset running time is long. Content (required): Hi We are experiencing a long time to run rules. For one of our rulesets it takes around 1 and half hours to c…
-
How to troubleshoot Crossjoin in Groovy (ASO) - and if NonEmptyTuple is possible to useSummary: Struggling to find what could be missing/wrong in a Groovy ASO Script leveraging Crossjoin Also wondering if NonEmptyTuple can be leveraged Content (required): … -
Downloading CSV files from EPBCS Inbox/Outbox Explorer using Groovy scripting and REST APIHi guys, We are trying to download CSV files that are published in Inbox/Outbox Explorer in EPBCS application. We tried to download these files using REST API using Scri…
-
How can I clear OFS_Trend assumption values in data formsSummary: OFS_Trends are used in our planning forms and values selected in all our forms are for UAT purposes. Now we would like to clear all data values as well as Trend… -
Encountering issue while calculating Assets with Monthly and Yearly PlanSummary: Issue while calculating Assets with Monthly and Yearly Plan Content (required): Hi All, I'm trying to calculate assets on two methods - Monthly and Yearly.First…
-
Using Groovy to Pass a Smart List Value from form rows (need to pass WITHOUT quotes)Summary: Is there a supplemental Groovy function, or other technique, that can convert a pulled smart list value from a form WITHOUT quotes? Content (required): We are t…