Skip to main content
July 29, 2025
Solved

Is it possible to retrieve values of additional options from the data management export step?

  • July 29, 2025
  • 3 replies
  • 0 views

Hi OneStream Experts, 

Is it possible to extract the value of "options" from the data management export data step using a extensibility rule?







I used a syntax above to retrieve it. but, unfortunately no luck. 

Any help or suggestions are much appreciated.
Thank you. 

Best answer by RobbSalzmann

(being picky :) ) if your going to use interpolated string, then put the values in brackets:
BRApi.ErrorLog.LogMessage(si, $"IncludeZeros Value: {paramIZ}")

Alternatively you can log everything in the ExportDataDefinition object like this:

dim serializedExportDataDefinition as string = Newtonsoft.Json.JsonConvert.SerializeObject(args.DataMgmtArgs.CurrentStep.ExportDataDefinition, Formatting.Indented)
BRApi.ErrorLog.LogMessage(si, serializedExportDataDefinition)

' or access the DataFilters property directly:
Dim exportDataDefinitionDataFilters as List(Of string) = args.DataMgmtArgs.CurrentStep.ExportDataDefinition.DataFilters
Dim serializedExportDataDefinitionDataFilters as string = Newtonsoft.Json.JsonConvert.SerializeObject(exportDataDefinitionDataFilters, Formatting.Indented)
BRApi.ErrorLog.LogMessage(si, serializedExportDataDefinitionDataFilters)

These are all the properties available on args.DataMgmtArgs.CurrentStep.ExportDataDefinition:

UseDetailedLogging
FileShareFileName
IncludeCubeInFileName
IncludeEntityInFileName
IncludeParentInFileName
IncludeConsInFileName
IncludeScenarioInFileName
IncludeTimeInFileName
OverwriteExistingFiles
IncludeZeros
IncludeMemberDescriptions
IncludeCellAnnotations
IncludeInputData
IncludeCalculatedData
Cube
EntityFilter
ParentFilter
ConsFilter
ScenarioFilter
TimeFilter
ViewFilter
AccountFilter
FlowFilter
OriginFilter
ICFilter
UD1Filter
UD2Filter
UD3Filter
UD4Filter
UD5Filter
UD6Filter
UD7Filter
UD8FilterDataFilters

3 replies

July 29, 2025

What are you trying to achieve with this?

 

August 1, 2025

Creating a dashboard for end users to extract data by themselves without giving access to Application tab. Thought of giving these additional options in the dashboard for their reference.

July 29, 2025

(being picky :) ) if your going to use interpolated string, then put the values in brackets:
BRApi.ErrorLog.LogMessage(si, $"IncludeZeros Value: {paramIZ}")

Alternatively you can log everything in the ExportDataDefinition object like this:

dim serializedExportDataDefinition as string = Newtonsoft.Json.JsonConvert.SerializeObject(args.DataMgmtArgs.CurrentStep.ExportDataDefinition, Formatting.Indented)
BRApi.ErrorLog.LogMessage(si, serializedExportDataDefinition)

' or access the DataFilters property directly:
Dim exportDataDefinitionDataFilters as List(Of string) = args.DataMgmtArgs.CurrentStep.ExportDataDefinition.DataFilters
Dim serializedExportDataDefinitionDataFilters as string = Newtonsoft.Json.JsonConvert.SerializeObject(exportDataDefinitionDataFilters, Formatting.Indented)
BRApi.ErrorLog.LogMessage(si, serializedExportDataDefinitionDataFilters)

These are all the properties available on args.DataMgmtArgs.CurrentStep.ExportDataDefinition:

UseDetailedLogging
FileShareFileName
IncludeCubeInFileName
IncludeEntityInFileName
IncludeParentInFileName
IncludeConsInFileName
IncludeScenarioInFileName
IncludeTimeInFileName
OverwriteExistingFiles
IncludeZeros
IncludeMemberDescriptions
IncludeCellAnnotations
IncludeInputData
IncludeCalculatedData
Cube
EntityFilter
ParentFilter
ConsFilter
ScenarioFilter
TimeFilter
ViewFilter
AccountFilter
FlowFilter
OriginFilter
ICFilter
UD1Filter
UD2Filter
UD3Filter
UD4Filter
UD5Filter
UD6Filter
UD7Filter
UD8FilterDataFilters

August 1, 2025

Thanks a lot Robb

August 2, 2025

Hi,

Good Day !

 

This utility sounds very interesting. I had a similar idea in mind as well. Could you please share your final dashboard with me? I'm currently working on incorporating user details and timestamps along with the data.

Can you please help me with the information is this something already there with OneStream in anyone of the OneStream marketplace solution ? 

Thanks in advance!