Wednesday, May 6, 2015

Excel: Create offline cube without wizard

Pakai MDX Sample Application
Contoh :
CREATE GLOBAL CUBE offlineSales STORAGE 'f:\userdata\temp\Sales.cub' FROM [Sales]
(
MEASURE [Sales].[Quantity],
DIMENSION [Sales].[Customer]
(
 LEVEL [Customer Name],
 MEMBER [Customer].[All Customer].[C M C]
)
)

Resources:
Using Data Definition Language with SQL Server 2000 ...

MICROSOFT BI: CREATING LOCAL OLAP CUBES USING XMLA AND ASCMD.EXE
* for SQL 2005

Creation of offline cubes from pivot table[Automation]
using macro
unfortunately, it throws some error with OLE DB Provider

using Local-Cube MDX
still can't find free/portable MDX editor
tried manual copy mdxsampl.exe from another computer but won't run with error " ... comctl32.ocx ... missing ..." even file exist on same folder


Related:
Error "connection name is already in use" when trying to create offline cube
Cause: you have multiple sheet containing same pivot (perhaps because you've copied the first sheet)

No comments:

Post a Comment