Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
colin_liying
Starting Member
4 Posts |
 Posted - 2010-04-20 : 05:14:14
|
| Hi all,I have set up an environment including Sql server analysis server client and server, I got an error when i tried to send an Execute Insert Command envelope to server, server gave a response saying “Errors the high-level relational engine. A MemberValue column was specified for the 'Date Key' attribute, but no binding exists for it”, envelope as below:- <Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"> <Body> <Execute xmlns="urn:schemas-microsoft-com:xml-analysis"> <Command> <Insert xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Database>SSAS</Database> <Cube>SsasCubes</Cube> <Dimension>Sales Territory</Dimension> </Object> <Attributes xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Attribute> <AttributeName>Sales Territory Key</AttributeName> <Name>fds</Name> <Value>aa</Value> </Attribute> </Attributes> </Insert> </Command> <Properties> <PropertyList> <LocaleIdentifier>1033</LocaleIdentifier> </PropertyList> </Properties> </Execute> </Body></Envelope>Test TESTCUBE Sales Territory Sales Territory Key fds aa 1033 do you know why??? if i remove aa, server will response saying"Dimension is not write enabled, therefore the writeback operation failed" actually, i have set write enabled to be true.. Can you help me??? |
|
|
|
|
|
SSAS Insert command