ContributionsMost RecentMost LikesSolutionsRe: Business Rule | One-to-One Transformation - E# Parent to its first E# Base I believe something like this should work within a complex expression on a transformation rule (did not test). The dimension name logic may need some tinkering and I am not sure about the order of th...Re: Automate Excel workbook refresh I have done this using VBA. Below is an example, the design and reference guide has the available subroutines like RefreshCubeViewsForActiveWorkSheet or RefreshCubeViews. If you cant pull everything...Re: Text field of Entity dimension in cube view If your using text2 then you would need to change it. It is, you will just need logic to clean the string. Something like this should work. Dim textVal As String = api.Entity.Text(EntityID, 1, Fals...Re: Text field of Entity dimension in cube view Hi Irina, If you would like to create a stored calculation, you could create a new account member called Taxable_Income, and within the formula create a calculation like below: The Account's Formul...Re: Text field of Entity dimension in cube view XFMemberProperty(DimType=Entity, Member=YourEntityMemberName, Property=Text1, VaryByScenarioType=[], VaryByTime=[]) Re: Use 2 fields to determine dimension value in datasource Since this is a connector data source, I don't think api.Parser.DelimitedParsedValues() will work. I've used logic like this for complex expressions in connector sources. Below is index based, so fie...Re: WfTime parameter not working in SQL table editor Does having = '|WFText4|' and Period = '|WFTime|' work? If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where claus...Re: Reset/Clear the loaded data (O#Import) via BR You can clear the loaded data by creating a data management step Re: Add month T#|PovYearPrior||PovSubPeriod| The above member filter is using substitution variables, which can be found here in the member filter builder. Re: Add month What is the current member filter for the prior year columns?
