Patent ID: 7650332

Claim:
A system embodied in a computer-readable storage medium, that facilitates one or more of querying and updating a multidimensional structure, the system comprising: an interface component that receives a first statement in a declarative language relating to a typed object associated with the multi-dimensional structure, the interface component including a toggle component configured to receive, via a user interface, a plurality of user inputs, wherein said plurality of user inputs specifying how the toggle component is to return data in response to received statements querying data from unrelated dimensions of the multidimensional structure, the plurality of user inputs including: first user input indicating that, in response to the received statements querying data from unrelated dimensions of the multidimensional structure, the toggle component is to return a value of a selected unrelated dimension without any of the other unrelated dimensions; second user input indicating that, in response to the received statements querying data from unrelated dimensions of the multidimensional structure, the toggle component is to return a null value; and third user input indicating that, in response to the received statements querying data from unrelated dimensions of the multidimensional structure, the toggle component is to return an error; a context recognition component that analyzes the first statement and determines a desired output that is associated with the first statement, wherein the context recognition component reviews pre-defined rules associated with the object type to determine a type conversion to be undertaken; a conversion component automatically converts the object to a disparate type as a function of the analysis in response to receipt of the first statement; a member analyzer that determines whether a member associated with the received first statement is consistently resolvable, wherein the member analyzer has a plurality of user-selectable configurations are selectable via a user interface, wherein when the member analyzer is in a first of the plurality of user-selectable configurations and the member associated with the received first statement cannot be resolved consistently, the member analyzer outputs a null member, wherein when the member analyzer is in a second of the plurality of user-selectable configurations and the member associated with the received first statement is unresolved consistently, the member analyzer outputs an error; and a binding component that resolves an argument within the first statement at execution time.