MSBI

Degenerate dimension

We have discussed the use of junk dimensions in data modelling and in this post we are going to explore Degenerate dimension. Lets start with the definition. Degenerate Dimension A high cardinality attribute column in the fact table which does not have any other content except its natural key and is required as a dimension for analysis or […]

Degenerate dimension Read More »

Junk dimension

What is a Junk Dimension? Have you ever come across a scenario where many small dimension tables connect (using foreign key) to the fact table? In data warehouse, we have two types of tables, Fact and Dimension. Fact table contains business facts as measures and references to the dimension tables. Dimension tables have attributes which contains textual information of business facts and

Junk dimension Read More »

Text wrapping in SSRS Reports in ReportViewer Control

In this blog post “Report Viewer wrap text”, we are going to learn an important trick of text wrapping in SSRS reports for long texts (without space and any separator) exceeding the width of a report column’s defined width and being rendered in a Report Viewer control of .Net  Application. Below is the problem explanation

Text wrapping in SSRS Reports in ReportViewer Control Read More »