PBCS
Discussion List
-
PBCS - Enterprise Cloud ServiceSummary Can you have more than one "Free Form" cube in Enterprise Cloud Service?Content Have a client that currently has five applications. Two of them are similar and a…
-
Valid Intersections Select Prior Months from Substitution VariableSummary Need to set valid intersections for prior (or following) months based off a substitution variable.Content We have a substitution variable that controls forms and…
-
Data Forms with Database SuppressionContent Hi All, We were facing tuple errors in forms while using the "Suppress Missing Blocks" option in form design due to the size of the query. Once we started using …
-
Execution of MDX for ASO CubeSummary Execution of MDX for ASO CubeContent Hi All, We are loading a specific KPI via Data Management into ASO Cube. But this data needs to be multiplied by 1000. This …
-
Migrate On-prem Essbase Data to Oracle EPM CloudContent we have a use case to migrate 1.8 Million or more records from on-premise Hyperion Essbase to Oracle EPM - PBCS cloud SaaS Application. We see limitation on FDME…
-
What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPMSummary What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPM toolContent Looking for some expert advice about the best app…
-
Data Form Designer: Looking for an Option to design forms displaying ancestors/parents at top insteSummary looking for the option to choose parents/ancestors to be displayed at top instead of at bottom when building a form and selecting a memberlistContent For many ye…
-
Attributes Dimensions in the Financial Reports.Content Hello, Can anyone please let me know that how the attributes dimensions work in the financial reports? Is it work like a single member or multiple members? Thank…
-
Exclude shared members in Planning FormContent Hi, I'm designing a form that retrieves a list of accounts under a parent as rows. However, I want to exclude some of them. For this, I have created an alternate…
-
What is the true retention period for Audit data?Content From browser UI the most you can view\download is "Last 180 Days" but I noticed that REST and epmautomate may support downloading more using the "All" parameter.…
-
Rounding off to two decimal places: PrecisionContent Hi Is there any setting, or profile option to update all system calculations to round off to a certain decimal place without performing through rules?(As in with…
-
Essbase Version Downgrade & RestoreContent A few months ago we upgraded the Essbase version of our application, however, we did not enable hybrid mode. This was done due to some data loss issues which Ora…
-
PBCS- How to enable users to choose multiple dimension membersSummary My question: Is possibile adding multiple choice of members of the same dimension in filtering action of a POV Form?Content Hi, I'm editing a form in a customize…
-
User_2025-02-06-06-31-56-788 90 views 3 comments 1 point Most recent by Mark Rinaldi-Oracle Planning
-
Extract Text from Relational Database (PBCS)Content I have a dimension called Product Code that has a data type of Text. This dimension has been added to a form, and planners can add freeform text in the text box.…
-
EPBCS : Copy parent level data to Level0 Members having Multiple generation sparse dimensionContent Hi All, We have a Department hierarchy (Sparse Member) with multiple levels/generations. We have loaded data to the department parent members with the top down T…
-
Problem with aggregating percentage values against custom created ScenarioContent Hello guys, We have an issue with newly added custom Scenario member (Actual vs SPLY %). This member is supposed to calculate the % of Difference of Actual scena…
-
@Concatenation Invalid Object TypeContent Hello Everyone - Fist time caller here....I'm new to PBCS scripting and I need a hand with an error. I am trying to create a FIX statement using concatenate to a…
-
Planning - Data Management Replace Data FunctionContent Hello, One of our clients have a DM Rule with Replace Data to clear the cube before importing the data. The thing is that the ClearData is taking almost 3 hours …
-
What's New in 21.06?Summary More cool ways to enhance your Oracle Cloud EPM experience!Content Wow, here we go with another monthly update! First, KScope is rapidly approaching, so be sure …
-
Time Balance Property AverageContent Hello all, We have accounts where we would like to have the average (of the period values) calculated in Quarter or YearTotal. If we select the Time Balance Prop…
-
PBCS Data Integration AutomationContent Hi, we are planning to use EPM Agent and created Data Integration which directly connects to on-prem SQL server and loads to PBCS cube. Looks like we can run the…
-
Smartlist fun (in web)Summary Smartlist emojiContent More of a statement than a question and just a bit of fun - only works in the web sv renders as text - but have noticed if you type in the…
-
EPM Cloud: What are the ways to exchange data between different Planning Applications?Content Hi, there is plenty of information about exchanding data between cubes, but what are the ways to exchange data betweet two separete cloud based Planning applicat…
-
Looking for alternate approach to maintain UDASummary Looking for alternate approach to maintain UDAContent The accounts in the hierarchy cannot be tagged as revenue, expense, asset, etc due to no clear way client u…
-
Groovy to validate sum of each row should be 100%Content Hi, I wonder if anyone could share with me some sample Groovy script on this most typical usage, to check the summation of values in each row should be 100% I'm …
-
Dynamic Calc Issue in EPM Enterprise Cloud PodSummary Dynamic Calcs Not Firing in the Absense of DataContent I'm seeing some unexpected behavior with regard to dynamic calculations in the EPM Enterprise Cloud pods (…
-
Dashboard 2.0 limitationsContent Hi, I've been working with dashboard 2.0 in order to share the experience with my clients. But I noticed some features that I cannot do with this new version. I …
-
Connecting another Planning app via DMSummary Connecting another Planning app via DMContent I have recently migrated the Planning app to the PROD instance (acting as our UAT env) and trying to connect to the…
-
Data Management export takes too long.Content Hi We have integrated planning module with profitability, and we are extracting actuals from profitability module. It is taking so much time for data load rule t…