OneStream Community

Michel_Sabourin

Trying to align the text in a button to the left. HorizontalAlignment = Left does nothing. I've also tried HorizontalContentAlignment under Image. It centers the interior text no matter what I do. Anyone have any thoughts? Is this possible at all? Ki...

Michel_Sabourin · 10-13-2022

Hello all, My client recently upgraded to the most recent version of OneStream. Previously when loading data, the first line on the Load tab would show the total of bypassed records. We've noticed since the update, this no longer shows. Is it possibl...

Michel_Sabourin · 11-24-2021

Source: Migrated from Champions Hello all, I’m creating a Data Adapter that is using SQL to poll an external database. I can get it to work when I’m just supplying the strings for dates. However, I wanted to get fancy and be able to parse the effecti...

Michel_Sabourin · 11-23-2021

Source: Migrated from Champions Does anyone know if it’s possible to use a hard enter (ctrl + enter or vbcrlf in vba code) in a label?

Michel_Sabourin

I think the issue is that OneStream doesn't like certain values in the journal names. I would try removing the "." from the name first. maybe change it to "2_0". If it's not that, try replacing the "-".

Re: Member formula - Account Type · 01-18-2024

This is what I use as part of a process I do to create a "traditional" trial balance for a few clients. This works for me. Dim povAcct As Integer = api.Pov.Account.MemberId Dim povAcctType As AccountType = api.Account.GetAccountType(povAcct) If povAc...

Michel_Sabourin · 11-15-2023

You should be able to just use the parameter you're using to select the row sets. in the caption field, put:Investment Report |![Name of parameter]!|

Michel_Sabourin · 08-24-2023

You could adjust it to look at the time. I have not tested the below, Are you using Global Time? If so, you could add...Dim povTime as String = api.Pov.Time.MemberIddim GlobalTime as String = BRApi.Workflow.General.GetGlobalTime(si)'Convert Times to ...

Michel_Sabourin · 08-03-2023

In addition to Robb's comment, you could also use the extender rule to set the value to a literal value parameter that can be read by the new dashboard

OneStream Community

User Statistics

User Activity

Left alignment in Dashboard button (no label)

(Bypass) no longer showing on Load chevron

SQL Declarations in Data Adapter

Dashboard Label question

Re: Security Access Error. Unable to create journal.

Re: Member formula - Account Type

Re: Parameter for page caption using row set

Re: UD8 Dynamic rule to hide derived values. Does anyone have an example of this UD8 calc?

Re: Combo Boxes Passing Selections to Other Dashboards