[AS

Tech-Archive recommends: Speed Up your PC by fixing your registry



=== 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.

.



Relevant Pages

  • [AS2K5][XMLA] How to know if a cell is editable ?
    ... 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. ... datagrid with two types of cell: ... AS2K5 the value of the Updateable cell property is always 1. ...
    (microsoft.public.data.xmlanalysis)
  • [AS2K/2K5][XMLA] How to know if a cell is editable ?
    ... 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. ... datagrid with two types of cell: ... AS2K5 the value of the Updateable cell property is always 1. ...
    (microsoft.public.sqlserver.olap)
  • Re: SUM(above) bug?
    ... A user had the language in Control Panel>Regional and Language ... It should have been English. ... Blank cell ... The formula field at the bottom was doing a couple of odd things; ...
    (microsoft.public.word.docmanagement)
  • Re: Like MODE but not quite.
    ... BLANK means no cell contents, empty means blank or "". ... Which may be relevant in Danish newsgroups, but not in English ... English language versions is no cell contents. ...
    (microsoft.public.excel)
  • Re: SUM(above) bug?
    ... A user had the language in Control Panel>Regional and Language ... It should have been English. ... Blank cell ... Tested on my own PC (English (United Kingdom)) and I got the odd ...
    (microsoft.public.word.docmanagement)