OneStream Platform Forums

Hi All - I recently came across the BRApi.Workflow.Metadata.SaveWorkflowProfileEntity and could not find any documentation. Does it get the name of the entity while saving which is attached to WF ? Any sample code would be appreciated Thanks 

Is there a way to get a dashboard to open up when the user click on a BIViewer component? Updating the Navigation Action here under Component Properties doesn't seem to work with BIViewer component.

Hi,Copy pasting data from excel into CV forms generally work, but the exception seems to be for date values (CV Cell Type - Date). Does anyone have experience with this and know if it's possible?  

Hi, I'm trying to get the amount of an objDataCellInfoUsingMemberScript but I couldn't get the data, I'm trying this:objDataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"KemetFinRptg", "E#LEGAL_Y:C#Local:S#Actual_YAGEO_Fx:T#2022M1:V#MTD:A#702006:F#Top:O#Top:I #Top:UD1#0021:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None" )'String to convertDim stringToConvert As String = objDataCellInfoUsingMemberScript.DataCellEx '<-- Update string to be converted'Convert to double. Set to 0 if string if not able to be convertedDim dblValue As Double = stringToConvert.XFConvertToDouble(0)  

Hi I always seem to get an "Object reference not set to an instance of an object" in the error log when I execute data loads that use connector rules.The full error message is: ---------------------------------------- Exception Type: Unknown Message: Object reference not set to an instance of an object. Stack Trace: at OneStream.Shared.Engine.XFTelemetryHelper.GetTaskActivityArgsInfo(SessionInfo si, TaskActivityArgs taskActivityArgs) in C:\agent\_work\411\s\Source\Shared\Engine\SharedEngineBase\UserActivity\XFTelemetryHelper.cs:line 55 The strange thing is that the data load is always successful... Does anyone know how to get rid of this error message?Thanks,Mark  

Hi All,I wish to change the property 'Show Manipulation button' of my SQL table editor to hide manipulation buttons if the workflow selected is a parent but show if the workflow selected is a base. Is this possible?Regards,Mark

Hi OS Community,We have custom business rule to manage Data cell access security (Slice security). We have created new row category(DHRStat_Fcst)select group and it should have Read access only to PLP register but issue is it also have write access to add or make changes to register (screenshot below highlight in yellow) which we are trying to retrict through BR. Custom BR code: Line 253-259 is it is for data cell read access for PLP registerLine 263- 264 is the code for write access for PLP register and we try to restrict by category, but it is still not working. If Not itemAccess.Category = "DHRStat_Fcst" AndAlso itemAccess.MemberFilters.Scenario.IndexOf(wfscenarioname) > -1 AndAlso brapi.Security.Authorization.IsUserInGroup(si, groupID) ThendashSet = "3b2b1w_RegisterMaint_PLP"End If Data access:I need help with the BR code change to restrict the write access to the particular Data cell category .Let me know if you need any more details.Appreciate your help!!

Hi, Is there a programmatic or any other way to log off all users in a certain application before a data management job runs? Because of a bug in Account Recon marketplace solution, the data load fails when the users are active. Ragav.

Anyway to put the company logo at the bottom? I have just seen that we can move it at the header but not the footer.

I am trying to create a business rule which returns a time member driven by the Workflow scenario member. My forecast scenario members are structured as Jan_Fcst, Feb_Fcst...Dec_Fcst. For instance, Dynamic time filter, Year = WFYear and period based on Scenario, eg Jan_Fcst = 20**M1, May_Fcst = 20**M5. Does anyone have a snippet or suggestion on how I can go about doing this? Also, I was going to use it as an XFBR rule and I don't know how to run the BR by itself in order to look at the error log for help testing this rule. Any help is much appreciated.

Does anyone know what the attached "KPI" component is?  I attended one of the OneStream Demos and they presented this dashboard with these KPIs at the bottom.  I can't seem to figure out what component they used. 

Entirely tied to the moment we upgraded the clients to version 7.1.3 we started getting the Windows "pick an account" window when they select External Authentication. We are cloud hosted.  I've opened a ticket with Onestream and with our internal resources, and no solution.  Anyone else experience the same or is it just us?

Hi All,  i am presenting to you a situation to understand if what we are trying to do is feasible.We are currently defining the transformation rules for a Client and these rules are quite complex, including composite logics (multi dimensional) and ranges and lists and masks. Based on our tentatives it seems that composite rules only accept masks as type of mapping apart from single code mapping. is there a way to use Ranges and Lists in composite mappings?I.E. A#[40610047;40610099;40620001]:U5#[??1000????;??1001????;??1002????;??1003????;??1004????;??1005????;??1006????;??1007????;??1008????] Thanks a lotMarco

Hello OneStream Community,I am using the SaveDataEventHandler to validate a cell amount being saved. Depending on certain conditions I update the amount in the “args.NewDataCell.cellAmount” and set “args.Cancel = False”.Instead of the modified amount in “args.NewDataCell.cellAmount” the original amount entered gets saved. In the snippet of the code below, a sample error log output when a user inputs 4.3466 in a form would be:Amount Before = 4.3466Amount After = 4.35But the saved amount in the form will be 4.3466.----Snippet Start-----BRapi.ErrorLog.LogMessage(si,"Amount Before = " & args.NewDataCell.CellAmount)args.NewDataCell.CellAmount = Math.Round(args.NewDataCell.CellAmount, 2, MidpointRounding.AwayFromZero)BRapi.ErrorLog.LogMessage(si,"Amount After = " & args.NewDataCell.CellAmount)args.Cancel = False----Snippet End-----Please advise.

