Re: create cube from vb6

Tech-Archive recommends: Fix windows errors by optimizing your registry

The connection string based CREATE CUBE syntax is no longer supported in AS
2005.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Santosh Ransubhe" <santoshransubhe@xxxxxxxxx> wrote in message
news:OtSt2b%23kGHA.1204@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

I am trying to use the CREATECUBE functionality in AS 2005 through
connection string property, but getting following error:


Microsoft OLE DB Provider for Analysis Services 2005:
The following system error occurred: Unspecified error .

csSourceDSN=PROVIDER=MSOLAP;DATASOURCE=WOTTRANSUBHSXP\DEV;INITIAL
CATALOG=National;

CREATE CUBE [National] (
DIMENSION [Line],
LEVEL [All Line] TYPE ALL,
LEVEL [Line],
LEVEL [Brand],
LEVEL [Item Name],
DIMENSION [Date],
LEVEL [All Date] TYPE ALL,
LEVEL [Year] TYPE YEAR,
LEVEL [Quarter] TYPE QUARTER,
LEVEL [Month] TYPE MONTH,
DIMENSION [Market],
LEVEL [All Market] TYPE ALL,
LEVEL [Market],
DIMENSION [State],
LEVEL [All State] TYPE ALL,
LEVEL [State],
LEVEL [Outlet],
MEASURE [Quantity] FUNCTION SUM FORMAT '#,#',
MEASURE [Cost] FUNCTION SUM FORMAT 'Standard',
MEASURE [Revenue] FUNCTION SUM FORMAT 'Standard'
)

INSERT INTO [National](
[Line].[Line],
[Line].[Brand],
[Line].[Item Name],
[Date].[Year],
[Date].[Quarter],
[Date].[Month],
[Market].[Market],
[State].[State],
[State].[Outlet],
[Measures].[Quantity],
[Measures].[Cost],
[Measures].[Revenue]
)
OPTIONS ATTEMPT_ANALYSIS
SELECT
[National].[Line:Line],
[National].[Line:Brand],
[National].[Line:Item Name],
[National].[Date:Year],
[National].[Date:Quarter],
[National].[Date:Month],
[National].[Market:Market],
[National].[State:State],
[National].[State:Outlet],
[National].[Measures:Quantity],
[National].[Measures:Cost],
[National].[Measures:Revenue]
FROM [National]
WHERE [Line:Line] = 'Microwaves'
AND [Date:Year] = '1994'

I also tried using CREATE GLOBAL CUBE statement:
"CREATE GLOBAL CUBE [National123] Storage 'C:\\National1.cub' FROM
[National] ( MEASURE [National].[Quantity], DIMENSION
[National].[Line] ( LEVEL [Line], LEVEL [Brand], LEVEL [Item
Name] ) )";

Any idea if we can still use CREATECUBE & INSERTINTO properties in AS
2005 or we need to switch to CREATE GLOBAL CUBE???

Any help in this regard would be appreciated.

Thanks,
Santosh.

*** Sent via Developersdex http://www.developersdex.com ***


.

Relevant Pages

  • Re: Analysis Manager Operations extremely slow
    ... both RDBMS SMO and Analysis Services ... testing domain authentication. ... cube editor slowness if connecting to Oracle. ... Gender dimension to "M" and still browse the Sales cube. ...
    (microsoft.public.sqlserver.olap)
  • Creating a time dimension in AS2005
    ... I have previously worked on SQL Analysis Services 2000, ... would like to create a standard year-month-day dimension using the ... "...After you include the server time dimension in a cube, ...
    (microsoft.public.sqlserver.olap)
  • Re: Advanced Properties for Dimesions
    ... not set in the dimension editor, but rather only when you add the dimension ... to a cube and then look at the dimension in the cube editor -- i..e. it is a ... SQL BI Product Unit (Analysis Services) ... > be altered in the cube designer because they could be used in other ...
    (microsoft.public.sqlserver.olap)
  • Re: Changing Dimension option??
    ... spend some time reading and absorbing the material in the Analysis Services ... When you designate that at dimension is "changing", ... > move dimension members without having to re-process the cube". ... > through the BOL first. ...
    (microsoft.public.sqlserver.olap)
  • Re: Automatic MOLAP questions
    ... there is a lock when the polling query is evaluated. ... when you execute a polling query, the result of the query and the previous datetime can be used to do an incremental processing. ... so an incremental process only add content in a cube and can't update the cube. ... SSAS will not try to process the dimension. ...
    (microsoft.public.sqlserver.olap)