OneStream Platform Forums

I have a csv import coming from excel. One of the columns is of type date but when it gets saved into CSV the date is replaced by integers in the format excel uses to store dates. How can I convert those integers back into dates?

Originally posted by Rahul Joshi I am trying refer a intersection in member formula and apply condition based on the referenced cell.     Dim nvASP As DataCell = api.Data.GetDataCell("A#[ASP (£)]:F#No_Curr:I#None:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None:U6#None:U8#None") If nvASP.CellStatus.CellAmount = 0.0 Then api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#Calculated:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)]") Else api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None::U6#None:U8#None:I#None:A#[ASP (£)]",,,True)     It does not consider the if-else condition and just process the first condition .Something which i am doing wrong in here ?

How can I use the api.LogMessage or BRApi.ErrorLog.LogMessage functions to print out the member names of a list of objects  like member, or memberinfo?

Originally posted by Retha DuPlessis Can you please confirm if there is a report that list all the users?

Originally posted by Michael Malandra 9/23/2019 Is there a way to limit the entities in the confirm rule? i.e I only want one entity in the result 

Originally posted by Andrea Tout7/10/2019 I have an odd data source if someone can help me. The Data Source works that the second to last column has the data, and the last column has a "cr" if it should be negative. So I wrote this complex expression:   Dim secondarCol As String = api.Parser.DelimitedParsedValues(8).Replace("$",String.Empty)Dim primaryCol As String = api.Parser.DelimitedParsedValues(9).Replace(" ",String.Empty)   If primaryCol = "cr" Return secondarCol.XFConvertToDecimal *-1Else Return secondarCol.XFConvertToDecimalEnd If This errors out, and I have tried a lot of different variations. However, if I pick the cr column to the left of the beginning balance (column 3) it works fine. so I figured out that, it only errors when you try to pull anything on the last column. This is because the file is tab delimited, an if there is no cr in the last column, there is not tab before the last column. This basically makes have of the file 10 columns and the other half 9

Originally posted by Michelle Greenberg We are in the process of implementing OneStream and our biggest business is on SAP S4.  We historically had an automated interface from SAP to BPC and would like to do the same with OneStream.  We are looking for other customers that have successfully implemented this that would be willing to share their experience

Originally posted by Krishna SrinivasanDoes anyone connected Oracle Database as external DB ? If so could you please provide the connection string OLEDB or ODBC ? When I try to connect am getting the below error using OLEDB ?

Originally posted by Brad KoteckiIs there a way, or a best practice recommended, to point an XFGetCell formula to one or multiple members of the same dimension without adding parent level members in the dimension hierarchy? As an example, if we have entities 1 through 5, I'd like to be able to change an input cell to any combination of those and have an XFGetCell function to pull in the sum of all the data points referenced. Currently I'm thinking this would require nested If functions, but that seems like it would quickly get to an unmanageable length as the number of members grows.   Thanks Brad