EPBCS
Discussion List
-
50k to 100k Members required in Task/Phases Dimension in EPBCS Projects ModuleSummary: Need to assess the performance impact on the Projects cube in EPBCS for having 50,000-100,000 members in the Task / Phases dimension. Content (required): The cu… -
Is there a member cell information equivalent in Smartview VBA for EPBCS Planning connections?We recently implemented EPBCS and for one application we shifted from an ASO Essbase application to an EPBCS Planning ASO Plan Type. In Smartview with Essbase connection…
-
Is there a way to send automated email when the data load rule gets completed?Summary: I want to send an automated email with the process log attached to the users which informs whether the data load rules finished successfully or it failed. Conte… -
User Unable to Update Project ExpenseSummary: Planning>Project>Expense Content (required): How to grant User access to update the Project cost under expense? Version (include the version you are using, if a…
-
How to put a multiline message body in a epmautomate sendmail command?Summary: How to put a multiline message body in a epmautomate sendmail command? Content (required): Version (include the version you are using, if applicable): Code Snip…
-
Does adding cell comments on multiple cells work only on a single column at a time in Smart View?The Smart View feature of adding cell comments on a range of cells works only if the range lies in the same column. Is this an expected behavior. Also, deleting cell com… -
Change alias on the sender email IDContent Currently, when scheduled reports are received, they come from planning-test-[zone name] . Is it possible to change the alias (planning-test-[zone name]) to some…
-
Planning inbox/outbox explorer files in Snapshot?Summary: Planning inbox/outbox explorer files in Snapshot? Content (required): I do not see any files retained in the snapshot that are from the inbox/outbox explorer. A… -
How do I protect excel formulas in smartforms business calculationsSummary: I have smartforms that the department or location manager open to input for their budgets and forecasts. We use business calculations becuase the end users can …
-
Flex form open as a regular form in Smart View giveserror "Planning provider error" after SubmitDataSummary: It started yesterday and the number of users who are seeing the issue is growing and it happens to me too, but not to all users. Steps to reproduce: 1 - Open a … -
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… -
Creating a database connection in Reporting Studio in EPBCSContent Hi, We tried to create a database connection in reporting studio in EPBCS. Navigation = Reporting > Explore Repository > Explore > Tools > Database Connection Ma…
-
Smart View - Submit Zero'sToday we were testing out submitting data in Smart View and even with the "Submit Zero" setting unchecked, 0's were still being submitted to the application. I thought h… -
Incremental data load not able to detect delta if last run is failedI have encountered an problem incremental data load in PBCS. Let's say there is a failure due to some missing mappings during an incremental data load and assume it's pr…
-
Error in parsing JSON Payload - Cannot index into a null array.Summary: An error occurred during the API request: {"links":[],"status":4,"details":"EPMFDM-ERROR: Error in parsing JSON Payload"} Cannot index into a null array. + $uri…
-
Convoluted Access in EPBCS 'User Group' AccessSummary: User's access is convoluted when being added to the 2 groups. Content (required): Hello Oracle, Can you please assist or give any suggestion on how we can resol…
-
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… -
Form display in web vs SmartViewSummary: Form displays differently in Web vs Smartview Client would like to know why there is extra space to the right of the last column on this form in the web. Conten…
-
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…
-
Can we create valid intersections updated based on project start date and end date using GroovySummary: We have projects where businesses will change the start date and end date on form. As a next step, the system should allow users to input only the periods (Jan … -
How to take snapshot backups for oracle NRCS applicationSummary: How to take snapshot backups for oracle NRCS application Content (required): We have a use case where we want to archive(the entire snapshot) the existing appli…
-
EPM Automate upload file based on partial file nameSummary: Hi All, With a batch script we are transferring a csv file into the inbox of EPBCS, making use of the EPM automate command "uploadFile". We have used this multi…
-
PBCS Account Structure IssueSummary: In PBCS there is an account: OFS_Short Term Borrowing - Calc to Balance. This account includes prior period retained earnings. Why does this account sit outside…
-
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:…
-
Additional text member in a dimension reflect as read only after executing database refreshSummary: We have a requirements in planning to add additional columns named "Quantity" and "Particulars" in order to get the justification of the amount the user entered…
-
Report Administrator - Access to Configure Bursting DefinitionsSummary: Content (required): In Narrative Reporting, per this doc, you can assign the Report Administrator role to a user however we don't see a similar option for that …
-
How to replace special characters in data management while loading.Summary: I'm pulling data from HCM in epbcs data management, It's a direct integration to HCM. Some employee alias contains special characters how to remove or replace w…
-
How to add a comment column on PBCSSummary I want to create a comment column so user can write their comments.Content Hello fellows, I'm working with a customer that want a comment column (not the cell co…
-
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 …