Taking data from Excel to Bo.

system · December 8, 2007, 8:14am

Hi can any one tell me
how can i take data as a input from Excel for business object Prompt values.
Example in my report i am entering a user id as prompt and getting data for that particular user.Now i am taking 20 user id’s in excel sheet then i want to enter these 20 values in Bo report.
here i taken the excel sheet from different data provider.And free hand excel from another data provider.
In Bo the report is prepared from universe i am getting .
But when the report is made from Free hand SQL I am not getting how to give in put from Excel and what condition to make and where .
can any one plz help.
Thanks In Advance.

sbbattula (BOB member since 2007-11-12)

system · December 8, 2007, 8:49pm

There is another alternative here. Use @variable() syntax in the Freehand SQL to get the prompt.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · December 9, 2007, 6:37am

HI Thanks for u r replay.
But my case is different.we will take inlist ,when the report is generated from universe.i am generating report from FREE hand SQL.so can please suggest how can i take all values at a time.

sbbattula (BOB member since 2007-11-12)

system · December 10, 2007, 2:38pm

You can’t take the list from Excel to FHS automatically. I was simply suggesting an alternative … copy the list from Excel (via the macro), and paste it into a prompt. You can create a prompt in FHS using the @variable() syntax.

Dwayne Hoffpauir (BOB member since 2002-09-19)