Workflow and Data Integration

I have a question regarding Journal Templates. We have a template that was setup with the frequency "All Time Periods." Does that mean this journal will post every month?  I think the setting should have been "Monthly." If I change that setting in the Journal Template, how does it impact historical data? Will it unpost prior close periods? Or will it keep the prior periods as is, but will stop the journal from posting in future periods? 

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