What is the correct order that RapidResponse applies filters to data?

RapidResponse applies filters to data in a specific order to ensure that the filtering process yields accurate and relevant results. The correct order begins with scenarios, which are foundational as they determine the context in which the data is assessed. Next, sites are applied, which restrict the data to specific locations or facilities, essential in a supply chain environment where analyses can differ drastically by site.

The inclusion of embedded worksheet filters comes next, allowing for refined data manipulation within specific worksheets or analyses. After these contextual filters, general filters are applied to further narrow down the dataset based on specified conditions. Hierarchies are considered subsequently, allowing data to be grouped or categorized effectively. Finally, column filters are applied, enabling filtering by specific attributes or metrics in the columns.

This order is crucial because it builds upon the foundational context of scenarios and sites, progressively filtering down the data and ensuring that the most relevant information is presented based on the user’s initial choices and analytical goals.