Using AS2005 as a "front-end" to transaction database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I've got a large table (+1M records) in a SQL Server database that has
captured a snapshot of transactional data for the past several years
at the end of each month. The table includes the dimensions and
attributes that were associated with those dimensions at the time of
the snapshot.

It would be helpful to be able to pivot this data, similar to the way
that I would use a pivot table in excel based off of one table.

I am trying to understand if there is an easy way to take one large
transaction table and process it in analysis services so that a pivot
could be built off of the resulting cube instead of directly against
the transaction table.

I keep getting hung up on whether or not I need to parse out the
dimensions from the transaction table. I'm not sure if I should do
that, since in this case of wanting to compare snapshot against
snapshot (all contained within one table), every dimension seems to
really be, not an independent dimension, but an attribute of the
"transaction" dimension.

Is it worth even thinking about creating a cube off of only one
transaction table that includes both the facts and the dimensions, or
am I wasting my time?

Thanks,

Eric

.

Relevant Pages

  • Re: Distribution Agent Startup Parameters
    ... have a manageable log size when a concurrent snapshot is applied in ... transaction log for large tables? ... the SQL2000 index creation logic in the distribution agent is not very ... having problems with the transaction log growing so large on the ...
    (microsoft.public.sqlserver.replication)
  • Re: transaction log too large when applying snapshot ?
    ... option is for transactions or the snapshot. ... The transaction log will not grow as large and the snapshot ... snapshot I get several bcp files per table. ...
    (microsoft.public.sqlserver.replication)
  • Re: Distribution Agent Startup Parameters
    ... manageable log size when a concurrent snapshot is applied in SQL2000. ... Won't setting it to a large value create a very large transaction ... snapshot is delivered to the subscriber as the *entire* snapshot will be ... SQL2000 index creation logic in the distribution agent is not very ...
    (microsoft.public.sqlserver.replication)
  • Re: Distribution Agent Startup Parameters
    ... transaction bounding the delivery of a concurrent snapshot in SQL2000, ... SQL2000 index creation logic in the distribution agent is not very ... having problems with the transaction log growing so large on the ...
    (microsoft.public.sqlserver.replication)
  • Calculating selective time spans
    ... have a simple transaction based data warehouse I'm building that for ... to various dimensions. ... "What was the time difference .. ... a start _and_ and end date for each transaction (by revisiting the ...
    (microsoft.public.sqlserver.olap)