ContributionsMost RecentMost LikesSolutionsRe: An Error Has Occured BadGateway - Books Hi ShivaPrasad I think this might be a bug on v9. I would recommend reaching out to Support to help you resolve. If you are not on version 9, then it could be something wrong with the target f...Re: Any way to zoom a Gantt View Component? Hi SteveK I don't think this is possible. You can only interact with the properties of a component that you can see on that component type. Maybe one for ideastream? Cheers Sam Re: Complex expression to remove currency symbols? Hi m_b_b_15 Excel formulas won't work in a complex expression. However you can use string manipulation to extract what you need. Here is a simple example using substring that can get you started ...Re: Removing Duplicates from a Member Filter Hi Kenn If you are working with a Member List you can use something like this Linq syntax (see vb example below). ** This assumes that we are using object Member in our list and therefore we can...Re: Losing Dynamic Parameters on Dashboard Refresh Hi BenEppel Were you able to resolve your issue? One of the best ways to approach dynamic dashboards is to use the RepeatArgsList to do the heavy lifting. This can significantly reduce the amo...Re: More Filters in FdxExecuteDataUnit Probably Data Management Export is your path of least resistance. But the amount of overhead created by passing in Parent and Base members in a filter for the same dimension will definitely increase...Re: Can we make consolidation process faster? Hi HoneyGulati If you are already using C#Aggregated then you are already only aggregating the data e.g skipping consolidation overhead So for any further gains, it might be worth investigating...Re: More Filters in FdxExecuteDataUnit You can achieve your use case with the FDX Extended solution I mentioned earlier on this post, this will Group (aggregate) this data for you for a given Dimension e.g. A#. However since you want...Re: More Filters in FdxExecuteDataUnit Does your DataTable return any rows when you pass in an empty string as a filter e.g. dt = BRApi.Import.Data.FdxExecuteDataUnit( si, "Total_Magna", ' Cube name "E#Par...Re: More Filters in FdxExecuteDataUnit Also please take care with the ParallelQueryCount variable. You have set yours to be 100,000! This cannot exceed 128. I would recommend setting this at a safe level of something like 8 Similarl...