OneStream Platform Forums

Hi everyone, I'm having a problem with the Harvest directory. Indeed, I have two batches running at the same time and which retrieve files from an SFTP to put them in the Harvest directory in order to load them into the WF corresponding to each file, for this I use this line coded :Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) But with this line I do not filter the files present in Harvest. Is there a way to filter by file name inside Harvest which seems to be common and mandatory? Thank you for your help

Hi All- We are trying to create a BI Viewer to compare Current v Previous Qtr OPEX. We look at the end date (only two end dates possible of course) to create a Current QTR measure (max end date) as below. However, I can't seem to get the syntax for the measure correct. Not sure what I am missing which is generating the error below: A Summary Expression is Expected    

We are capturing parent entity adjustments, and they are not rolling to C#Share. Any idea what the cause may be or how to enable this.

Hi All,   I need a same base member in different parent members in Account dimension and it should aggregate to their respective parents, do i need to create multiple base members or I can use the relation, can anyone suggest what is the best way to achieve it.   Thanks in Advance.

I have a requirement for a book to produce different views (i.e. Periodic, QTD, YTD) based on the WFTime. The periodic report should always appear no matter the WFTime, however the QTD Version will only appear in certain months. I cannot get the "if" statement shown below to trigger.  I have an item to change a dashboard parameter present in the CV as well.  Is my syntax incorrec on the "If" statement?  Any help would be appreciated!     

Could someone please direct me on where I can find documentation or training on how OneStreamEmail works?  How it can be implemented, authentication used, etc.?  I can't find anything when searching Design and reference guide.   

Hello Everyone,I am using a Delimited List Parameter which results a list of comma separated values from SQL through XFBR.When i use this parameter in Dashboard, it always shows as blank when it starts up, even though i have set the default value property.Looks like its a limition at this point of time.Are the any alternate ways we can use the default value for Delimited List Parameter in Dashboards ?

Hi, I am trying to build in an if statement in a cubeview (getdatacell formula) on the cell amounts. In specific: If cellamount of CVC(col 10) > CVC(col 11) then CVC(col1) else CVC(col1).  The reason why I am trying to do this in a cubeview getdatacell is because the col 10 an col 11 are referencing other columns and those other columns are referencing other columns in return. A workaround would be to recreate these column references in BR or create new members with formulas doing similar. But I am trying to avoid recreating this if possible. Hope someone have ideas. 

Is it possible to format cells inside a table in a report component so that the value displays as both a bar and a value similar to how it looks in the BI Viewer grid component in the image below? I am currently using a cube view to pull the data for my table in my report.  BI Viewer table with cell values formatted as bars and values My report table is currently formatted in the following way: Any help would be greatly appreciated.

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

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

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? 

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 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 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 All,Good morning.Could you please share the documentation on 'Auto translate Currencies option' in entity properties. Also, how it works in below mentioned scenario.Scenario:  I have parent A and Children B both are tagged with Default currency 'CAD', but I want to translate Base and parent to USD in this case can I set Auto translate Currencies option to USD to convert data to USD without changing Parent A default currency to USD.Thanks in Advance. Thanks,Sandeep