survu
April 11th, 2002, 05:20 AM
Hi,
Need VC++ sample/syntax to create a local cube
.Cub file for SQL Analysis Service.
suggest me the syntax:
void GetCube(void)
{
HRESULT hr = S_OK;
_bstr_t strCreateCube(L"CREATECUBE = CREATE CUBE pldbtest( DIMENSION [MB],LEVEL [All MB] TYPE ALL,LEVEL [DESCRIPTION] ,MEASURE [Salesunit] Function Sum Format '#.#' )");
_bstr_t strInsertInto(L"INSERTINTO = INSERT INTO pldbtest( MB.[Description],Measures.[Salesunit] )SELECT MB.DESCRIPTION AS Col1,TEST2_16.SALESUNIT AS Col2,From TEST2_16,MB Where TEST2_16.MBCODE = MB.MBCODE");
_bstr_t strProvider(L"PROVIDER=MSOLAP");
_bstr_t strDataSource(L"DATA SOURCE=C:\\VcPl.cub");
_bstr_t strSourceDSN(L"SOURCE_DSN=RAT");
//hr = pConnection->Open(strProvider,strDataSource,strSourceDSN,strCreateCube;strInsertInto);
_bstr_t strCnn("Provider=MSOLAP;Data Source=C:\\VcPl.cub;"
"Initial Catalog=RAT;User Id=rrr;Password=rrsr;");
pConnection->Open(strCnn,strCreateCube,strInsertInto,adConnectUnspecified);
}
thanks,
survu@yahoo.com
Need VC++ sample/syntax to create a local cube
.Cub file for SQL Analysis Service.
suggest me the syntax:
void GetCube(void)
{
HRESULT hr = S_OK;
_bstr_t strCreateCube(L"CREATECUBE = CREATE CUBE pldbtest( DIMENSION [MB],LEVEL [All MB] TYPE ALL,LEVEL [DESCRIPTION] ,MEASURE [Salesunit] Function Sum Format '#.#' )");
_bstr_t strInsertInto(L"INSERTINTO = INSERT INTO pldbtest( MB.[Description],Measures.[Salesunit] )SELECT MB.DESCRIPTION AS Col1,TEST2_16.SALESUNIT AS Col2,From TEST2_16,MB Where TEST2_16.MBCODE = MB.MBCODE");
_bstr_t strProvider(L"PROVIDER=MSOLAP");
_bstr_t strDataSource(L"DATA SOURCE=C:\\VcPl.cub");
_bstr_t strSourceDSN(L"SOURCE_DSN=RAT");
//hr = pConnection->Open(strProvider,strDataSource,strSourceDSN,strCreateCube;strInsertInto);
_bstr_t strCnn("Provider=MSOLAP;Data Source=C:\\VcPl.cub;"
"Initial Catalog=RAT;User Id=rrr;Password=rrsr;");
pConnection->Open(strCnn,strCreateCube,strInsertInto,adConnectUnspecified);
}
thanks,
survu@yahoo.com