I have multiple dashboards, But I am taking only 2 dashboards as examples here.
1. Admin dashboard 2. Other dashboard.
We have current date set up module published in Admin dashboard (please find the below screenshot for reference),
whenever user used to setup the current date in admin dashboard, the same date should get reflected to my 2nd dashboard(other dashboard),I am also attaching the screenshot of second dashboard below. now it is showing 2019, but I am trying to change it to 2018 or 2020 I am not seeing any changes in my 2nd dashboard, For Example: In above screenshot the current date set up year is selected as 2019, but I am trying to change it to 2020, it should show the same 2020 in my 2nd dashboard(other) but which is not updating in my 2nd dashboard and showing the same old result.
so automatically the results should reflect in the below for company quota (before adjustments), Quota Adjustment% and Company Quota (after adjustments) to Q1,Q2,Q3, Q4 & FY other dashboard.
Ok, it's difficult to know without seeing if Current Date is being used elsewhere, but, as you can see, the other line items don't have any dimensions, so I suspect that the Dummy Entry could be unnecessary. The fact that there are SELECT statements focussing on a single item in Dummy Entry I suspect it's redundant.
As an aside, SELECT on detail items is a no-no!!
Have a look to the right of the blueprint view and see where/if CurrentDate is being used.
If is isn't used for anything, you could remove Dummy Entry from that module
If you are not sure, I would just create a new module (without dimensionality) and then use that first to get the filter working