Planning
Discussion List
-
Business Rule/Groovy Scripting to remove data in ASO at a specific intersectionSummary: Trying to determine if there is a way to create a business rule or groovy script which would clear data in ASO at a specific intersection utilizing members deri… -
EPBCS Reports, creating a book made up of other books, the TOC is incorrect in all the lower books.Summary: In Reports, when creating a book made up of other books, the TOC for the main book is correct but for all 'children' books the page number in the TOC is wrong. … -
What Happens if a dimension hierarchy type is not set in an ASO cube?Summary: What happens if a dimension's hierarchy type is not set? Does the hierarchy type just default to "Stored"? Content (required): I recently set up an ASO cube for… -
member formula ASO - MDX only working for first IIFHi in MDX (ASO member formula ) is only working for the first IIF not the others for the below MDX, it only calculates for Actual, and Budget shows nothing but if I move…
-
Sharing Info: String Compare in Planning - @CalcMgrCompare functionSummary Execute a set of statements based on the Variable/Prompt Value (String Compare)Content Hi All I found something interesting and want to share with all of you. We… -
How to configure Continuous move with NR to return to the origin locationHello, We want to do a round trip in OTM. We want one shipment to go from location A to location B, loaded, and unload in location B, then, we want the truckload to move…María Liébana Garrido 15 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle Planning
-
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita… -
Mapping attributes in DataManagement using PBCSSummary: Hello experts, I have a doubt with an special mapping that I have to do in PBCS and DM. I have two different PBCS applications: Application1 (Source) has a dime… -
Groovy failing while calling external REST API when adding date filtering conditionDear Experts, We have groovy script to generate csv file from RSET API json response. It is working fine when we don't have date parameter filter in REST API. The moment… -
Operational data to EPM PlanningSummary: If we have to source Operational data and forecast demands specific grants, is it possible in EPM? Content (please ensure you mask any confidential information)…
-
How to create a groovy rule to check for line returns in a text fieldSummary: We our trying to prevent our end users from entering a line return in a text data type member. Content (please ensure you mask any confidential information): We…
-
Using PREVSIBLING PERIOD not working in Period with QsHello Experts, I have a dynamic calc with different IFs because there are some month that PREVSIBLING is Qs instead of level0 Base Period. I fix this problem with differ…
-
Planning - The report generation has failed. Error executing query. The number of cells exceeds theSummary: .we have an issue with a report bursting export that we have configured and been sending since last year. since April and May this year . the export of data has…
-
Sorting the member Alias names with Alphabetical order in SWP formsSummary: Is there an option to sort members alphabetically based on their alias names when a user opens a form in SWP application? Current Scenario: We have approximatel…
-
In Planning, the internal Time Zone is set to UTC. Can it be changed?Summary: In Hyperion Planning, the time zone default is UTC. In cell history, even when a user sets to the time zone they want, it still shows UTC. Can this be changed? …
-
idea to automate rules, data map, rules data mapHi I have a requirement to automate from a USER role the below tasks. Any suggestions how to achieve this in detail please. thanks! (and if groovy would prefer some pseu…
-
Data Load in ASO cube is failingDear Experts, We are trying to load all data types ( Text, date ) data to ASO cube. It's failing at export stage. Is this type data load possible in ASO cube ? Thanks in…
-
What's the layout for DataMap fetching source dataSummary: Content (please ensure you mask any confidential information): Hi, We recently got an issue when executing datamap via smartpush from rules, which errored out d…
-
How do i check the value of a run time parameter in a business rule?Hello, I need to check the value of a run-time parameter for the Period dimension in the EPM Planning Calc Manager (Calc script, not Groovy) and need help with the synta…
-
Setting UDAs in Main Hierarchy, but Filtering on Shared HierarchySummary: Data form contains a POV drop-down which references a section of our Shared alternate hierarchy filtering on a UDA. However, UDA filtering does not work. Conten…
-
PBCS - Migrated Financial Reports to Reports, but no artifacts are displayed in the target folderTested the migration of an existing Financial Report to Reports by using the Migrate Report icon (for a single report). I selected a target folder that was created in th…
-
Trying to list Base members using WITHATTR functionSummary: I am trying to allocate the expense for 2 different projects based on a input project entered by user. Here is my logic. Logic validates fine and it runs withou…
-
How to set up the EPM agent for Groovy scriptingSummary: I have used basic functionality of EPM agent, i.e extracting the data from on-premise database to EPM cloud in ASYNC mode. now i trying to get data using the AP…
-
Conditional Formatting in grids: Can I make a cell turn red after entering a value in another cell?Summary: Can Forms 2.0's Format/Validation Rule Builder apply conditional formatting to Cell 1, changing its color to red when Cell 2 is populated, if Cell 1 is initiall…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified…
-
Viewer role to launch BR for intersections they have access?Summary: Could a Viewer role launch BR for the intersections they have access to? Do not want to go by a named connection / Pipeline BR with Admin Cred Content (please e…
-
How to perform a mass file download when the cell-level document is enabled (in Forms)?Summary: When the cell-level document feature is enabled in Forms, what is the procedure for retrieving and bulk downloading all associated attachment files for review p…
-
Using [[PlanningFunctions.getIdForString("text")]] within a calc script in a groovy scriptHello, I am trying to save some data into a Text field using the PlanningFucntions.getIdForString within a Calc script, that is nested within a Groovy script. I have bee…
-
Drill down shared members in ReportsCan someone help me understand if it is possible now to drill down the shared members in Reports?
-
Writeback Text Accounts with Integration AgentSummary: Hi, I have created a writeback outbound integration to write data from the OEP_CPX cube to a table in the On premise database with the help of EPM Integration A…