OneStream Platform Forums

What is the formula to pull the Exchange rate data via a formula into an extensible document (word) 

Hi everyone. I have this error when trying to insert data into my SQL table 'System.OutOfMemoryException'. This occurs when I use .base to retrieve all my departments. The following is how I enter the values of a table into SQL using a loop, so I would like to know what I can do to avoid that error when I want to add many values to that table. For Each isRow As DataRow In dt.Rows Dim sqlInsert As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, [View], Account, Flow, Origin, Ic, UD1, UD2, UD3, UD4, UD5, UD6, UD7, UD8) VALUES " & $"(1, {Amount}, '{Annotation}', '{SourceRule}', '{DriverRule}', '{Type}', '{StepDesc}', '{TargetRule}', '{AllocRule}', {Generation}, '{Cube}', '{Entity}', '{Consolidation}', '{Scenario}', '{Time}', '{View}', '{Account}', '{Flow}', '{Origin}', '{Ic}', '{UD1}', '{UD2}', '{UD3}', '{UD4}', '{UD5}',

Dear Community, I am struggling with components that are coming from 2 differents workspaces. Right now, I have a dashboard which is in Workspace A, that have a cube view cube and buttons to open other things in dialogbox from the same workspace. It's working fine on its own. I have dashboard in workspace B, where I need to embed the dashboard from workspace A. I ensured that both are shareable workspaces, they also have shared workspace names. My problem is, and I can see it in the dashboard design mode, none of the parameters that are in the embedded dashboard from workspace A are shown, so it behave like these input parameters don't exist and its messing up everything. I've seen these options since V7.4 related to "Embedded Custom Control Dashboard" but I don't know if I can use this to solve the situation ?   - Parameters from Dashboard A (workspace A): - Parameters of Dashboard B with embedded Dashboard A (Workspace B). As you can see, none of the parameters from Dashboard

Hi All,  I would like your help. I installed OneStream as a plug-in using MS Excel. When I try to create a pull or refresh a sheet this is what it shows: "Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0-1".  Any chance you know how to fix this issue?

Hi I am loading data into a Bi Blend table and I don't want any aggregation applied. My understanding from the documentation is that I can use 'SSOnly.' However, whenever I try use this I get an error. Below is the config: Question 1: Am I doing something wrong in my config or is my understanding of how it works is incorrect? Another idea of mine is to set the Blend Unit Dimension Token to a UD member which will only ever have 1 member (e.g. UD4 and set the Aggregation Info to 'None'), so the aggreation should never create any additional aggregated parent records. I have tested this and it appears to work but I am worried that there is a potential issue that I'm not aware of... Question 2: Is this a viable workaround and is there anything that I should be worried about if I follow this approach?   Thanks, Mark    

Hi,I have a cue view report of below settings:Net Sales row: A#NSStd cost row: A#SCgross Margin row: GetDataCell(A#NS - A#SC):Name("GROSS MARGIN") Col1: S#BudgetCol2: S#RollingBud Col3: GetDataCell(CVC(Col1) - CVC(Col2)):Name("VARIANCES")Col4:GetDataCell((CVC(Col1) - CVC(Col2))/CVC(Col2)):Name("VARIANCES%")BUT you can see below the col3 and col4 for the gross margin cell has a wrong calculation.It should be 335501-1736404 = -1400903 but it shows +1080805.May I know why there is error and how to fix it? Thank you.

Hello again, I am creating a pivot grid through a data adapter that works with SQL. The issue I have is that my column of months is not organized in the pivot. Values example: Values in the pivot grid: How can I solve this so that it adapts to how it is organized in the data adapter?

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros. I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables). What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there... Thank you

Dear OneStreamers! Building and maintaining an OneStream application can be done in many ways, but I would like to hear how you have approached the challenge of managing the build process, hereby testing, deployment etc. I would like to hear input around:Build Process:What tools/methods make your build process a breeze?Any automation gems? Version Control:Git, SVN, or something else? How?Share your repo structuring magic and any branching/merging tips.Visual Studio / Visual Code?Testing/Quality Assurance:Testing? Automation, frameworksCI/CD Integration:How do you deploy between applications/environments?Challenges and Wins:What hurdles have you faced in this realm?Any game-changing solutions?Thanks for any input. Maybe we can gather some wise words

Hello All, I am creating a confirmation rule with the following goal: - Read data attachment text from from a V#Annotation field  Due to my unfamiliarity with the DataAttachmentList object, I have been unsuccessful in utilizing this list within my rule. I wanted to reach out to the community and see if anyone could help correct my mistakes. My code for testing is as follows:    

Hi, I have created dashboard with multiple dashboard group. Is there a way for me to disable some of the groups and shoiw  what is relevant in Oneplace by security to the end user? In this case- I want to only keep DS01_Cube data and not DS02_Period_Filter   Thanks    

