Answer The general rule of thumb is to NEVER modify the Default Workflow profile. There are ramifications through the application when these properties are changed and generate numerous tickets with our Support team when this happens. Source: Office ...
Answer Parent Input Workflow profiles have Parent Entities available for assignment, but Base Entities will not be available for assignment. However, you are not prevented from entering data to Base Entities with this set up. Source: Office Hours 202...
Answer There are numerous Enhancement Requests related to this:PF-385, PF-1309 Source: Office Hours 2020-10-08 Partner Enablement
Answer Not currently, but there are several enhancement requests pending for this and similar functionality. Source: Office Hours 2020-10-08 Partner Enablement
Question The Method query WorkflowProfileEntities, available on Parameters and Data Adapters, returns an unsorted list of entities assigned to the WF Profile. How can we sort it? Answer There is no way to do it with that particular Method, but you ca...
Answer The bars are based on the Cube View intersections. You can add a row/column indicating adjustments to display the total impact. Source: Office Hours 2020-10-08 Partner Enablement
Answer There is a knowledge base article (KB0011011) entitled "How to Clear the Data Cells in a Specific Data Buffer" that may assist in this.Because OneStream stores data only against the base members in the Account dimension, there is no need to cl...
Answer There are several options, but approach really depends on the scope of the export (number of periods, rate types, etc…all or partial?). Option 1: Build an Excel template that can be accessed refreshed and saved as a CSV file. This will enable ...
Answer Appears a Force Consolidation wasn’t run after the changing of the Summary IC account to IsIC = True. Source: Office Hours 2020-10-22 Partner Enablement
Question Setup instructions indicate that the Account Reconciliation functionality requires data to be loaded on a YTD basis. Is it possible to still use Account Reconciliations if data is loaded by default on a periodic basis? Answer Yes, but a new ...
Answer From the Import step within a workflow and click “Retransform”…the Import chevron will turn green Then, you can Validate then Load the stage data (which technically is blank) and it should clear the residual data in the cube for that Workflow ...
Answer On the main properties of the connector, select “Matrix Data” on the data structure type. For the Account dimension, select “Matrixed Text” as the Data Type so that the application knows that is one of the fields that needs to be matrixed. For...
Question (cont) Can that be done within the member filter, or does it require a business rule? Answer There are two possible solutions: Use UD Attribute members Data is not loaded directly to an Attribute member. Instead, its results are derived from...
Answer The member filter above is not complete, as it does not contain an expansion expression. The following would be valid uses of this function: E#Tot_Mgmt.Base.Remove(Houston) E#Tot_Mgmt.Children.Remove(Houston) Note: Currently, the Remove functi...
Question (cont) The example below is for an operating expense that I want to be filtered using a text property of “HP” (a specific business line). I thought the following would work, but it is still pulling in the total company business line, not jus...
Answer There is an enhancement pending for this functionality. Contact Support to be added to this request. From 6.0.0, Complex Cube View Column Math calculations can now be derived using hidden columns. The IsColumnVisible, Column Header Formatting ...
Answer The Read Data Group is not within the member properties available when using the BRApi SaveMember function. If the desire is to perform a one-time update, consider building out the logic in the Excel Metadata Builder or use the Grid View funct...
Answer In the PDF style reporting, one option is to use the “ReportBandHeight” property. For a Data Explorer report, another option is to create a row that uses a member filter that returns no results (e.g., S#None:A#None). Source: Office Hours 2021-...
Answer Based on testing, there does not appear a significant difference in processing time when using an API Business Rule vs. an XML load.. Whether using the API or XML upload, the system is still going to perform a check of the database tables to e...
Question (cont) We are currently using a business rule to move operational data between cubes. The two cubes have very different dimensionality, including using different entities. Answer The use case will help determine the best approach (e.g., Is e...
akloepfer
jvonallmen
