OneStream Community

SeanV · 06-20-2023

I have a SQL Table Editor on a dashboard, I would like a row to be "pre-selected" from code instead of through a user action (manually clicking on the record).Is this possible?

SeanV · 03-20-2023

Hello, I have a calculated column in a cube view, using CVC referencing another column. This works and is showing the number from the other column. Rows are a dynamic member expansion. I would like for the calculated column to only show a value in ro...

SeanV · 03-09-2023

In Microsoft Excel, the Percentile and Percentile.Inclusive functions use the R-7 Methodology, Percentile.Exc uses the R-6 Methodology for Quantiles. These functions exist in the OneStream Spreadsheet tool, does anyone know if they are the same as Ex...

SeanV · 02-08-2023

I have a dashboard that has 2 components,. 1. A Combo Box that is populated with a sql query in a Bound List Parameter. 2. A Spreadsheet that is populated with a Table View. The table view is generated using a Spreadsheet Business Rule. How do I pass...

SeanV · 01-19-2023

It appears to be possible to set the SiblingID in RelationshipPositionOptions, so it exists as a property. How do I "read" it to see what it is for a member? Thank you in advance for any assistance.

SeanV · 08-30-2023

Instead of trying to set the row indent, use the rule to pad the beginning of the name with the number of spaces you want to indent it.

SeanV · 08-18-2023

I did something similar using a dashboard extender rule to get a file from a file share folder and load it to a custom table. I know you are not trying to load to a custom table. (I used BRApi.Utilities.LoadCustomTableUsingDelimitedFile)However BRApi...

SeanV · 08-08-2023

Performance or length of time of Consolidation?

SeanV · 08-08-2023

Set the Bound column to a column that is a unique identifier for the data record. Then in the business rule use that unique identifier and SQL to lookup the other fields/values that you need for that record.

SeanV · 08-08-2023

There are no justify options available in formatting row or column headers in Cube Views, that I am aware of. It would be nice if you could center as well.

OneStream Community

User Statistics

User Activity

SQL Table Editor - Set selected record from a rule?

Cube View Conditional Calculate Column

SpreadSheet and Percentile Functions

Get selected value from Combo Box and use it in a Table View

SiblingID - How to read this property?

Re: How to make indentation level to specific number using CV extender rule .

Re: Create a Function to read data from excel file in local file system Using BR api

Re: Fact or Fiction? Changing the "Is Consolidated" option on parent Entities will impact

Re: SQL Table Editor column value other than the bound column

Re: Left Justify Description and Right Justify Name in a Cubeview