Currently, we have a manual process that involves a user running a Load and Transform that uses a data source with a DM Sequence as its source. That sequence uses the |WFScenario| parameter. This all works great until we try to schedule it. I pass the scenario and the time in with a parameter at the Sequence level. The first step takes this parameter (e.g., Scenario=BudgetFinal) and creates a trigger file in the Batch folder and runs ExecuteFileHarvestBatch. The correct workflow executes but appears to be pulling its data (via that first DM Sequence/Data Source using WFScenario) from my current, user WF/POV. I've tested this by navigating to correct WF/Scenario, then running the DM job I want to schedule and the data successfully imports. If I then navigate to a different scenario and run the same DM job again, the import fails with the error that there is no data. I would expect the WFScenario parameter to use the scenario of the WF that is specifically calling the parameter but that

Hello, Is there a way to pull the account type in Excel add-in for OneStream? I tried using XFGetCell and XFGetMemberProperty and it didn't work.  Thanks, Will

Hello,Question: Is it possible to retrieve the POV of a clicked cell inside a Quick View through a "Spreadsheet" Business Rule ?Context: I want to be able to generate 'Table View' analysis based on any workbook/worksheet's Quick View POV or ideally the selected Quick View Cell POV. I can easily do so with a linked CubeView and its bound params, but for I am wondering if it's possible for QV

Hi everyone,I have a case in my hand I'd like to get your opinions on. I have an 12 period application already built so custom time dimension is not an option.The request is:1. The client wants the P12 results to be available for reporting but the P13 results will be final results for the year.2. They use P13 just like any period. There will be data load, journaling, data inputting and consolidating.I have an option in mind to handle this but let me know your comments and/or any other suggestions you can think of.Building a dashboard that would run a data management job to push the data from Actual scenario to Actual_P12 scenario to archive the data there. After doing that they can override P12 data in the Actual scenario with P13 data. If I'll go with this option I want that copied data locked and not changing even if they run a consolidation. Can you let me know how I can do that? 

May I ask how to use Case IS = ExtenderFunctionType.ExecuteExternalDimensionSource? It will be great if we have use cases and examples. Thank you

Hello, I have several Bi Viewer reports and I have recently upgraded my Solution to V8.0.0.15105 and I am facing issues with BI Viewer component not rendering graphics when used in a dashboard. FYI, this works fine in V6, V7. For example: I have defined rules on column "Time Graph". As you can see from below, it works fine in edit mode but when rendered in dashboard it doesn't shows graphics. Is there some setting or something I am missing in V8. Thanks.    

 I have a source file that will be updated/changed with the entities being loaded every time when it is loaded via a WF.In Order to preserve the balances of the Entities previously loaded I am thinking to have Source ID same as my Entity Name as I don't see any "Merge" Mode Load Option in WF. Is there any other way or better option to load files in Merge Mode.

I have a dashboard parameter of type delimited list and I want to get the value from the parameter in a dynamic UD8 member. How do I get the parameter value? If I use the following code I just get the default value of the parameter (because the parameter isn't a literal type): Dim sValue As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "myParameter")brapi.ErrorLog.LogMessage(si, "sValue " & sValue) so I need to use a method other than BRApi.Dashboards.Parameters.GetLiteralParameterValue but have no idea what and don't seem to be able to find any documentation to help find what to use.

Hi - I am having issues with using the PriorPeriod12() in a row override. The following filter is supposed to use the PriorPeriod12() function to return the same month last year (e.g. input of 2023M10 should return 2022M10).  GetDataCell(T#|!Param_Select_Time!|:U2#Alt_AandG:V#Trailing12MonthTotal/A#EndingACV:V#MTD:U2#Alt_AandG:T#PeriodPrior12(|!Param_Select_Time!|))) However, when I replace the T#PeriodPrior12(|!Param_Select_Time!|) with say 2022M10, then the override works. Any ideas of a work-around? Thanks,  

Hi - I want capture data cell values from two columns of the cube view and save them as a list and used the list to loop through the calculations. i would appreciate help with a sample code or guidance. Thanks. YM.

Hi, I'm having trouble running a relatively simple Copy Data data management step. The step's source and destinations share the same cube, entity, time period, and view. They differ only on scenario. The step copies all of the imported, forms and adjustment data. There is data at the specified intersections (cube-scenario-time-entity-view) in the source. However, when I review the destination , I do not see any data copied to the destination. What else should I be checking to ensure that my Copy Data step works?  Thanks!

Hi, On the September forecast in OneStream, the beginning and ending balances on the Cash Forecast report from FY 2024-forward are not matching. The balances are matching correctly before FY24. The ending balance of the FY should match with the beginning balance of the next FY. In the past, this was related to workflows entered but not fully processed by the cube. But in this scenario, all workflows have been entered.  Tried to drilldown on the BEGBAL/ENDBAL cell and check the entity base to know what caused this amount but the option is disabled here.  What can be the possibilities for this issue to be caused and is there anywhere I can search for and solve this issue.    

Hi, I am creating a new entity, but the currency is not available under the settings Currency option. How can I create or add a currency in this specific setting field? Thanks!  

Hi community, With a button in a dashboard, I want to open an Excel file: FileSourceType=Dashboard, UrlOrFullFileName=[Input_Sales.xlsx], OpenInXFPageIfPossible=False, PinNavPane=False, PinPOVPane=False If Input_Sales.xlsx is in the default workspace, this works fine. If it is not I can't get it to work. Which syntax can I use to open a file from a specific workspace? With kind regards, Tim