While building a Dashboard, you might have the need to provide a widget
for the user to select a bunch of members at the same time. This can be
achieved in a number of ways. If your requirements are straightforward
and you don't care too much about p...
This post is an introduction to Tree Views in OneStream Dashboards, a
type of widget that can render hierarchical data. Their complexity can
vary, as you will see below, but once mastered they will be a powerful
weapon in your reporting arsenal. Let’...
Hi. Just to return to this topic. I've added some small modifications to
the query logic after changing use case. The main changes are that we
have added a column called Path that helps drive the sibling sort order
(this can get skewed on big dimensi...
Hi. I have been testing this. You can't use a data source / parser rule
here because the column you are trying to fix is already in the next
line. However, you can solve for this with a Connector BR and using the
TextFieldParser class of the Microsof...
A good way to derive a time period based on a time variable is to use
the TimeDimHelper class. You can nest functions like below; to achieve
most use cases. ' Declare timePeriod Dim timePeriod As String = "2024M1"
' Derive prior quarter based on time...
Hi. As @JackLacava said we don't know your setup. So a lot of variables
at play here. However from a theoretical point of view you can pass the
resukt of that parameter into a list e.g
E#Root.List([|!parameterValue!|]) and then pass that into your CV...