=== Also posted in microsoft.public.sqlserver.olap ===
Hi,
This is my first post here, so i would like to appologize first for my
bad english and if i violate some rules of the netiquette.
I have a question concerning Wirteback. I am engaged in the
development of a lightweight application written in ASP.NET. We use
XMLA to communicate with Analysis Services 2000 and 2005. In order to
implement writeback functionnality, we would like to display a
datagrid with two types of cell :
- those which are editable would be represented by a textbox to allow
user to type some data in it.
- those which aren't would be represented by a simple label.
Our probleme is the following : to know if a cell can be edited by a
user, we look at the Updateable cell property returned by XMLA. With
AS2K it seems to work (in fact we have to do more tests) but with
AS2K5 the value of the Updateable cell property is always 1. I
wondered if there is another safe way to test the editability (this is
english, right ?) of cell before executing an UPDATE CUBE MDX query.
Indeed, the execution of such a query on cells that aren't editable
seems to fail badly. :o(
Thanks for reading and eventually answering.
