Re: Is Cube a Good Option for Me?

It might help but it really depends on how your report is intended to be. If its just a adhoc report that fetches the data from your database on demand and real time data is required, then it might be best to keep it as a huge store proc with optimized indexes and query statements.

If however you have the option to have it query historical data, maybe update to the latency of an hour, you can try to create a cube out of it but that will mean that more database maintenance on your end.



On Wed, 29 Aug 2007 08:39:53 -0700, Doomed ReportsGuy <doomedreportsguy@xxxxxxx> wrote:

I need to replace a single slow view with a faster object that makes
several joins on some 36 tables/views (for reporting). I would like to
create a cube on a seperate server that has this same functionality, but
at the hopes that it improves performance and allows my report writers
to connect to it easily. Believe me, I'd rather break it up into smaller
objects, but can't at this time.

The only other thing I could think of is a huge proc, but I don't think
I would gain much from it. Would a cube be good for this?

Suggestions appriciated.

DoomedReportsGuy



*** Sent via Developersdex http://www.developersdex.com ***



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
.

Relevant Pages

  • Re: Can someone explain what the issue is
    ... the report is to show ... every product, per vendor, per sales team,, per employee in that sales ... > How many total rows are loaded into the cube? ... > What happens if you use the Data Browser in Analysis Manager to repo this ...
    (microsoft.public.sqlserver.olap)
  • RE: Reports ad-hoc from a OLAP Cube
    ... Reporting Services does not offer an ad hoc thin client cube ... Report Builder and Report Designer are useful tools to ... impression of an ad hoc cube browser. ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP Distinct Count question
    ... I used VS 2005 to create the SSAS 2005 OLAP cube and under the "cube structure" tab page I created the measure group"distinct count" on the fact table's column. ... The problem is not at the SSAS 2005 OLAP cube it is at the SSRS 2005 reporting when I assigned that distinct count measure to the report I have to use the expression Sumand it sum up all the distinct maesure. ... Unfortunately if the dataset for the report consists a "parent-child" dimension or more than a single dimension, on the parent/Top grouping level it sums up all the distinct count measure from the "child/other dimension" grouping level and it sums up all duplicate counts as well. ... Therefore at row grouping 1 will show the correct distinct count measure and when expand to the row grouping 2 it will show the distinct count measure on that level. ...
    (microsoft.public.sqlserver.olap)
  • RE: Dynamic Parameters in Excel Cubes
    ... in the cube. ... Second problem, ... I would like to make my time parameter dynamic so that opening the report ... Erwin Velthuis ...
    (microsoft.public.excel.misc)
  • Re: Pivot table in email
    ... an active cube and not just a report you will need to email a link to the ... Using OWC Pivot table on aspx, ... > "Jim Vierra" wrote: ...
    (microsoft.public.office.developer.outlook.vba)
Loading