Enhancing User Management in Security Groups
Hi, We are currently using a Dashboard that allows admin to remove users from Security groups. I would like to enhance this functionality so that approvers, rather than admins, have the ability to remove users from security groups. Currently, the system security roles under the " System tab" are set to "ADMIN" by default for the "Manage System Security Groups" setting. Unfortunately, we cannot make changes to these System Security roles due to the large number of approvers across various groups. Could you offer suggestions or guidance on how we can implement this enhancement effectively? Thanks in advance.Service Factory - Data Management Step
We're moving most of the Business Rules to Workspaces Assemblies under PV 8.4. - We have several Extensibility Rules that are run by multiple Data Management (DM) Jobs like you. - Hence, we included separate DM Step Services (DMSS) in the same Service Factory (SF). - The result of this SF setup was chaos. - We saw that launching one DM Job by a given DMSS in the SF will also launch other DM Jobs by their DMSS in the SF. We couldn't find enough practical advice on the SF/DMSS setups in the Design Guide to overcome this chaos. Pls share how to set up Data Management Step Services in a Service Factory to launch one Extensibility Rule/DM Job at a time. TY.
DataManagementEventHandler Args
Hi, I try to get the data unit information of different DM steps, such as Calculate, Copy Data, Reset Scenario, Clear Scenario, Custom Calculate. For a regular "Calculate" I'll get the information via Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataManagementEventHandlerArgs) As Object Dim sbLog As New Text.StringBuilder Try Dim returnValue As Object = args.DefaultReturnValue Dim dmStepMetadataInfo As DataMgmtStepMetadataInfo If args.OperationName = BREventOperationType.DataManagement.ExecuteStep Then dmStepMetadataInfo = DirectCast(args.inputs(0), DataMgmtStepMetadataInfo) Dim entList As String = String.Join(",",dmStepMetadataInfo.EntityInfos.Select(Function(miMem) miMem.member.Name).ToList().ToArray()) as it is described in another communits-post. But if I do a "Copy Data", I don't know how to get the submitted data unit. args.inputs(0) is of type OneStream.Finance.Engine.DataMgmtStepMetadataInfo as far as I know from using the error log messages. But there is no documentation of the type "DataMgmtStepMetadataInfo" and I won't get the data unit infos the same way I did in the code above. args.inputs(1) is less interesting. It contains the user name, the DM step description and task activity information. There are no more args inputs. Any ideas how to pull the data unit information out of "DataMgmtStepMetadataInfo"? Regards, Marcus
Account sign flip based on time
Hi everyone We want to do a sign flip on an account to be applicable from a certain period. The sign flip must therefore not have an affect on historic periods. The requirement is as follows: Perform a sign flip on an account data coming from a source system using a transformation rule complex expression where the month period is > 202412. We would appreciate suggestion from anyone who has performed something similar in the past. Thanks Johan
Slow performances with dynamic accounts export
Hello, We experience performance problems when we try to export Onestream data for insertion into a third-party system. For 100 entities and 12 months, processing takes 20 hours and is often killed by the system. Apparently, it's the dynamic accounts that take up a lot of time during extraction. Do you have the same problem and what are the solutions to optimize the export? ThanksAudit trail for O#Import data
Hi, I've been looking into the audit trails for O#Forms and O#Import data. The audit trail for O#Forms data seems to be in good shape, with changes tracked in tables like DataEntryAuditCell and DataEntryAuditSource. For O#Import data, I've found some audit information in the staging area tables, such as StageArchivesInformation and vStageSummaryTargetData. However, this doesn't cover everything - for example, it doesn't account for data that's been imported but not yet loaded into the cube, or data imported using a business rule. Is there a way to get a more complete audit trail for O#Import data, that focus on the Cube data rather than Stage data?
Extract of all artifacts-names only
Hi, I was wondering if anyone knew how to get an extracted list of all artifacts within an environment by artifact types such as business rules, transformation rules, cube view names. I am only interested in getting the names/metadata of each artifact and not the actual data from the artifact. I would like to put these in an excel workbook. Thanks! Manuel
copying quarterly inputted data into Monthly scenario
Hi, want to copy quarterly input data through business rule. the destination scenario is defined as monthly input. in the destination code , i want to specify months which system doesn't allow. we need pass in DM Job. As i have several quarters to copy , can anybody share some thoughts how we can achieve this. Thanks, Swadhin.Is it possible to setData using SaveDataEventHandler?
Hi everyone, We’ve been using the SaveDataEventHandler to prevent users from submitting zero values for a specific scenario and flow. While the error message works perfectly in the Cube Views, we’ve encountered an issue when users try to submit a zero from Excel—no error message is displayed. From what I’ve read, error messages don’t work in Excel. As a workaround, we’re considering a different approach: instead of throwing an error when a zero is submitted, we would save the zero as NotStored (dataCellStorageType.NotStored) and NoData (dataCellExistenceType.NoData). However, despite our efforts, we can’t get SaveData to function as expected. Has anyone encountered this issue or have any ideas? Dim ScenarioName As String = "Actual" Dim FlowMember As String = "USDOverrideEndBal" If args.NewDataCell.DataCellPK.ScenarioId = BRApi.Finance.Members.GetMemberId(si, dimtype.Scenario.Id, ScenarioName) Then If args.NewDataCell.DataCellPK.FlowId = BRApi.Finance.Members.GetMemberId(si, dimtype.Flow.Id, FlowMember) Then If args.NewDataCell.DataCellPK.OriginId = DimConstants.Forms Then 'Check if it's Real Data If args.NewDataCell.CellStatus.IsRealData Then 'Check if it's a hard zero If args.NewDataCell.CellAmount = 0 Then Dim NewNumber As Decimal = 0 args.NewDataCell.SetData(NewNumber, dataCellExistenceType.NoData, dataCellStorageType.NotStored) End If End If End If End If End If Return args Thanks, Victor
