OneStream Community

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

When I have something like this where I can't tell where the rule is failing, I'll put error log messages at each step with something like "Now running xxx" so I can see how far it got before the message appeared. Or if it's a looping rule, I'll add ...

Michel_Sabourin

I read this as coming from an outside source. If internal, then you're absolutely correct Jack

Michel_Sabourin

Not really similar, but I had a use case to parse the current period into a format to be able to convert to a separate date format to run in a SQL query. What I did was create an xfbr business rule and call it from the SQL statement. In this particul...

Michel_Sabourin

I think it's only possible in a dashboard using the method above as you'd need to pair to a combo box or similar to allow for the multi-selection. If you have specific sets you want people to choose from, you could do an XFBR with a delimited list pa...

Michel_Sabourin

I can tell you one thing we do for our clients. We created a whole bunch of UD8 members that pull in all the metadata settings for each type of dimension in individual member formulas. We then make these into Cube Views that can be run at any time to...

OneStream Community

User Statistics

User Activity

(Bypass) no longer showing on Load chevron

SQL Declarations in Data Adapter

Dashboard Label question

Re: Isolate error logging down to a business rule.

Re: How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards

Re: How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards

Re: Multi-Select Parameter

Re: How to set automatic export of metadata with separate files for every dimension?