ContributionsMost RecentMost LikesSolutionsRe: Move File from Application Database to External Shared Drive Please start a new thread for this. This thread is three years old and has a solution. Also, your code screenshot is unreadable. Re: How to get two decimal places in Member formula if you are getting 0, then one of the following is true: account 430000 and/or 630000 is 0 or no data for the given POV. Next step is to use either the excel addin, create a cubeview, or write to...Re: Time Sorting order issue in BI Viewer It looks more like the naming and years are off based on your fiscal year that is causing confusion. They look like they are in the same somewhat odd order. Re: How to get two decimal places in Member formula Change the line api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & ") to api.Data.Calculate("A#520000 = A#430000 * " & Var1.ToString(System.Globalization.CultureInfo.InvariantCulture)) Re: Is is possible to share any dashboard component across Workspaces? It seems like this should work. That's the point of "Is Shareable Workspace", to not have to copy things like common components and just reuse the same ones. What version are you on? Re: Help Understanding "relationshipPks As List(Of RelationshipPk)" in Relationship Removal You need the list of parent(s) this member you want to remove the relationships from rolls up to. Construct your list: Dim relationshipPks as New List(of RelationshipPk) 'parse over the parents - ...Re: Composite rule for filled value only This is not a good use case for using a composite rule. Composite rules are best used when a member in one or more other dimensions drives the mapping of the current dimension. Here's how I would ...Re: BI Blend Table - What is the significance of sEntity? Usually this nomenclature refers to source data columns. Re: help with a conditional statement I would include a check for NoData in your if statement: Dim JTDRevenueLoadedDataCell = api.Data.GetDataCell("A#REVENUE_EARNED:U8#None:O#Top:F#EndBal:V#YTD:T#POV") as DataCell Dim JTDRevenueLoadedD...Re: Public Overloads Function GetBusinessRules These are deprecation warnings. There is no easy fix other than to change the code. With Marketplace solutions, the publisher of the solution should create a new release that compiles without these...