Role playing dimension is used when a dimension table is reused to join with a fact table more than once. A classic example of a role playing dimension can be a Time Dimension which joins with a Fact table. This Fact table contains OrderDate,ShipDate,ReceiveDate etc. To get these dates you will create just one table for TimeDim in […]
Month: March 2014
Maintaining Color of the Dimensions in QlikView
Recently at work, someone had a problem in assigning a consistent color to the dimension. For example, if a table consist of Products and Revenue then each Product should maintain a consistent color, irrespective of the selection. Suppose the table is as follows : A pie chart for the above table should maintain consistent colors for the Products i.e. BabyClothes should retain RGB(141,170,203),Sports […]
: