OneStream Community

RandyThompson · 08-28-2024

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 week via a literal value set by a combo-box. Based...

RandyThompson · 06-26-2023

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 they will be importing into the current working scen...

RandyThompson · 05-05-2023

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 currently looks like this:The Spreadsheet Table View rule i...

RandyThompson · 05-04-2023

When we open a Spreadsheet Table View from a Dashboard we would like the Content Pane to be hidden.

RandyThompson · 03-30-2023

I am trying to use a dashboard button to Select All and Unselect All values in a Multiselect Combo-box which I am passing to a Spreadsheet (TableView) business rule. I have tried to run a Data Extender rule from a button that clears the data using th...

RandyThompson · 06-26-2023

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.

RandyThompson · 06-20-2023

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 in the OneStream Spreadsheet tool (left-justified Text...

RandyThompson · 05-05-2023

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.

RandyThompson · 05-05-2023

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.

RandyThompson · 05-04-2023

Thanks Jack, that worked.

OneStream Community

User Statistics

User Activity

Derive PriorPeriod for a weekly calendar

Roll Scenarios for prior 5 periods by renaming scenarios via Business Rule

How can we show commas as the thousand separator in a numeric Table View column

Is there a way to hide the Content Pane when opening a Table View?

Is there a way to Select All, Unselect All a Multiselect Combo-box parameter?

Re: Roll Scenarios for prior 5 periods by renaming scenarios via Business Rule

Re: How can we show commas as the thousand separator in a numeric Table View column

Re: How can we show commas as the thousand separator in a numeric Table View column

Re: How can we show commas as the thousand separator in a numeric Table View column

Re: Is there a way to hide the Content Pane when opening a Table View?