Oracle db

[Saiku]

Hello

Is it possible to use OWC with relational Oracle 9i db? I do not have
the OLAP option - so I must define my dimensions etc. in relational
tables maybe as a set of views. I am totally new to implementing OLAP
solutions on Oracle. I was hoping that I could do it similar to the
way its done in SQL Analysis Services but unfortunately I dont have
that flexibility now. Did someone go through this effort of doing it
all in Oracle relational tables and then using OWC? Any help would be
greatly appreciated.

Thanks
Sai

 

[Alvin Bruney [MVP]]

There is no built in support for this. You may have to go thru the
datasource object first or build a provider layer that takes the output from
the oracle datasource and converts it into XML that may be consumed by OWC.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley