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 · 10-04-2023

Got it, it was a path issue.  Thank you

SeanV · 10-04-2023

So I get an errorcould not find library C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.0\WindowsBase.dllThis is an on prem 7.2.2 environment. Any ideas?

SeanV · 10-03-2023

How do you get these imports to work?Imports DocumentFormat.OpenXmlImports DocumentFormat.OpenXml.PackagingImports DocumentFormat.OpenXml.SpreadsheetIs there a DLL or something that needs to be installed?

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...

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: Create Excel spreadsheet from Business Rules

Re: Create Excel spreadsheet from Business Rules

Re: Create Excel spreadsheet from Business Rules

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