ERPConnect.BW.BWCube

Namespace: ERPConnect.BW
Assembly: ERPConnectStandard20.dll

BWCube represents a BW Cube to extract data from

public class BWCube

Inheritance

object ← BWCube

Inherited Members

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

Constructors

BWCube(R3Connection)

Constructs a BWCube object

public BWCube(R3Connection connection)

Parameters

connection R3Connection

Reference to a valid R3Connection object

Properties

AdjustFlatOutputColumnsOrdinal

DO NOT USE!!! FOR INTERNAL USE ONLY!!!!

public bool AdjustFlatOutputColumnsOrdinal { get; set; }

Property Value

bool

Connection

Reference to a valid R3Connection object

public R3Connection Connection { get; set; }

Property Value

R3Connection

Dimensions

This collection repesents all dimensions of the BW Cube / BW Query

public DimensionCollection Dimensions { get; set; }

Property Value

DimensionCollection

Measures

This collection repesents all measures of the BW Cube / BW Query

public DimensionCollection Measures { get; set; }

Property Value

DimensionCollection

Name

Name of the cube

public string Name { get; set; }

Property Value

string

PackageSize

Determines if the data should be retreived in packages and if so, how many rows should be in one package

public int PackageSize { get; set; }

Property Value

int

UseFormattedValue

Determines if the data should be formatted as defined in the query designer (e.g. number of decimals or factor)

public bool UseFormattedValue { 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

Variables

This collection repesents all variables of the BW Query

public BWVariableCollection Variables { get; set; }

Property Value

BWVariableCollection

Methods

CreateCube(string)

Constructs a BWCube object with all its dimensions, properties and measures

public void CreateCube(string cubeName)

Parameters

cubeName string

Name of the Cube or Query Cube (e.g. 0D_DECU or 0D_DECU/VARDEMO01)

Execute()

Executes the cube / query extraction

public DataTable Execute()

Returns

DataTable

DataTable object with flat result

GetFlatMDX()

Returns a MDX string that represents the query for the cube's data

public string GetFlatMDX()

Returns

string

A MDX string

LoadFromXML(string)

Load a BWCube object hierachy from an XML file

public void LoadFromXML(string FileName)

Parameters

FileName string

Filename

LoadFromXML(StreamReader)

Load a BWCube object hierachy from an XML file

public void LoadFromXML(StreamReader reader)

Parameters

reader StreamReader

StreamReader to XML resource

LoadFromXMLString(string)

Load a BWCube object hierachy from an XML string

public void LoadFromXMLString(string XMLString)

Parameters

XMLString string

XML string

RefreshMetaData()

public void RefreshMetaData()

RefreshMetaData(bool)

For internal use only

public void RefreshMetaData(bool onlyStructures)

Parameters

onlyStructures bool

SaveToXML(string)

Saves the current object to XML

public void SaveToXML(string Filename)

Parameters

Filename string

File name

SaveToXML()

Saves the current object to XML

public string SaveToXML()

Returns

string

A string which contains the XML file

SelectAllForFlatMDX()

Do not use! For internal use only

public void SelectAllForFlatMDX()

SetBWDateFlags()

For internal use only

public void SetBWDateFlags()

ToString()

Returns an object description text

public override string ToString()

Returns

string

Object description text

IncomingPackage

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

public event BWCube.OnIncomingPackage IncomingPackage

Event Type

BWCube.OnIncomingPackage