Re: CREATE CUBE Expert wanted

#1

Hi,
After spending several days searching on the internet, your post is the only
one identical to my situation. It seems there is no example on how to create
a local cube with parent-child hierarchy. Were you able to make this work?
What is a template syntax? Where can we get documentation for this or an
example of a create cube with parent-child?

Thank you,
George

"Joerg" wrote:

Quote:

Hello Mosha,
thank you for your reply.
Same error.
Unfortunelty I did not get it working.

Below is my statement:

Provider=MSOLAP.2;Data
Source=c:\Test.cub;Source_DSN="Provider=Microsoft. Jet.OLEDB.4.0;Data
Source=C:\Foodmart 2000.mdb"
;CREATECUBE=CREATE CUBE EXPENSE
(
DIMENSION [Account] DIMENSION_STRUCTURE PARENT_CHILD
,LEVEL [Accounts;SubAccounts;*] ROOT_MEMBER_IF
ROOT_IF_PARENT_IS_BLANK_OR_SELF_OR_MISSING
,MEASURE [Amount] FUNCTION SUM FORMAT '#,#'
)
;INSERTINTO=INSERT INTO EXPENSE
(
[Account].Name
,[Account].Key
,[Account].Parent
,[Measures].[Amount]
)
SELECT
a.Account_Description
,a.Account_ID
,a.Account_Parent
,b.Amount
FROM
Account a, Expense_Fact b
where a.Account_ID=b.Account_ID;

Thank you
Jörg

"Mosha Pasumansky [MS]" wrote:

I am not a CREATE CUBE expert, but I your template doesn't look correct to
me. Can you try something like

LEVEL [Account;SubAccount;SubSubAccount*]

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Joerg" <Joerg (AT) discussions (DOT) microsoft.com> wrote in message
news:242FA97C-45EC-4F0E-831C-D12F2501CC0F (AT) microsoft (DOT) com...
Hello,
thank you for reading this.

I try to create a local cube with an access db as source.
Everything is fine so far. I have PARENT_CHILD,
PROPERTIES, even Custom Rollups are working.

But I can not set the LEVEL_NAMES with LEVEL_NAME_TEMPLATE:
"LEVEL [Account;SubAccount;*]"
results in "Analysis Error before SubAccount]" / Err.Code 2147467259

Unfortunely the DDL Syntax is not much documented.
I tried every possibility from BOL.
Is this a limitation with relational data as source?

Thank you
Jörg

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: CREATE CUBE Expert wanted

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: CREATE CUBE Expert wanted - 05-12-2005 , 10:28 AM