OneStream Platform Forums

Has anyone used BouncyCastle succesfully for PGP decryption? If so, would you mind sharing your BR?Thank you!  

Hello I have a CubeView with 2 nested rows. Row 1 - |!varEntity!|.Base (say this will return 5 entities - this is a drop down in a Dashboard) Row 2 - XFBR(myModule_ParamHelper, GetWBS_by_Entity, Entity=|!varEntity!|) This rule checks for WBSs where Text2 = Entity (i.e. WBS1 - Text2 = Entity1, WBS2 - Text2 = Entity2) When I execute the CubeView, I see all the 5 Entities, and in the nested Row, I get the WBSs where Text2 = the first Entity only). I understand why it is doing this, as the variable gets the same value and passes to the rule. I also tried |PovEntity| and |CVEntity|.  PovEntity returns blank, and CVEntity return what is in the Cube Pov section, which I tried with a value or blank. I also tried WBSDim.Base.Where(Text2 = |CVEntity|) --- or PovEntity - comes blank Is there a way to pass the value of each evaluated Entity row to the WBS row? The result should be something like: Entity1 WBS1   WBS2 Entity2 WBS3   WBS4   WBS5   Thx Raf

Hi - I am trying to get the confirmation entities from all of my Import Channel under my WF Profile. using extender BR but I am not able to find an instance to call the function. Any help would be appreciated ? I was able to get the Confirmed entitles at the WF Profile Level and the below is the code.  Dim A As String = String.Empty Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si,"Total_Corporate","Actual","2023M1") Dim objList As List(Of BaseNameIntPairInfo) = BRApi.Workflow.Metadata.GetProfileConfirmationEntities(si,wfClusterPk) For Each cent As BaseNameIntPairInfo In objList A = cent.Name brapi.ErrorLog.LogMessage(si,A) Next 

I have Cubeview which takes ~50 secs to refresh in OS. When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins. It is simple insert and refresh i.e. I do not have anything additional like VBA code etc in Excel. Is it normal for CV to take to take longer to refresh in excel? Any suggestion to optimize the Cube view refresh in Excel? Many Thanks.

Hello! Can't find the location where I can download all the templates below. Could you please point me in the right direction? 

I am trying to utilize a combination of Year() and PeriodNext1() within a GetDataCell, and it's not working. The combination of Year() and Period() within a GetDataCell works if you surround it with brackets, but once you add the Next1, it will not work. Any ideas as to how I can accomplish this?Example of GetDataCell with Year() and Period() working fine: GetDataCell(BWDiff(V#MTD:T#|!Prompt_TimeMonth!|:S#|!Prompt_Scenario!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp2!|)Period(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario2!|))Example of GetDataCell with Year() and PeriodNext1() which gives an error:GetDataCell(BWDiff(V#MTD:T#PeriodNext1(|!Prompt_TimeMonth!|):S#|!Prompt_Scenario_FW!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp1!|)PeriodNext1(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario1_Bgt!|))Error Message Received:Thanks!

Hello OneStream Admin Certified experts, I would like to perform the certification on OCA and need your experience on how to prepare and what are the documents to refer and minimum duration to prepare on self training. Thanks Sreenu

Dear community, Can you please suggest me way to get report of two cube view in single dashboard. in pdf and excel format. Any solution to this will be very helpful, Thank You

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