do we have mandatory prompts in universe which are created on database views? Explain please?

[srinivas_goud5]

Hi Experts,

We have universes created on data base views.

Can we create mandatory prompts or only optional prompts we can create?

Please explain in detail?

Also tell me about snapshot universes purpose and how do we create those?

Thanks in advance.

[Former Member]

Hi Vasu,

In order to create prompts, you will have to use @prompt function.

To use @ functions, you will have to use derived tables at universe level.

@ functions are BO specific and NOT database specific; therefore, if you will put @ function while writing the SQL for views, you will get syntax errors.

Regards,

Yuvraj