Guys need some help. I’m creating a report that connected to a universe. My problem is when I try to create a parameter field for this report there are no values displaying.
nahtanoj 
(BOB member since 2009-07-08)
are you connected to the repository?
ShaneL 
(BOB member since 2009-04-02)
Nope… I only created a report using universe as datasource. I only try to create a prompt but no value have been displayed.
Do I need to connect to repository?
nahtanoj (BOB member since 2009-07-08)
When you use a universe as your datasource and want to create a parameter, you can either do two things.
a. Create the prompts in the universe. This is where you include the prompt’s list of values
table_name.column_name = @Prompt(‘Prompt Name’,‘A’,‘List of Values Here’,mono,constrained)
or
b. From the Query Panel, drag an object that you want to filter on in the Query Filter pane, select the Prompt radio button, enter a prompt text and tick the “Select only from List” option
AnthonyJ (BOB member since 2006-06-30)
I would like to ask if the @prompt function is possible if the datasource is SAP?
Thanks 
nahtanoj (BOB member since 2009-07-08)
I don’t have any experience with SAP datasource. If this datasource reside on databases, then all you need to do is to create ODBCs/OLE connections and use those to define your connections in the Universe. If not, maybe others can help out.
AnthonyJ (BOB member since 2006-06-30)