Unanswered: Editor or parser for Olap or Create Cube statements
I would like to know if there is any editor or parser where I can check my 'Create cube ' statements.
I am trying to create a local cube and I am getting an error while compliling my prorgram
The error is : ' Syntax error in column definition'
So could u suggest me some editor or parser where I could check only the statements I am using for the create cube ..
i.e Statements I use for Creation of Cube,Insertion of data in to cube and the select clause.
Thank for sparing ur time
Private Sub cmdClick_Click()
Dim cnCube As ADODB.Connection
Dim s As String
Dim strProvider As String
Dim strDataSource As String
Dim strSourceDSN As String
Dim strSourceDSNSuffix As String
Dim strCreateCube As String
Dim strInsertInto As String
Dim strSource As String
On Error GoTo Error_cmdCreateCubeFromDatabase_Click