ContributionsMost RecentMost LikesSolutionsRe: Reporting: Aggregating Amounts by Region in a Flat Entity Hierarchy Have you explored using CVCs. Create Cube View Column and Row Calculations Re: Updating Text1 using business rule Here is a sample of some code I used. Hope it helps. Dim anotherMember As MemberInfo = BRApi.Finance.Members.GetMemberInfo(si, dimtypeid.UD1, UD1Attr1, True) 'Set to Default Scenario and Time (-1=...Re: Copy Annotations across scenario Here is an example I used to copy VarianceExplantions from one scenario to another. I am only copying the text values not files. I also run it from a DM Step using Custom Calculate. #Region "Seed ...Re: Query on annotation data copy Here is an example I used to copy VarianceExplantions from one scenario to another. I am only copying the text values not files. I also run it from a DM Step using Custom Calculate. #Region "Seed ...Re: Extensibility Question Try this as you member selection. A#BalSheet.Base.options(cube=|WFcube|, scenariotype=Budget, MergeMembersFromReferencedCubes=False) You may have to update the cube and scenario type. The scenario...Re: 24 Month PLP Dataset - Import to cube Welcome Re: 24 Month PLP Dataset - Import to cube If you have a scenario where you need to plan across multiple fiscal years, then you need to go to Application Properties and setAllow Loads After Workflow View Yearto "True". Re: 24 Month PLP Dataset - Import to cube We just used the Range setting and accepted the maintenance points. Re: Threshold Operation in FDX using SQL Query I moved the Next and it is now working quick. Re: Threshold Operation in FDX using SQL Query Just to follow up I added this to loop through the table and if there is an invalid account then send an error message. Issue is the evaluation really slows it down. 'Loop through DT and see i...
