After Publishing the KPI with Calendar(Business/Gregorian) its not referring the correct Aggregates. How to fix this?
This issue occurs if the Graph linked to the KPI does not have calendar filter. So even if the KPI with Calendar Filter hits to proper respective Calendar Aggregate Table, after analyzing KPI, its hits the Standard Aggregate Table. To fix this issue, try removing the Linked Graph and the KPI will refer proper Aggregate Table based on the Calendar Filter Selection.