Add 'All' option and 2 other values in LOV

[AnthonyJ]

Using FM, we have a need to add 3 new values (All, Active, Active No Sustaining) in the Lifecycle LOV.

My current Lifecycle LOVs are

Code Select Expand


Development
Planning
Sustaining
End of Life
Concept

To accomplish this, I am thinking of creating a query subject with the following SQL statement

Code Select Expand


select distinct lifecycle from dim_lifecycle
union
select 'All' from dual
union
select 'Active' from dual
union
select 'Active No Sustaining' from dual

and use that object in my prompt macro's queryItem (as the LOV).

Question. I would like to find out if there is another and easier way to accomplish this task. If anyone has an idea, I would love to hear it.

Thank you.

[blom0344]

Another: add them to the lifecycle dimension table (in the ETL phase?)
Easier: same, though fixing it in the model seems to work okay as well