Answer They cannot be deleted as long as there are audit records that go along with the Cube View even if the data has been cleared. To clear this you would be required to run a reset scenario, however this clears out all workflows and data. Typicall...
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 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 Yes, once data has been loaded or the workflows have been used in any way and have logs associated with them, the only way either change the suffix or get rid of the root profiles is to clear all data and workflow logs using the Reset Scenario...
Question (cont) During build/development, we often create workflows that end up being redundant or unused. Once the workflow is used for loading data, it can’t be easily deleted and ends up under a “Deprecated” workflow parent. Can you please provide...
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 is an enhancement request for this (TFS 11301).However, you can use a SQL script to sort by name using this example:Select a.ProfileName, c.Name from WorkflowProfileHierarchy aJoin WorkflowProfileEntities b on a.ProfileKey = b.WorkflowPr...
Answer There is a snippet that shows one way of getting the workflow time. An example to obtain each of the above : Source: Office Hours 2020-12-03 Partner Enablement
Answer This is not possible at this time.NOTE: There is a pending enhancement request for this functionality (PF-2180). Please contact support if you with to add you or your customer to this request. Source: Office Hours 2020-12-03 Partner Enablement
Answer There are 2 options that can be used to accomplish this: If the data doesn’t need to be preserved in the ‘working’ scenario, a reset scenario data management job would work. If data needs to be preserved in the ‘working’ scenario, an Extensibi...
Answer Yes, this is possible. The following syntax will work: Remember that OneStream will look to the workflow that you have selected at run time, so you will need to ensure that you set up the relevant text property on the individual workflow step ...
Answer There is not an easy way to remove the deprecated form / hide it from being shown. It should stop being shown in subsequent periods based on workflow tracking frequency. Source: Office Hours 2020-7-16 - Jerri McConnell
Answer Yes. A lot of clients use the XFSetFxRate function in an excel file to load FX Rates. This excel file could be opened within a spreadsheet component and assigned to a form or embedded on a dashboard. This form/dashboard can then be assigned to...
