cancel
Showing results for 
Search instead for 
Did you mean: 

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

srinivas_goud5
Explorer
0 Kudos
101

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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