Generating Missing dates in Fact table

[joydipp1988]

Hello All,

Hope you all doing all. Currently I'm facing some challenges in my current project regarding missing time data generation.

I've created a dummy data set to describe the issue. It would be great if anyone can provide a workable solution for the issue. The .qvw and dummy data file is available as attachment.

Problem:

I want to show the trend of "No of Orders" placed for a particular Product in a Year. But the trend is showing data points for only those months when some data is present.

Below is the snap of current output and expected output-

Note: In real I'm dealing with 2 million records. So need to keep in mind the reload time and performance of the final application.

Thanks in advance. Cheers.

Joy

[Anil_Babu_Samineni]

Try to enable these options for Month and check

1) Show All values (Month Dim)

2) Suppress when value is null (Month Dim)

[joydipp1988]

Thanks Anil for your reply. But its not giving exact output. Below is the snap of output after applying your input-

[dwarikapanigrah]

Hi Joydip

PFA the updated file , Pls check and revert back incase any issue.

Regards

Dwarika Panigrahi