ContributionsMost RecentMost LikesSolutionsRe: Help with Table Views There is a syntax error in the SQL statement. Line 56. The final column statement in the SELECT clause has a comma just before the FROM key word. This works for me Imports System Imports System.Col...Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds The code is looking for the comment in the Prior period - is that correct? Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds Post the code you have now. Please use the Insert Code method - click on {;} at the bottom of the dialogue. Re: Help Needed with Confirmation Rule to Validate Annotations for Thresholds I think the problem is where you are getting the DataCellAnnotation (line 78?). The result of that called is used as a POV for the HasDataAttachment function. If you change line 78 so that the variab...Re: possible to post directly to "translated" without being overwritten? (for USD journal in EUR entity) You can input in a different currency via Forms. Search this group for 'Alternate Input Currency'. Re: No valid DataKeys (Scenario / Time) found in data source. The Data Structure Type on the Data Source is set to Matrix Data. As you are loading one period of data this should be set to Tabular Data. The log file has the line: Matrix Lines Read..... 0 Re: The Writer is closed or in error state I haven't seen this before but I would guess that it might be related to the application you have assigned for managing TRX files. In Windows Explorer create an empty file with the extension TRX (eg ...Re: No valid DataKeys (Scenario / Time) found in data source. The error is saying that there is a missing scenario and/or time target member. That means either the data source is wrong (and it looks OK to me) or the transformation rules for the scenario / time ...Re: Parcel Service Fileshare Folder Path This might give you a starting point: https://community.onestreamsoftware.com/discussions/Rules/move-file-from-application-database-to-external-shared-drive/19062 Re: OneStream Administrator Native User We do not use the native user Administrator precisely because of the audit problems (it can be turned off in the Application Server Config file). Instead we assign users who need such access to the A...