new columns in BI Publisher

Summary

create columns in BI Publisher

Content

I am writing a BI Publisher report that requires weeks in rotation and number of shifts in rotation. They are found in the PER_POSITION_EXTRA_INFO_F table but both fields are in the same column so I need to write a code that will give me "weeks in rotation" when

PER_POSITION_EXTRA_INFO_F.POIE_INFORMATION_CATEGORY='SKG_ROTATION_SUMMARY'

and another column that will give me "number of shifts" in rotation when

PER_POSITION_EXTRA_INFO_F.POIE_INFORMATION_CATEGORY=SKG_ROTATION_SUMMARY = 'SKG_ROTATION_DETAILS'

Code Snippet

PPEIF.POEI_INFORMATION_NUMBER1, CASE WHEN PPEIF.POEI_INFORMATION_CATEGORY = 'SKG_ROTATION_SUMMARY' THEN PPEIF.POEI_INFORMATION_NUMBER1 else null end as ”WEEKS”