OneStream Community

Cosimo · 02-22-2022

Has anyone found a use for the brapi function CreateSessionInfoForAnotherApp? If yes, can you please explain it as I cannot seem to find any documentation on this function. This is the example I'm seeing in BR:Dim si As SessionInfo = BRApi.Security.A...

Cosimo · 01-10-2022

SOURCE: ONESTREAM CHAMPIONSHi gang,Does anyone out here use Choropleth maps in BI Viewer and was able to figure out how to create new Shapefiles? Bi Viewer includes a bunch of default maps (8 in all - World, Europe, Asia, NA, SA, USA, Canada, Africa)...

Cosimo · 01-10-2022

SOURCE: ONESTREAM CHAMPIONSChampions,Is there a way to have a Studio report recalculate a value at a group summary level instead of having the report sum up values from the detailed band?In example below, the ROI% as the 401 Total line is displaying ...

Cosimo · 01-10-2022

SOURCE: CHAMPIONSDoes anyone know if we can call the Refresh Workbook function using VBA? I’m looking to introduce a button on worksheets that performs the Refresh Workbook option that’s located on the OneStream XF ribbon.

Cosimo

If you're looking to download the original TB file as imported into a workflow-scenario-period, use ExportStageArchives function. Below is an example within an extender rule. The file is stored under File Share \ Data Management folder. You can speci...

Cosimo

Is the workflow entity set in the cube view's POV? You can use E#Root.WFProfileEntities as a member filter to fetch entities that are assigned to a workflow though you need to have the Entity dimension setup as a cube view row or column. Option 2 wou...

Cosimo

Technically speaking, renaming a member doesn't move data from old member to new. All data records will use Member IDs to reference cell intersections. As you rename a member, you're only updating the member name to an existing member ID. Renaming a ...

Cosimo · 05-18-2022

I don't think you can display a blank value for a SQL date field as 1/1/1900 represents null. My workaround was to convert a date field to string and store dates as strings. If the field value is null then the table editor displays it as blank.The on...

Cosimo · 05-12-2022

I'm really hoping that the dev team considers adding pass/fail checks to Data Management sequences in the future. I use an Extender rule to perform step processing and check the return status of executed steps.

OneStream Community

User Statistics

User Activity

Use case for function CreateSessionInfoForAnotherApp

BI Viewer - Choropleth Map Editing

Studio Report - calculating % at Group band level

Excel VBA automation - Refresh Workbook function

Re: Is there anyway to download TB/Reclass files automatically using Business Rules?

Re: Cube View to automatically select Workflow entities

Re: Moving data from one member to another.

Re: Sql Editor Component Date type NULL

Re: Can I stop a Data Management if a Step Fails ??