Skip to content

ERPConnect.BW.MDXExecuter

Namespace: ERPConnect.BW
Assembly: ERPConnectStandard20.dll

public class MDXExecuter

Inheritance

objectMDXExecuter

Inherited Members

object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Constructors

MDXExecuter(R3Connection)

Constructs a MDXExecuter object

public MDXExecuter(R3Connection Connection)

Parameters

Connection R3Connection

Reference to a valid R3Connection object

Properties

Connection

Reference to a valid R3Connection object

public R3Connection Connection { get; set; }

Property Value

R3Connection

MDX

MDX statement

public string MDX { get; set; }

Property Value

string

MaxRows

Number of rows to maximal retrieved.

public int MaxRows { get; set; }

Property Value

int

PackageSize

Defines if the result is fetched in more than one data packet (set PackageSize to greater 0 to enable packaging)

public int PackageSize { get; set; }

Property Value

int

Result

Contains the resultset of the MDX execution

public DataTable Result { get; }

Property Value

DataTable

UnitsInResultset

Gets or sets a value indicating whether the units of a measure are output into a separated column in the resultset

public bool UnitsInResultset { get; set; }

Property Value

bool

UseFlattening

For internal use only! Do not use!!!!!

public bool UseFlattening { get; set; }

Property Value

bool

UseFormattedValue

Defines whether the formatted value or the technical should be used (this can defined in BEX analyzer)

public bool UseFormattedValue { get; set; }

Property Value

bool

UseMemberUniqueNamesInsteadOfCaption

For internal use only! Do not use!!!!!

public bool UseMemberUniqueNamesInsteadOfCaption { get; set; }

Property Value

bool

UseNewOlapBapis

Gets or sets a value indicating whether the new OLAP BAPIs should be used for the extraction (see SAP note 1232751)

public bool UseNewOlapBapis { get; set; }

Property Value

bool

Methods

Execute()

Executes the current MDX statement and fills the Result table

public void Execute()

DebuggingDetails

public event MDXExecuter.OnDebuggingDetails DebuggingDetails

Event Type

MDXExecuter.OnDebuggingDetails

IncomingPackage

IncomingPackage is fired, when addtional data packages are fetched from SAP.

public event MDXExecuter.OnIncomingPackage IncomingPackage

Event Type

MDXExecuter.OnIncomingPackage