how to use insert command in sql analysis services

Hi all,

I have a problem regarding how to use insert command in ssas, i try to send a request to server, server give a response saying "No binding exists for it", my request envelope is:-

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"&gt;
    <Body>
        <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
            <Command>
                <Insert xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"&gt;
                    <Object xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"&gt;
                        <Database>SSAS</Database>
                        <Cube>SsasCubes</Cube>
                        <Dimension>Sales Territory</Dimension>
                    </Object>
                    <Attributes xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"&gt;
                        <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>

Should i create a attribut binding before using insert command??? any body can help me ?

one more question, when i use Update command in ssas, I also got a error say "Attributes cannot appear in Where ". can you tell me why??

Thanks

ansaurus

tags:

views:

answers:

how to use insert command in sql analysis services

related questions