say for example there are 10 brands and in the month of jan only for 5 brands sales occured then in the report we have to display these 5 brands plus 5 brands for which no sales occurred.
the model is like this.we have product dimension,one fact table,time dimension and version dimension.The purpose of version dimension is to indicate which month.for example on jan month this year means then 012006.if feb means 022006 like this.
say brands are a1 to a10.say in jan only sales occures for a1,a2,a3,a7,a8 and a10.
so if version is 012006 then in report the sales data should be present for a1,a2,a3,a7,a8 and a10.
Then for a4,a5,a6 and a9 even though there is no sales still we have to display.
Anyone who knows a solution for this pl help me out.
You will need a second dataprovider that contains all the brands (and other common dimensions if there are any). You link these to the dimensions in your initial dataprovider.
Your report should now show all brands and NULL values for the brands with no sale. You can replace these by zeroes, using the cell formatting option “Undefined”
(BOB member since 2006-02-21)
(BOB member since 2005-12-14)