<div>
It is the design which I want to later use in analysis services, for getting counts of some column and summing up some columns data as doing it by sql is t'ing way to long to run the queries and get the results<br />
Ervicervices,<br />
<br />
Fo<br />
r
</div>


It is the design which I want to later use in analysis services, for getting counts of some column and summing up some columns data as doing it by sql is t'ing way to long to run the queries and get the results
Ervicervices,

Fo
r

<div>
could it be you are looking for materialized views?
</div>


could it be you are looking for materialized views?

<div>
What do u mean by materialized views ? Please guide.<br />

</div>


What do u mean by materialized views ? Please guide.


<div>
That view did not help much...any other examples ?
</div>


That view did not help much...any other examples ?

<div>
I had to find out more info apart from what the expert suggested.
</div>


I had to find out more info apart from what the expert suggested.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Can anybody please guide me to guides which gives you an idea about how to flatten rdbms data ?<br />
<br />
Thanks in advance.<br />
<br />
Aash.
</div>
</div>


Hi All,

Can anybody please guide me to guides which gives you an idea about how to flatten rdbms data ?

Thanks in advance.

Aash.

Flattening Data

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.