Data Warehose and web solutions

[fmsousa]

hi!
I woul like to know how can i publish OLAP cubes in the web.
For example: XML, DHTML, ASP, ...???
For that solutions could u give me some code samples? (or books references,...)
thanks for your atention! bye

 

[esearing]

Some of the middle ware tools like IBI's WebFocus or Seagate Crystal Info allow OLAP via the web. I have used both, WebFocus is the most user friendly for non technical users.

Eric Searing
eric.searing@wcom.com

 

[BobWard]

You could use a tool like BusinessObjects to access an OLAP cube, it hasa web component called Web Intelligence too. There are a selection of third party products that can also help deliver BusinessObjects information to the web. Do you want to give users access to the cube or just give them static views of the information ?

 

[fmsousa]

To BobWard:
i just want to give users static views of the information.

 

[BobWard]

As you want to publish static views of information you could look at implementing BusinessObjects as the report generator. BusinessObjects will give you flexibility in report formatting and is a great tool for reporting over Data warehouses/ data marts, It is extremly powerful at query/ reporting. You could then look at a complementory tool for BusinessObjects focussed on web publishing or use BusinessObjects Web Intelligence, third party may be a cheaper alternative.

The problem with writing your own code is that its a maintenance headache, needs a code change for extra reports/users personalisation of reports is code based too. A package solution would provide many benefits for the future.