OneStream Community

LeAnnTDang · 09-16-2022

For Entity transformation rule, we want to build logic so that Source entity looks at its parent entity in one of our entity hierarchy in OS dimension, read and then map to the parent entity text8 assignment, then map to that entity the text8 assignm...

LeAnnTDang · 09-16-2022

Hello,I am attempting to build a simple line chart through BI Viewer with Cashflow amounts in Y axis and Time (month-year) in X axis. I cannot get it to sort properly so it display data to flow through time. In the X axis, I choose Time for Arguments...

LeAnnTDang · 09-20-2022

Thanks Mark. I modified the rule a bit and was able to use it. Thank you very much for the sample script. Dim SourceEntity As String = Args.GetSource("E#")Dim TargetEntity As String = ""If SourceEntity.Length = 9 ThenTargetEntity = "HC" & SourceEntit...

LeAnnTDang · 09-16-2022

Thank you Michael. That did it!

LeAnnTDang · 08-05-2022

Thank you Aric. I ended up setting up an XFBR like as suggested in this chain and use a literal parameter to set up the XFBRS#XFBR(BusinessRuleName, FunctionName, NameValuePair=|POVScenario|), so the main POVscenario would be the driver for prior for...

LeAnnTDang · 08-05-2022

Our users would like to manage the selection in Prior Fcst Scenario by themselves, because they could be selecting prior month, prior quarter, etc... They have multiple quick views on a spreadsheet and would like one scenario selection to apply to al...

LeAnnTDang · 08-04-2022

Our consultant showed me to use Text attribute for scenario to get prior forecast. So in Jan_FCST, if you assign Text1 attribute as Feb_FCST, then in your OP filter, you can retrieve S#Fcsts.base.Where(Text1 = |!param_FCST!|). This setup allow when u...

OneStream Community

User Statistics

User Activity

How to setup transformation rule to look at parent text value in entity dimension?

BI Viewer - Line chart Order by Time dimension

Re: How to setup transformation rule to look at parent text value in entity dimension?

Re: BI Viewer - Line chart Order by Time dimension

Re: Cube View Parametric driven column

Re: Cube View Parametric driven column

Re: Cube View Parametric driven column