ContributionsMost RecentMost LikesSolutionsUse api.Data.Calculate to move data between 2 cubes Is it possible to copy a value from one cube to another mutually exclusive cube with a Custom Calculate business rule? I am trying to copy a value from the Cb#Financial cube to the Cb#CASH cube. How...SolvedDerive PriorPeriod for a weekly calendar My application has a weekly time dimension? I am trying to find a function that will derive prior weeks so I can calculate the Trailing8WeekAvg and Trailing26WeekAvg. I am able to get the last actual...Re: Roll Scenarios for prior 5 periods by renaming scenarios via Business Rule Hi Robb, Yes this was my backup plan. I was just hoping that renaming scenarios, if that was possible, would perform faster and use less resources than copying data 5 times. Thanks. Roll Scenarios for prior 5 periods by renaming scenarios via Business Rule Has anyone tried to rename scenarios using a business rule to have a rolling set of prior forecasts. In this case the client is to trying to have weekly scenarios for the prior 5 weeks. Once a week t...Re: How can we show commas as the thousand separator in a numeric Table View column I have submitted this enhancement on IdeaStream. Currently when opening the same Table View we can get the formatting we want in a native Excel Table View (right-justified currency fields) but not i...Reading the BiBlend view in a Spreadsheet (TableView) business rule In a Spreadsheet (TableView) business rule, I am trying to reference the view created during the load of a BiBlend Star Schema. In our case when I create the BiBlend Star Schema tables, I also see th...SolvedIs there a way to hide the Content Pane when opening a Table View? When we open a Spreadsheet Table View from a Dashboard we would like the Content Pane to be hidden. SolvedRe: How can we show commas as the thousand separator in a numeric Table View column Thanks, Celvin. Unfortunately I can't find any documentation on this. Can you share a snippet of code of how to use the populate from data table. Thanks. Re: How can we show commas as the thousand separator in a numeric Table View column I tried that and it didn't work. Table View seems to be ignoring the SQL formatting and applying their formatting based on the table view column definition. How can we show commas as the thousand separator in a numeric Table View column We are trying to format numeric columns in a Table View but haven't been successful. The numeric columns are currently appearing as 999999.99 instead of the desired 99,999.99. Are Table View currentl...
