OneStream Community

JackLacava · 07-19-2024

It has been a quiet Tuesday morning at Badabing Ltd. Had some decent coffee, checked all reports went out last night, and basked in the glory of a sea of green "OK" calculation statuses. As you ponder whether to dig into your third cannoli of the day...

JackLacava · 04-29-2024

From May 1st, my role in OneStream will change significantly (for the better!); unfortunately, this means I will step down as Community Moderator. Over the last 20 months or so it's been a lot of fun, interacting with all of you on forums while tryin...

JackLacava · 03-01-2024

In Part 1 of this short miniseries , we have seen how we can pass values from traditional Dashboard Parameters into Bi Viewer. But what about going the other way around, i.e. getting values from Bi Viewer into Parameters? In practice this is even eas...

JackLacava · 02-13-2024

In part 1 and part 2 of this series, we have seen how to handle VB.Net variables, call existing functions, and manipulate basic data-structures. This is enough to write simple scripts or member formulas; but if we do that, we'll likely find ourselves...

JackLacava · 01-10-2024

A common requirement for reporting is to be able to filter the IC dimension by some property that exists only on the original Entity members. This can be achieved with a custom Member List defined in a Finance business Rule. Select Case api.FunctionT...

JackLacava

If you've tested with a Cube View using the same syntax, and it returns the right filter there, you will have to talk to Support, as it might be a release-specific bug.

JackLacava

Works for me on version 8.4. Make sure your function returns a string starting with T# (because it's a Filter). Maybe test it on a dummy cubeview first, to verify it actually returns what you expect (the Workspace might have to be set to Shareable fo...

JackLacava

The real issue here is that your UD8 is returning a string and you think it should be a number. If it's supposed to be a number it should return a number. You can't subtract strings.

JackLacava

Unfortunately this is not currently possible, as far as I can see, with simple traditional Business Rules. You cannot detect the selected tab and you cannot invoke rules when an embedded dashboard is displayed. It might be doable with Dynamic Dashboa...

JackLacava

I would add that, with the new tab-docking feature in 8.4, you can now have multiple editor windows (and hence multiple helper trees) open at the same time. As for everything, there are future plans for improvement in the area of documentation, parti...

OneStream Community

User Statistics

User Activity

"Top N" reports - no code required!

Goodbye, and thanks for all the fish 🙂

BiViewer Parameters Demystified - pt 2

So You Want to Learn VB.NET - pt.3

Filter IC Dimension by Entity Property

Re: Getting an error when calling an assemblies from DM step

Re: Getting an error when calling an assemblies from DM step

Re: Is it possible to return a string with CubeView GetDataCell Function

Re: Retrieve the name of the dashboard tab that I am looking at

Re: documentation: file having all functions syntax/ library/ libraries