OneStream Community

Afone

Hi, this might sounds like a stupid question to the more experienced people in the community, but how do I refer to the workflow variables from within an extensibility business rule?These 2 lines of code are of course not working:Dim sScenario As Str...

Members range syntax · 05-10-2022

Hi, let's say I have a dimension with Member001 to Member020 being siblings. In a cube view I want to have rows with all members from Member001 to Member012. Using cube view designer, what's the syntax to specify the range, without having lo list all...

Afone · 04-28-2022

Hi,I have setup the Global drivers in the People Planning module to be XFCell formulas, so that users can input drivers by Period/Scenario via cube views. The formulas look like this one:(XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|...

Afone · 04-22-2022

Hi,I'm aware that from the Validate workflow step, the full list of invalid intersections can be exported as in the picture below (right click > Export):The Validation messages are not included in the export.Is there a way to export the full list of ...

Afone · 04-20-2022

Hi,the OneStream XF design and reference guide mentions that: "If an administrator wants the range of source Accounts from 11202 to 11209 to map to Account 12000, then he/she would enter 11202~11209 under Rule Expression with ~ as the separator." Wha...

Afone

Thank you very much! Small correction to what you have written on the Time dimension, this is the working syntax:Dim sScenario As String = ScenarioDimHelper.GetNameFromID(si, si.WorkflowClusterPk.ScenarioKey)Dim sTime As String = BRApi.Finance.Time.G...

Re: Members range syntax · 05-11-2022

Thank you for your reply. It's strange that there isn't a default function to define a range, it seems such a basic functionality. Listing out the members works, but having a range function in most cases makes the solution more robust (no need to mak...

Afone · 05-01-2022

The workaround to the DriverValue column of the Global drivers table having insufficient space for the full XFCell command has been creating an XFBR rule which returns the full XFCell command as a string and to have the XFBR command called in the Glo...

Afone · 04-28-2022

Quick update on this, it seems the issue was that I've simply hit the limit of number of available characters for the DriverValue column of the Global drivers table, so theXFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Period...

Afone · 04-24-2022

Yep, from Dashboards, I had to select Application Reports, then filter on Data Validation and then select the Intersection Errors report. Thank you for your help!

OneStream Community

User Statistics

User Activity

Reference workflow variables from business rule

Members range syntax

XFCell number format issue in People Planning Solution

Export Invalid intersections including validation messages

Transformation rules - Additional examples for the Range type expression

Re: Reference workflow variables from business rule

Re: Members range syntax

Re: XFCell number format issue in People Planning Solution

Re: XFCell number format issue in People Planning Solution

Re: Export Invalid intersections including validation messages