Update SQL Logic for Biosimilar Brands Based on KAISER GPO Flag

Introduction: Update the SQL query to incorporate the missing conditional logic for br_gpo_flag and align it with the production version. This change is critical to prevent over-suppression of biosimilar sales and ensure consistent and accurate reporting across environments.

 

Requirements: Update the 'bai_sales.sql' as below criteria.

 

Add the select logic competitor_flagand cast it to string datatype.

 

update the logic in case statement for the units(integrated_units, integrated_normalized_units, integrated_dollars) if br_gpo_flag is NULL, it treats it as an empty string. It checks whether br_gpo_flag contains the text like "KAISER" tied to biosimilar brands (Kanjinti, Mvasi, Riabni). Group by it accordingly.

 

Final Output: Show the result in sql logic.