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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-02-07 : 15:44:16
|
| Hi,I was talking to my boss to day and our report request are not very consistant. We always having someone coming back to change something in our report. We were thinking of useing something called the Cube Analysis. Then it give our employees the raw data for them to run any standard query for themself. We have folks that want a report one way, but then they changed their minds and we are creating yet another report 4 or 5 times. what are your thoughts about this type of database? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 19:57:36
|
| It's nothing do to with type of db. You can create a view to contain columns users need and let them build reports from there. |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-02-08 : 09:00:19
|
| I think if you really need flexible reports,you should be considering cubes.MS cubes are good for small applications,if its a huge amount of data,u could consider hyperion essbase. Its an awesomely awesome thing. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-02-08 : 09:09:56
|
| just to add.. don't just go for hyperion if you have tonnes of data.. also consider how complex the reporting is ..How complex the hierarchies and calculations are.. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 21:34:43
|
| Cube can contain lot of data, we have 800gb cube and reports work fine. |
|
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-02-09 : 08:03:40
|
| You can also train them on using Excel Pivot tables. Its a handy tool for business users. |
|
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-02-14 : 14:06:32
|
| Thanks for all of your comments. |
|
|
|
|
|
|
Opinion on Cube Analysis