Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-08 : 08:53:27
|
| steve writes "I have reporting systems that I am changing to olap. Can I access the cube with sql statements? Can I have my current application access the cube that has all the data from the relational table through a ole db driver using the existing sql in the application? If so how do I make a data source that represents the cube to my odbc application?" |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2003-01-14 : 12:52:18
|
| It really depends. The best Storage model for what you're requesting is the ROLAP (Relational) which will physically store the aggregations inside your database. I would say that this is the difficult route though as your storage requirements will be larger and querying will be a nightmare. Your application should connect using ADOMD and your query language will be MDX, there are a few tools out there that are very nice at connecting to a cube that can do your graphing, High/Low Analysis, etc. The one that I would recomend is made by SoftPro (I think they're out of Croatia), it's free to use and very powerful. I've put the link below. Cognos and cubularity are also two I would recommend to get you started. Hope this helps,JamesH.http://www.microsoft.com/sql/partners/DWA/query.asp |
 |
|
|
|
|
|
olap and odbc