Welcome to WebmasterWorld Guest from 18.104.22.168
I want to replace a spreadsheet with an Oracle database and a spreadsheet like read/write GUI, with graphical capability.
I thought an Oracle Forum may be the place to look but I do not know what I'm looking for (connectivity?).
I've found a file format called GraphML [graphml.graphdrawing.org] (which is only part of the problem) but I'm just as happy to do it non-web based.
PS. A science forum may useful too?
Basically they are set up as pivot tables querying the MS SQL database using OLAP. We can then massage the data any way we want, without having to change queries or involve IT.
I am no an expert on Oracle by any stretch of the imagination but I thought Oracle was OLAP compliant?
Is that going to acheive what you want?
You can use the standard pivot table refresh function (the bight red exclamation mark) which updates the data.
At my present company, we simply use the standard pivot table commands. At a previous company, that had thier developers put some VBA script in the front end to make it much prettier and easier. Depends on how many people are going to be using it I guess.
By allowing the data to be put into Excel, I can manipulate the data any way I want and do my own analysis without waiting for any IT involvement. This provides greater flexiability.
There is a heap of resource in TechNet, on the Excell Help and the Office Developer site.
If you don't want people to change the look of the data, why not present it as an online (Internet or Intranet) style of report? Especially if the queries are static against the database.
....and then commits the tweaks (only) back to the Oracle database.
You've pointed me in right direction though so thanks very much for that.
PS. I've also considered xml'ing (or something else) to some product or other but have not found the product - there will be no new data - just changes to existing data - and no changes to formula. The original structure (from Oracle) can be locked during the time between creation and the updates coming back - so the mapping is one to one.