OneStream Platform Forums

Hello - is there a way to make the below work inside GetDataBufferUsingFormula .Getting Error processing script 'V#Periodic:F#EndBal_Input:A#:U1#USF02'.Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#[PNL].Base.Where((Name StartsWith '4') or (Name StartsWith '5') or (Name StartsWith '7') or (Name StartsWith 'X'))], [U3#[TopUD3].Base],[U2#[TopUD2].Base])").Looks like not recognizing filter with 'or' inside where clause.  Below works fine without an 'or' condition.Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#[PNL].Base.Where(Name StartsWith '4')], [U3#[TopUD3].Base],[U2#[TopUD2].Base])").

Hi, we are currently in the process of Finalizing a Data integration process (via connector) between some temporary staging tables created in the Onestream application (on cloud), but when i try to perform the final step to load the data, the system always returns me the message that allof the rows i'm importing are NON-NUMERIC. Obviously that's not the case. the source table amount column is a numeric format and the amount field in the source field is being mapped to the Amount field in the data source.  Did Anyone experience this?Thanks

Hi all,I have an issue with table view number formatting. On my SQL query, I'm introducing the format: Select FORMAT (Sum(Year_01), 'N2', 'es-es') as Year_01 ")After that, I populate the table view applying the true option in "UseDataTypes"tv.PopulateFromDataTable(dt, True, True)My issue is the next one: the format seems correct but, after openning or refreshing the tableview, it introduces the value as Text. I must enter on a cell and click the enter button to be able to recognize it as number.  Does anyone have the same issue? Thanks,Albert  

We have a workflow that uses Data Management Export Sequence to load the data. Manually we are loading the data fine but I'm looking for any options to automate this process.I have an example if the workflow uses a connector business rule but not sure on the Data Management Export Sequence. If anyone can help, it would be great...!!!

Hey all, I'm struggling to figure out how to define a TableViewColumn to be of type Decimal instead of the default type being Text. I'm in the section where I create a TableViewRowHeader and adding TableViewColumns to it. I can create a new column: Dim myTableViewColumn As New TableViewColumn myTableViewColumn.Name = "Col1" But when I try to set the type to this column, I get an error " Input string was not in a correct format." when trying to retrieve the table: myTableViewColumn.DataType = XFDataType.Decimal Is this syntax correct? I'm assuming that it's in the column definition where I should be defining the datatype but now not so sure. Hopefully someone can point me in the right direction.   As a side note,  page 15 in the Table Views User Guide makes reference to a function called CreateTableViewColumn. Is this a custom function or part of the OS library. The compiler doesn't recognize this function.    

Hi I'm trying to link this form to an Headcount correction form but when I navigated to this linked form, It shows me in the Group adj column green cells. How can I make them imputable? 

Is there any way we can use the transformation profile one to one mappings in a data table. Preferable to use in a connecter Drill back code. Is there any Data base table for the same.If not, we have a create a custom XFC table in application DB to refer the same that replicates the transformation profile.

Hi,I have set one Time Profile in one cube from Oct 2018 to Sep 2019 (first fiscal year) and another Time Profile in different cube from Jan 2019 to Dec 2019 (second fiscal year). I need to present Consolidated Report of both periods from beginning of both fiscal years simultaneously in one dashboard. Can anyone help ? 

Hi, Is there any way to get DataManagement step failure email notifications? I have one sequence which use some DM steps to perform Clear and Consolidations. I do not want use a business rule to call in a Custom calculation.Thanks for your help in advance. 

Hi,I want to have a consolidated report from Oct to Sep of any year. In order to achieve this, one time profile is created and attached to a cube and the same cube is used in cube view. What should I write in T# for cube view column ? Thanks in advance.    

Hello, I have a sub folder that is being populated each month with a variety of files, it is different from month to month.  The naming convention of the subfolder is consistent.  It is always the fiscal period.  However when I try to zip the files in the folder I am unable to define a path.  The folder is "Application Database/Documents/Public/" then the fiscal period.  However my code is never able to find it.  I think it is because we are on the cloud.  Any insight on how to define the process for zipping all the files in that folder into one document so it can be sent out through parcel service would be appreciated.Thanks,Tom

