Re: Data is not coming when date dimensions added in group by
Are you sure your data exists at that level of detail (Id,Code,Month,Date,Year_No)?. If your data is not at all levels of detail it may be causing that the script returns you nothing.
One way you can debug this is loading a small portion of data with these dimensions and without the group by. Then in the front-end create a straight table with these dimensions and some/all the expressions you included in the group by script. In order to check that data exists at all levels of detail you should be able to see the correct split of data between each combination of dimension values (eg. Year_No > Month > Date >Code). If you get the same value for a whole dimension it would mean that your data is not splitted for that dimension,