ContributionsMost RecentMost LikesSolutionsRe: Getting an error when calling an assemblies from DM step Could it be as simple as misspelling "Workspace" at the beginning of your XFBR? Error processing Data Management Step 'Allocations_AllAccountBkt_Step'. Invalid parameter. Time Filter, #ERROR: XFBR...Re: Lock one year in two years Forecast Take a look at the "Number of No Input Periods Per Workflow Unit" setting on the scenario you want to lock inputs from. If you want to restrict the full year, enter 12 in that field. Re: How to find Entity's Currency in Application Database Tables Thanks - here's how I ultimately wrote the code. Added dummy column in my SQL query. sql.AppendLine(", CAST('' as VARCHAR) as [Ent Curr] ") Then was able to return the currency here. ...Re: How to find Entity's Currency in Application Database Tables I'm writing this within a Spreadsheet Business Rule, so I can't steal your code exactly as it's written. Basically, I have a SQL query returning data from the XFW_PLP_Plan table. I've also added a ...Re: How to find Entity's Currency in Application Database Tables Thanks, this was the path I was going down, but hadn't run across that parameter you mentioned. Looking at the PropertyID field in the MemberProperty table, I'm noticing that only foreign (in my c...How to find Entity's Currency in Application Database Tables I'm working on a custom Table View that returns People Planning Plan Data for our users. The new requirement is to also bring in the Currency of the data. This means I need to bring in the Currency ...SolvedRe: Registration now open for the June edition of Tech Talks! Will this be recorded and available for rewatch later? I unfortunately have a conflict at this time. Re: NonFinancial Account Try using the account type Flow instead. Re: Cube View Excel Cell Formatting Try usingExcelNumberFormat = [#,##0.0000]. If you go into Cell Format --> ExcelNumberFormat --> ... You'll find some default number formats. Just select #,##0.00, then add additional zeros to t...Re: Dimension Drop Down List in Excel for GetXF Retrieves I know of one way which involves a combination of OneStream and Excel logic. You can create Member Lists based on the dimensions you want lists for in the UD8 dimension as DynamicCalc members. I b...
