MS SQL Server OLAP - Writeback trouble

Author

Writeback trouble

Michael Vardinghus

2005-08-30, 8:25 pm

I'm trying to do this in the mdx sample app

ALTER CUBE Budget CREATE DIMENSION MEMBER [Artskonto].[All Artskonto].[10
Indtægter].[99 Test],
KEY = 99

Little uncertain about the syntax though....99 is the new member which
should be added to 10 Indtægter parent.

It just gives me an error - tried different ways....

Michael Vardinghus

2005-08-30, 8:25 pm

I actually got this to work

> ALTER CUBE Budget CREATE DIMENSION MEMBER [Artskonto].[All Artskonto].[10
> Indtægter].[99],
> KEY = 99

But how can i writeback a member with both name and key ?

"Michael Vardinghus" <xxx@xxx.com> wrote in message
news:OKJYYiZrFHA.332@tk2msftngp13.phx.gbl...
> I'm trying to do this in the mdx sample app
>
> ALTER CUBE Budget CREATE DIMENSION MEMBER [Artskonto].[All Artskonto].[10
> Indtægter].[99 Test],
> KEY = 99
>
> Little uncertain about the syntax though....99 is the new member which
> should be added to 10 Indtægter parent.
>
> It just gives me an error - tried different ways....
>
>

Sponsored Links