Is it possible to add already existing parameters to a report that is being created through the report designer tool in dashboards?On that note, is there any type of user guide for this report designer tool?

I have a process that builds a data buffer using Data Buffer Cell Loop logic. I need to check the cell status on each record and perform certain actions based on the status. Specifically, I want to make sure all 12 Account-Type dimensions are referencing a base member and correct them if they aren't.However, I'm not getting the correct Cell Status when the cell is in a data buffer. For example this code creates two data cells and logs their status. (In this case, I'm looking at DataCells, but the behavior is identical on DataBufferCell objects). Metadata is from GolfStream.: Dim baseMemberFilter As String = "A#50200:O#Import:U2#None:U8#Test" Dim cellPk As DataCellPk = api.Data.ParseDataCellScript(baseMemberFilter) Dim cell As DataCell = api.Data.CreateDataCellObject(cellPk, True, 100, False, False) api.LogMessage("Base UD2 GetMemberScript: " & cell.DataCellPk.GetMemberScript(api)) api.LogMessage("Base UD2 CellStatus.UD2HasChildren: " & cell.CellStatus.UD2HasChildren) Dim

Hi all,the SetDataCell command I am trying to use is behaving in a strange way and I would like to check if that is a bug, if it is by design, or if I may be doing something wrong.I am trying to use the SetDataCell command to clear data on the Origin=Forms. The command looks like this (it is part of a custom calc rule):'Clear data on the Form memberapi.Data.SetDataCell("Cb#Main:E#" & MainPovEntity & ":S#" & MainPovScenario & ":A#AC410000:U1#None:U2#None:U3#" & UD3Name & ":U4#None:U5#Local_GAAP:U6#None:U7#None:U8#None:O#Forms", 0, True)Now, if the UD3 member which I am trying to clear has data on the Origin=Import member, the Forms member is correctly set to zero by the rule. However, if the UD3 member has no data on the Origin=Import member (on that specific Pov intersection defined by the rule above), the Forms member retains its value. Anyone else experienced this behavior? Thank you

Hello OneStream Community, I hope this message finds you well. I am reaching out to tap into the collective expertise of the community regarding metadata extraction from OneStream. Your insights and experiences on this topic would be invaluable. Process and Tools: What process and tools have you found effective for extracting metadata from OneStream? Are there any specific approaches, techniques, or best practices that have yielded successful results in your organization?Alation Software Integration: Has anyone in the community utilized Alation Software for metadata extraction from OneStream? If so, we would greatly appreciate hearing about your experience with integrating Alation and extracting metadata from OneStream. How well did Alation cater to your organization's requirements and enhance your metadata extraction capabilities?Connectors, APIs, and Custom Solutions: Can you provide specific details on any available connectors, APIs, or custom solutions that enable metadat

 Hello Experts,I have simple SQL editor component in a DB. as Admins we can use the toolbar to Insert/Delete/Save in the SQL table behind the scene. for end users it is disabled is there any other setting that needs to turned on? Appreciate the help.  

Hi All,I am using  FdxExecuteDataUnitTimePivot to export data from onestream cube, everything working as expected except one issue. i.e., I am using consolidation member C#Aggregated beacuse i want to export data for C#aggregated, but FdxExecuteDataUnitTimePivot is exporting data from C#CAD. All our users input data at C#CAD, also default currency on entity is CAD. Just want to know is this the known issue, or FDX designed to export only base currency? Is there any way to pull only C#aggregated with FdxExecuteDataUnitTimePivot.  

Originally posted by Katarina Sterley We have 4 extensions to our main cube and now we have a problem with the standard intercompany matching reports. The end users do not see the transactions on the lowest level from another cube. They only see the IC transactions within their own cube. If they look at the main account they see the transactions but that is not displayed in the standard intercompany matching report within the workflow. Like this from quickview: From Workflow report: Any suggestion on how we should solve this? Kind regards Katarina

Hi Team, can we run or test the business rules or code snippets outside OneStream environment? Do we have any SDK's to setup and test locally?ThanksManju

Hi,  As an admin user I can add and delete rows from a SQL table editor. However a non-admin user does not have access to do so. They can view the data but the add/delete row button on the toolbar are greyed out. Can someone tell me how to give them access to add/delete rows? Thank you Mark

Hello experts,What is the impact of changing assigned entities from one workflow profile to another workflow profile (both being (base input type).Will there be any impact on prior data loads? Are there any other areas we should be careful with this change?Example:Entity A,B and C are assigned to a single workflow profile - WF1 and loaded via WF1.Import. Now, we'd like to divide them further for future loads by creating new smaller workflow profiles such that: WF1 will be stripped of all assigned entities & WF1.Import can be changed to a Central Import type for Entity A, B and C.Entity A is assigned to & loaded by WF2 (new WF created)Entity B is assigned to & loaded by WF3 (new WF created)Entity C is assigned to & loaded by WF4 (new WF created) Thanks,  

Are there any resources for building an external library?  I'm looking to build a dll and getting an ambiguous namespace issue for DbConnInfo.  It appears to be an issue between the OneStream.ClientWindowsBRApi.dll and OneStream.SharedDatabaseTables.dll.  

Hi,Are there any suggestions regarding best practices to store encryption key passphrases and SFTP passwords in OneStream, for usage by integrations ? How should those be stored ? We are using cloud version of OneStream.BR,Avijit

I have a complex expression on the amount field in a data source used to convert any non-local currencies to the local currency (see below). That complex expression currently runs on tabular data with the time period (CurTime) I reference to pull the FX rate in one field. I am now wanting to have this same complex expression used on a Matrix data source with time across 24 fields. Any thoughts on how this could be done? Is there a Column Number api I could use to define CurTime?   'This is to look to see if the entity is a non local USD entity and convert the USD data to Local Dim fields As List(Of String) = StringHelper.Splitstring(args.Line,",") Dim curEntity As String = fields(2) Dim UKEntityDim As OneStream.Shared.Wcf.Dim = BRApi.Finance.Dim.GetDim(si, "iFinDept") Dim UKEntityDimTypeID As Integer = UKEntityDim.DimPk.DimTypeId Dim CurEntityID As Integer = BRApi.Finance.Members.GetMemberId(si,UKEntityDimTypeID , curEntity) Dim CurEntityLocCur As String = BRApi.Finance.

Hello,I'm trying to create a confirmation rule that looks if these two accounts have a difference of 10k USD or more and if so it looks to see if it has a comment (annotation) made by our user and if it doesn't it will fail. So far I got the first part to see if the value is over 10k, but checking it to see if there's a comment also is confusing me. args.ConfirmationRuleArgs.DisplayValue = math.Round(api.Data.GetDataCell("A#Bad_Debt_Comp:U1#Top1:U2#Top2:U3#Top3:U4#Top4:U5#Top5:U6#Top6:U7#USGAAP:F#TopFlow:O#Top:I#Top:C#USD").cellAmount, 2) If System.Math.Abs(args.ConfirmationRuleArgs.DisplayValue) > 10000 Then args.ConfirmationRuleArgs.Info1 = "Bad Debt USD = " & String.Format("{0:#,##0}",math.Round(api.Data.GetDataCell("A#0319:U1#Top1:U2#Top2:U3#Top3:U4#Top4:U5#Top5:U6#Top6:U7#USGAAP:F#TopFlow:O#Top:I#Top:C#USD").cellAmount, 0)) args.ConfirmationRuleArgs.Info2 = "CCM Bad Debt USD = " & String.Format("{0:#,##0}",math.Round(api.Data.GetDataCell("A#CCMBadDebt:U1#Top1:U2