Hi

Can someone point in the right direction for using the ALTER CUBE statement to create, remove and move members from a NON parent-child dimension.

I've managed to get it all working on the Account dimension in Adventure Works but not (for example) Sales Territory Region

I want to be able to allow our client users to writeback to any type of dimesion not just parent-child.

Is this possible? If not can anyone advise a better way of achieving this?

thanks

This is not supported.

You can use the newer XMLA-based APIs instead -- they support non-pc
dimensions, but are a little more complex to use and they also have some
limitations.

http://msdn2.microsoft.com/zh-cn/library/ms187188.aspx

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.


"Gilly" <gilly1409 (AT) hotmail (DOT) com> wrote

Hi

Can someone point in the right direction for using the ALTER CUBE statement
to create, remove and move members from a NON parent-child dimension.

I've managed to get it all working on the Account dimension in Adventure
Works but not (for example) Sales Territory Region

I want to be able to allow our client users to writeback to any type of
dimesion not just parent-child.

Is this possible? If not can anyone advise a better way of achieving this?

thanks

thanks for the response Akshai

I'll look into the XMLA approach.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote