RadarSoft.RadarCube.Web.MSAS Send comments on this topic.
AddCalculatedHierarchy(String,DataTable,Type,String,String,String) Method
See Also 
RadarSoft.RadarCube.Web Namespace > TOLAPCube Class > AddCalculatedHierarchy Method : AddCalculatedHierarchy(String,DataTable,Type,String,String,String) Method




DimensionName
Defines the name of the dimension to put the new hierarchy into.
OriginalTable
Defines the table in the data schema the calculated field must be located in.
DataType
Defines the type of data in the new calculated field.
DisplayName
Defines the name of the new hierarchy. The calculated field is given the same name.
SourceColumnName
Defines the source column for the calculated field. See AddCalculatedColumn for details.
SourceColumnFormat
The format mask to apply to the source column value. See AddCalculatedColumn for details.
Adds a new hierarchy based on a calculated field to a cube.

Syntax

Visual Basic (Declaration) 
Public Overloads Function AddCalculatedHierarchy( _
   ByVal DimensionName As String, _
   ByVal OriginalTable As DataTable, _
   ByVal DataType As Type, _
   ByVal DisplayName As String, _
   ByVal SourceColumnName As String, _
   ByVal SourceColumnFormat As String _
) As TCubeHierarchy
Visual Basic (Usage)Copy Code
Dim instance As TOLAPCube
Dim DimensionName As String
Dim OriginalTable As DataTable
Dim DataType As Type
Dim DisplayName As String
Dim SourceColumnName As String
Dim SourceColumnFormat As String
Dim value As TCubeHierarchy
 
value = instance.AddCalculatedHierarchy(DimensionName, OriginalTable, DataType, DisplayName, SourceColumnName, SourceColumnFormat)
C# 
public TCubeHierarchy AddCalculatedHierarchy( 
   string DimensionName,
   DataTable OriginalTable,
   Type DataType,
   string DisplayName,
   string SourceColumnName,
   string SourceColumnFormat
)
Managed Extensions for C++ 
public: TCubeHierarchy* AddCalculatedHierarchy( 
   string* DimensionName,
   DataTable* OriginalTable,
   Type* DataType,
   string* DisplayName,
   string* SourceColumnName,
   string* SourceColumnFormat
) 
C++/CLI 
public:
TCubeHierarchy^ AddCalculatedHierarchy( 
   String^ DimensionName,
   DataTable^ OriginalTable,
   Type^ DataType,
   String^ DisplayName,
   String^ SourceColumnName,
   String^ SourceColumnFormat
) 

Parameters

DimensionName
Defines the name of the dimension to put the new hierarchy into.
OriginalTable
Defines the table in the data schema the calculated field must be located in.
DataType
Defines the type of data in the new calculated field.
DisplayName
Defines the name of the new hierarchy. The calculated field is given the same name.
SourceColumnName
Defines the source column for the calculated field. See AddCalculatedColumn for details.
SourceColumnFormat
The format mask to apply to the source column value. See AddCalculatedColumn for details.

Return Value

Returns the newly created hierarchy.

Remarks

Adds a new hierarchy to a cube, when it is created in run time. Unlike AddHierarchy, the method creates a new calculated field (just like AddCalculatedColumn) instead of basing a new hierarchy on an existing one. If you like, you may add a new calculated field through the AddCalculatedColumn, and then use it to create hierarchy through AddHierarchy.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2010 Radar-Soft, L.L.C. All Rights Reserved.