OneStream Platform Forums

Hello All, We had to make changes to our 2022 (Prior period) data as we identified some issues with it. We cleared the data and tried reloading a bulk file with Full year 2022 data (Split Quarterly). Previously, We used to batch import data in one period (E.g. March), all the other quarter end months would automatically get a green tick and show data for that period in staging table.This time when we loaded numbers to March (data included periods M3,M6,M9,M12 for 2022), we can only see the data in March (M3), we are not able to see data in other periods. Please find the below snap for  reference.   Any help would be appreciated.

Hi,I would like to remove the plus or minus symbol next to member names in a cube view. Is there a setting to do that?I am not sure why the CV is showing the expansion symbol since the members are all siblings (the cube view has A#Acc00700.Children in the pic above), but the cube view shows the symbol plus/minus on the row corresponding to the first sibling. Thank you

Guys , Any idea on how to write a business rule that retrieves a list of all Revenue Accounts .Thanks 

Hi,I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary.As I have to change the view to “Annotation” in order to import a text value, I was thinking about duplicating the rows by a derivative rule and change the view in that rule. The outcome shows the duplicated rows, but these are missing the text value. So this approch is not working.I also tried to duplicate one time column and use a parser rule to change the view. Doing so, I would need to identify, which time period I am in during pasing, as otherwise all rows are changed.Any ideas about that?Regards,Tobias

Hello,How can I change the POV for a Cube View I open in Excel? Is this possible? Regards,Ronnie Karpinski

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.

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!

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, 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 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"