Answer The Data management jobs are kicked off by a DataQualityEventHandler. In the DataQualityEventHandler, there is a line that actually runs the DM job. ExecuteDataMgmtSequence - Runs the DM job and will not return control until it finishes. Sourc...
Answer There is currently no batch functionality for journals. A workaround is to run a BR that loops through all the journals for a specific time period and post each one. Source: Office Hours 2020-04-09 Partner Enablement
Answer Non-calculated data can be cleared outside of rules From Workflow: From Data Management Jobs: However, there is no equivalent of hs.clear to clear non-calculated data within OneStream (by design…because it “breaks” the audit trail inherent in ...
Answer For loading Analytical Blend, this is purposely stored separately outside of the cube, as it is optimized for high-volume transactional data.Loading Analytic Blend data into the cube normally defeats the purpose.However… More specifically: Can...
Answer Use the workflow type of “BI Blend, Workspace”. This way you can import/transform the data and then immediately afterwards use a dashboard to query review the data on each cycle. If the workflow tracking frequency is monthly then the a new BI ...
Answer In principle, an extensibility rule could be used to copy the data from one period to the next, however it would be inefficient use of space to simply duplicate data that is the same each period. Source: Office Hours 2019-12-12 Partner Enablem...
Question Continued Is it possible to dynamically reference the Source Field Name mapping “Figure 2”. For example, the application created is a 4-4-5 time series and dependent on the quarter interfaced the first week could be WK14, WK27 or WK40. Ideal...
Answer • The first consideration is memory available on the server• Next, there are stage settings that can be tweaked to optimize performance with very large volumes…see next slide for guidelines as discussed from our Implementation Class Source: Of...
Answer There is not a built-in setting to allow variation of mappings by time. However, this could be achieved using conditional logic on a mapping rule (not available on One-to-One mappings). Depending on the requirements, it may also be possible us...
Answer •Be aware that if you go back and reprocess prior months that leveraged the previous load process then it will clear out the data from those intersections. •These prior periods should be locked so data is not lost. •Audit integrity should be m...
Answer •Attached below is a number of FDX Connector .xml files that should assist with understanding more about FDX Connectors.
Answer By default, any dimension set as an aggregation will return the name field, however, this can be modified within the aggregation controls. Using one of the following at the end of the aggregation control will replace the label: N – Name D – De...
Answer One option to be able to see all relevant intersections is to increase the Grid rows per page for the user. This would allow up to 1000 rows to be shown per user. Alternatively, the intersection errors are stored to the database so it is possi...
