MarcusHValued ContributorJoined 4 years ago384 Posts243 LikesLikes received87 SolutionsView All Badges
ContributionsMost RecentMost LikesSolutionsRe: How can I force a delimited data source to not skip blank values in an Amount field? There is the Fixed Debit Credits parser script in GolfStream that might give you a clue: Namespace OneStream.BusinessRule.Parser.XFR_ParseFixedDebitsCredits Public Class MainClass '-------------...Re: Adding comments in cube view in front of calculated row You cannot save text against a Cube View calculated cell because the text is saved with the View member Annotation (or Footnote, AuditComment etc) and that needs a valid datacell POV. Your options ar...Re: Read only option for cube views Have a look at this blog page for an idea. It's not exactly what you are asking for but it might help: https://www.mindstreamanalytics.com/blog/controlling-data-input-cube-view-finance-business-rul...Re: Composite transformation rule with Scenario Looking at this again, the Composite rule works when the Scenario dimension has a Static Value assigned on the Data Source. If the Data Source has 'Current DataKey Scenario'. Re: Event based Scheduling The first step is to decide when you want to trigger the extract of the data. If this should be triggered when a workflow item status changes (ie Lock or Unlock) then you need to look at using the Bu...Re: Exclusion Groups - Uses / Best Practices Exclusion Groups are used for adding or removing users/groups from an existing security group. If you assign a security group to more than one securable role or page, you might need Exclusion Groups....Re: Submitting zero in excel The second parameter on the XFSetCell function is StoreZeroAsNoData. Set that to False and it should save the zero values as zero. Re: Rename folder under Application Database in FileShare As far as I know you cannot rename a folder in File Explorer. You can rename it through a BR using SQL though - the table you need is called folder. Have a look at the MarketPlace solution File Explo...Re: I want to Validate that the Data is cleared and validate the calculate I think the problem is the Origin member for the destination. Change that to Forms. Also I would not specify a specific currency on the Consolidation member unless you are transferring translated val...Re: Best Practice to Clear Stage Data Globally and Cube Data for Selected Entities I found a bit of code called the ATB_ToolboxHelper which has stuff on clearing a scenario. It might be a good starting point. Imports System Imports System.Data Imports System.Data.Common Imports S...