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]

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]

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