Hello

I am confused how to create a local cube from a AS2005 data source on a
system without AS2005

I try to use a ado connection with a special connectionstring of the format
1) DSN
2) CREATECUBE=
3) INSERTINTO=

This works for AS2000, but does not work for AS2005 (I think I have the
right syntax for CREATECUBE= !!)


I am not sure if I need INSERTINTO, or if the syntax has changed

See below my connection string

Please advice
Klaus Wiesel

LOCATION=D:\TEST2.CUB;
SOURCE_DSN="Provider=MSOLAP.3;Data Source=DEVSQL01;Initial
Catalog=FoodMart 2000";
CREATECUBE=CREATE GLOBAL CUBE [TEST2] FROM [FoodMart 2000]
)
MEASURE [Warehouse].[Store Invoice],
MEASURE [Warehouse].[Supply Time],
MEASURE [Warehouse].[Warehouse Cost],
MEASURE [Warehouse].[Warehouse Sales],
MEASURE [Warehouse].[Units Shipped],
MEASURE [Warehouse].[Units Ordered],
MEASURE [Warehouse].[Warehouse Profit],

DIMENSION [Warehouse].[Product] (
LEVEL [(All)],
LEVEL [Product Family],
LEVEL [Product Department],
LEVEL [Product Category],
LEVEL [Product Subcategory],
LEVEL [Brand Name],
LEVEL [Product Name]
),

DIMENSION [Warehouse].[Store] (
LEVEL [(All)],
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name]
),

DIMENSION [Warehouse].[Time] (
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),

DIMENSION [Warehouse].[Warehouse] (
LEVEL [(All)],
LEVEL [Country],
LEVEL [State Province],
LEVEL [City],
LEVEL [Warehouse Name]
))
;
INSERTINTO= INSERT INTO [TEST2] (
[Measures].[Store Invoice],
[Measures].[Supply Time],
[Measures].[Warehouse Cost],
[Measures].[Warehouse Sales],
[Measures].[Units Shipped],
[Measures].[Units Ordered],
[Measures].[Warehouse Profit],
[Product].[Product Family],
[Product].[Product Department],
[Product].[Product Category],
[Product].[Product Subcategory],
[Product].[Brand Name],
[Product].[Product Name],
[Store].[Store Country],
[Store].[Store State],
[Store].[Store City],
[Store].[Store Name],
[Time].[Year],
[Time].[Quarter],
[Time].[Month],
[Warehouse].[Country],
[Warehouse].[State Province],
[Warehouse].[City],
[Warehouse].[Warehouse Name])

SELECT
[Warehouse].[Measures:Store Invoice],
[Warehouse].[Measures:Supply Time],
[Warehouse].[Measures:Warehouse Cost],
[Warehouse].[Measures:Warehouse Sales],
[Warehouse].[Measures:Units Shipped],
[Warehouse].[Measures:Units Ordered],
[Warehouse].[Measures:Warehouse Profit],
[Warehouse].[Product:Product Family],
[Warehouse].[Product:Product Department],
[Warehouse].[Product:Product Category],
[Warehouse].[Product:Product Subcategory],
[Warehouse].[Product:Brand Name],
[Warehouse].[Product:Product Name],
[Warehouse].[Store:Store Country],
[Warehouse].[Store:Store State],
[Warehouse].[Store:Store City],
[Warehouse].[Store:Store Name],
[Warehouse].[Time:Year],
[Warehouse].[Time:Quarter],
[Warehouse].[Time:Month],
[Warehouse].[Warehouse:Country],
[Warehouse].[Warehouse:State Province],
[Warehouse].[Warehouse:City],
[Warehouse].[Warehouse:Warehouse Name] FROM [Warehouse]

No, I am pretty sure that it is not possible to create a local cube
using the connection string technique that used to work against AS 2000.
I think you can create local cubes, but you have to use the CREATE
GLOBAL CUBE statement.

There are some examples of this statement here:
http://msdn2.microsoft.com/en-US/lib...1(SQL.90).aspx

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <e47g228VGHA.5468 (AT) TK2MSFTNGP14 (DOT) phx.gbl>,
klaus.wiesel (AT) infor (DOT) com says...

Hi

I found out that to create cubes (which are defined in AS2005 ) from VB6
(and not necessarily AS2005 installed locally) you have to do the following:

1) install the OLEDB-drivers for accessing AS2005 data sources (download
from MS), there are some more packages like msxml 6 which must be installed
2) create an adodb.connection
3) set "data source", "initial catalog"
4) set provider to "MSOLAP"
5) open the connection
6) execute a cube creation string like described in the link from
Darren, see below

Regards
Klaus


Darren Gosbell wrote:

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=WOTTRANSUBH SXP\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 ***

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/Sho...ID=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 (AT) yahoo (DOT) com> wrote

Thanks Akshai for the information and direction to MSDN forum. That was
really useful.





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

Mr. Klaus, I am programming the solution with C# and not found the solution.
The CREATE CUBE LOCAL statemente follows these options:

1. CREATE GLOBAL CUBE Statement (MDX).
2. CREATE SESSION CUBE Statement (MDX).

but he was not successful. My problem is equal and not sure if the sintax
has changed.

Thank You
Jose Luis

"Klaus Wiesel" escribió: