OneStream Community

jordielane · 06-21-2023

I'm trying to do a dynamic calc to determine lesser value of an account or 500,000. I have very little experience with vb.net so this was as far as I got but it doesn't work.If api.Data.GetDataCell("A#RPT_Cash") > "500000" Then Return "500000"Else If...

jordielane · 05-23-2023

Is there a way to make parameters have multiple selections in cube views?

jordielane · 03-29-2023

Does anyone know how to format the object lookup cell in the cubeview? We currently have formatting on the cube view as follows. If(IsRowNumberEven = True) Then BackgroundColor = #FFFFFFFF, *white* ExcelBackgroundColor = #FFFFFFFF, Else BackgroundCol...

jordielane · 06-22-2023

This worked, thank you!

jordielane · 06-21-2023

Thank you for the tips. I'm not sure if its relevant but this calculation is being stored as an account member. I need it to return the lesser of the A#Rpt_Cash value or 500,000. What should the return values be after the if statement? I tried modify...

jordielane · 05-23-2023

Yes, let's say I have a member list or member dialog parameter for entity selection, but I want to see the results for 3 entities together instead of just being able to select one. I would prefer it be in a parameter so it can be used in a cube view.

jordielane · 05-23-2023

I've seen this method before, but was wondering if there was a way outside of the combo box, just within a parameter itself.

jordielane · 03-30-2023

That worked, thank you so much!

OneStream Community

User Statistics

User Activity

Dynamic Calc - return lesser value

Multi-Select Parameter

Cube View Formatting

Re: Dynamic Calc - return lesser value

Re: Dynamic Calc - return lesser value

Re: Multi-Select Parameter

Re: Multi-Select Parameter

Re: Cube View Formatting