ContributionsMost RecentMost LikesSolutionsRe: Calculation Definitions Filter -Data Quality Event Handler I would just check the WF start time and just run it for that year only. But there could be other ways to do this depending on your setup. Imports System Imports System.Data Imports System.Data.Com...Re: Calculation Definitions Filter -Data Quality Event Handler In my experience with this, the process step will trigger by workflow time so having multiple years/data units within the workflow unit can cause this. E.g. do you have a WF range that spans 2 years?...Re: Use a BR to Generate a SQL Statement within a Data Adapter You are going to need to create a Dashboard Data Set business rule and reference that in the data adapter. A dashboard det set rule allows you to dynamically generate a SQL string using whatever logi...Re: Using Percent Ownership in a member formula Ownership percentages are relationship (parent/child) specific. Your formula currently only runs on base and local, which is not relationship specific. You will need to pass a specific parent in for ...Re: Cube Limit If it helps, I have a client with this design/similar issue with sparsity and around 75k members in UD1 with no performance issues on drill downs in excel/app. The key is to make sure you have suppre...Re: Cube Limit In addition to other responses, I would consider a simple 2 cube approach (TopEntity cube and BaseEntity cube). In the TopEntity cube, you have a can have a summary UD1 dimension that stops at TotalC...Re: Limit excel upload after workflow closed It sounds like you are missing entity assignments. Make sure you are assigning the entities to the workflows you are locking if you want to prevent data changes after a workflow gets locked. If you n...Re: Data Managment Sequence Name Assuming this is an extender rule, you will want to use the following: Dim sequenceName As String = args.DataMgmtArgs.Sequence.Name Re: Logging message to error log for first iteration of the business rule I believe since this is setup in a DM sequence doing TopEntity.Base, bk0615, will also need to set the variable in to the globals object so other entities can refence the value. Re: Logging message to error log for first iteration of the business rule I think you are going to want to use the Globals object. With this, you should create a counter variable and set that variable into globals for each entity to refer to and increment.
