There's a thread on the OTN BI Beans Forum asking the question "How do I update the values of an Analytic Workspace using a (BI Beans) Javaclient?"
Of course, one of the features missing at the moment from BI Beans is write-back, as the BI Beans components display data from analytic workspaces using the OLAP_TABLE function, allowing the 9i OLAP multidimensional structures to be queried using SQL statements. At present, this only works one way - you can issue SELECT statements, but you can't issue UPDATES, INSERTS or DELETES, and it's this current lack of write-back that that stops BI Beans from being a viable platform for planning and budgeting applications.
So, whilst you can create a datagrid within a BI Beans application, and make the cells editable, there's no easy way to copy these changes back to the analytic workspace to store the changes.
Thomas Hoffman and Keith Laker have come back with some useful advice, which i'm making a mental note of here as I think it could come in useful. The advice boils down to;
-
Register your BI Beans data source, using the OLAP_TABLE function
-
Build your application using a datagrid/crosstab or whatever
-
Register your application as a listener, to pick up candidate changes to the AW
-
Attach the analytic workspace read-write
-
Use a routine (for which Thomas provides some example code) to directly write the changes to the underlying analytic workspace database
-
Update the analytic workspace
-
Detach the analytic workspace
The sample java code to update the analytic workspace can be found at the OTN thread.
9:21:41 PM 
|
|
