Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cubes without A Data Warehouse?


Cubes without A Data Warehouse?

Author
Message
MothInTheMachine
MothInTheMachine
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 Visits: 307
Greetz!

I'm new to the BI space and have been asked to look into using cubes without building a datawarehouse or otherwise restructuring the current reporting database that is in use. Everything I've seen in the way of articles and tutorials about cubes use the AdventureWorksDW database and nothing has used a relational model. Is it possible to build cubes of relational tables? I'm guessing the performance would be abysmal but I'm not certain. Would this solution, if possible, suffice for a small number of users (like 5) doing ad hoc reporting?

Any good resources you have for learing more on this would be great.

Thanks!

Love them all ... regardless.
- Buddha
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3095 Visits: 4639
I remember developers creating Cognos cubes out of a relational database so the answer would be yes, it is possible.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16518 Visits: 13210
It's possible. You can "model" a dimensional starschema in the data source view of Analysis Services.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
MothInTheMachine
MothInTheMachine
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 Visits: 307
I've also seen BI-Lite which claims to be able to do the job. I've not been able to test this since it requires .Net 4 which I'm not able to install just yet.

I'm not able to use 3rd party tools (at this point) so I should have clarified that I would need to do this in ANSI SQL using SQL Server 2008 R2.

Love them all ... regardless.
- Buddha
aaron.reese
aaron.reese
Mr or Mrs. 500
Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)Mr or Mrs. 500 (591 reputation)

Group: General Forum Members
Points: 591 Visits: 898
Why DONT you want to build a DW? apart from a pretty steep learning curve, I don't think there is any licencing issue with R2

you can build pivots for specific datasets, or you may be better off connecting XL to the R2 database and using pivot tables

A lot of cube type analysis can be done in SSRS as well.

How big is your data, how GOOD is your data and how well indexed are your tables. On the primary tables, are you mainly inserting records or are there a lot of updates and deletes as well. Is the database OLTP (transactional) or OLAP (analysis and reporting)

Do users need to be able to summarise and drill down in many different ways, or do they just want pretty reports. If the latter, then SSAS may be overkill, you can do the same using nise SSRS reports.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search