<div>
On the contrary very helpful indeed.<br />
<br />
Thanks for spending the time to explaining.<br />
<br />
Cheers
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am new to data warehouse and data warehouse design<br />
<br />
Can any one tell me the advantages of working with a regular database design compared to working with a Dimensional design?<br />
<br />
The reason for my question is I am working with cognos8 and i notice some of the queries are created using Database objects and some with Dimensional objects and i wondered why?<br />
<br />
Thanks
</div>
</div>


Hi

I am new to data warehouse and data warehouse design

Can any one tell me the advantages of working with a regular database design compared to working with a Dimensional design?

The reason for my question is I am working with cognos8 and i notice some of the queries are created using Database objects and some with Dimensional objects and i wondered why?

Thanks

Database v Dimension view

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.