How to get hidden dimension meta data from local cube file? -
06-16-2004
, 01:14 PM
Dose anyone know how to get the meta data information of hidden
dimension in a local cube file?
I create a local cube using 'Create Cube' DDL and one dimension in the
cube is HIDDEN. When I retrieve the meta data from local cube as
following vb code, the hidden dimension is not in the result. How can
I get meta data for the hidden dimension?
thanks in advance.
My sample code in VB as following:
Dim cnCube As ADODB.Connection
Dim strDataSource As String
Dim oRS As ADODB.Recordset
Set cnCube = New ADODB.Connection
strDataSource = "PROVIDER=MSOLAP;DATA SOURCE=c:\temp\localcub.cub;"
Call cnCube.Open(strDataSource)
Set oRS = cnCube.OpenSchema(adSchemaDimensions) |