Using Oracle BI Enterprise Edition 12.2.1.4
I have a prompt that is a checklist with 3 items: A, B, and C. You can choose 1 item, 2 items, or all 3 items.
I have a presentation variable called PVItem which holds my choice(s).
In my analysis, i have a column formula which will need to create 1, 2 or 3 columns as needed, based on the items checked.
case when ‘@{PVItem}’ like ‘A%’ then ‘Column A’ /* create a column with title Column A */
…. and then need to finish the case statement for B and C, keeping in mind i'll need another column for each if it was checked.
shouldn't be too difficult but having a hard time getting beyond 2 new columms….