I want to display the dates continuously if data is not available in final fact table, I have tried based on master calendar but not shows the continuously dates values.
I am expecting below output like that so on :
Please find the sample data file and qvws file.
Thanks for replay,
This is the simple application we can unchecked suppress zero values in presentation level and see the all values.
In my real time app have very big data and based on fact table date filed i have created the master table and tried all possible types. But that application doesn't shows the null values where miss the data.
Please let me know, Any other way to solve the problem..
Initially we can see all the data but when I selected the any filter i can see only limited dates values only not continuous values.
Initially shows me like:
1. when I selected any filter:shows me below out put but I need continuously dates with null values(0).
Even I tried multiple ways but i can get the continuous dates with all values.