Hi,   Would be great to get your thoughts on the below:   I have 2 cubes with 2 different time profiles attached – Standard (Jan-Dec) and AugYearEnd (Sep – Aug)   I have used the below query successfully in CVs to get the time description based on the cube selection.   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=CB#GroupReporting_AugYE))   Variations of the above also work:   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=CB#|WFCube|)), à more dynamic, or   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=AugYearEnd))   However, when we use this in a dashboard member list parameter, this doesn’t seem to work and always returns the description of the standard time dimension. In the 'Data Source' condition of the parameter, I had mentioned the specific cube and was hoping the time desc

I am trying to suppress rows in a cubeview  that are less than 10%.  I have the variance % as show below. For some reason zero suppression threshold is not working on this data point.     

Hi All - I am trying to create a View using a Extender BR and It is compainling without any issue but when I try to execute it am getting the below error. Any help would be appreciated.   Dim vSQL As New Text.StringBuilder() vSQL.AppendLine("CREATE View dbo.v_stageData AS SELECT WFP.ProfileName As WorkFLowProfileName, S.Sn AS SrcScenario, T.SnT AS TgtScenario, S.Tm AS SrcTime, T.TmT AS TgtTime, S.Et AS SrcEntity, T.EtT AS TgtEntity, S.Ac AS SrcAccount, T.AcT AS TgtAccount, S.Fw AS SrcFlow, T.FwT AS TgtFlow, S.Og AS SrcOrgin, T.OgT AS TgtOrgin, S.Cn AS SrcConsol, T.CnT AS TgtConsol, S.Ic AS SrcICP, T.IcT AS TgtICP, S.U1 AS SrcU1, T.U1T AS TgtU1, S.U2 AS SrcU2, T.U2T AS TgtU2, S.U3 AS SrcU3, T.U3T AS TgtU3, CAST(S.Am AS DECIMAL(18,2)) AS Amount FROM StageSourceData S INNER JOIN StageTargetData T ON S.Wfk=T.Wfk AND S.WtK = T.WtK AND S.Ri = T.Ri INNER JOIN WorkflowProfileHierarchy WFP ON WFP.ProfileKey = S.Wfk WHERE T.SnT = 'Actual' AND T.TmT = '2023M1' AND WFP.ProfileN

Hi everyone, I was trying to add drill down capabilities to a calculated flow dimension member but was having issues with the drill down formula. I entered the formula below but still wasn't able to drill down into the flow member at all. Does anyone have any ideas on why it's not working?   Formula:   Formula for Calculation Drill Down:  

Hello,Can someone please guide me to any useful document or link on Smart Integration Connector ? BR,Avijit

Hello all,I am building a planning application on which the end users interact via drop-downs for Entity and UD1 members, and click a "Save Inputs" button that saves input data and runs a custom calculation on the selected entity and UD1.This is done through a data management step that runs a business rule, and on which the selection of the UD1 and Entity impact the business rule to avoid recalculating all the application each time. There are 6 business rules, that respond to different functional models, activated by different "Save" buttons across the application.I want to create a button or data management sequence that will run all the business rules (the 6 models) for all UD1 members of the 4 entities, as an admin task. I have created a Data Management sequence that runs the 6 steps consecutively, with its corresponding button, but have not been successful to modify the arguments or the Data Management parameters to perform the calculation for all members, as I cannot input "E#All"

Is it possible to use the linked navigation to pull a dashboard based on a scenario? I have 2 separate dashboards that are pulling 2 separate BI Viewers for 2 separate Data adapters. One pulls data from a relational table based on actual data and the other pulls timestamp information based. What I want to be able to do is if the column is actual then pull the dashboard that has the Bi Viewer with the actual detail. If the scenario on the column is Working, then pull the dashboard that shows the timestamp info. The scenarios on the dashboard changed based on the date selected using a date selector. Currently I have both dashboards linked to each column and when you right click you have the ability to select either dashboard but I only want the user to have the ability to have one predetermined selection based off the scenario.

All - The below extender rule will be able to delete multiple member from Parent Hierarchy.  1. Provide the Dimension Name & Top Parent Name in the Hierarchy - See highlighted in Red. 2. I want to make a point here the While Count > 3 because the it takes the current parent and other member ENtityDefault1 & None. Since we will not be able to delete it so it should be 3 or loop will be infinite.  3. You can use as an input Variable for Dimension and Top Parent and attach to the dashboard but this is a good starting point.   Dim dimensionPK As DimPk = BRApi.Finance.Dim.GetDimPk(si,"Dimension")Dim nValue As Integer = BRApi.Finance.Members.GetMemberId(si, dimensionPK.DimTypeId,"TopParentName")Dim objList1 As List(Of Member) = BRApi.Finance.Members.GetAllMembers(si,dimensionPK,nValue)Dim objList2 As List(Of Member) = BRApi.Finance.Members.GetBaseMembers(si,dimensionPK,nValue)Dim mbrct As Integer = objList1.CountWhile mbrct > 3For Each mbrbe As Member In obj

Hello,Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want the output as paste special values. thank you 

HiDoes anyone know if it is possible to create a 'Read only' column in a SQL table editor?I have set the column format 'AllowUpdates = False' which almost gives the correct functionality. However, the field is still editable when you insert a new row.I currently get around this by completely ignoring the value in the field during the SQL Table Editor Save Data Event, but I wondered if it is was possible to ensure that it never appear editable to the user?Regards,Mark

Originally posted by Matt Grundey 11/6/2017 Hi, has anyone any examples of using Cubeview extender rules to change the logo displayed in a report based on the entity selected. I'm aware that this wouldn't work where entities are shown in rows or columns. I can't see any examples of passing in parameters into these rules that could identify the entity, nor can I see from the reference doc how I can get the entity that the report is using.