Report definition not saving Declarative Index Join
As part of the Reporting exercise I'm trying to add the generated Index_EmployeeDetails to my Report Definition rule (see screenshot). However, when I press the Save button after successfully pointing to this Declarative Index Join, the table row with the definition suddenly disappears from the Data Access tab.
Generally Reports will remove the index if it is not actually used anywhere in the our report on save. It does this because, as an optimization to prevent unnecessarily slowing the SQL(Its like pre condition if we are using that declare index values then only it will joins the declare index class and forms the SQL.). If we use anywhere in our report like filter or in query it will not get removed.I hope it is clear.