Can we take report on Excel in Business Objects?

Answer Posted / vkrishnabo

Yes, We can take a report on excel in Business Objects,

Process ....

In Desktop Intelligence -> File -> New - Generate a
standard report -> Begin -> Other -> Personal Data Files ->
Finish -> format -> xls & select excel file from browse
option -> If excel file first row contains column name then
select the check box -> First row contains column names ->
Run.

------------------------------------------------------------

If you want to save a BO report in excel format then,

After generating a report file -> save -> File name -
> ....... & save as type -> xls -> Save

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4485


Explain how to schedule the report in b.o?

732


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10275


how get the grand total in master-detail report?

1992


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

784






webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4128


What is the difference between slice and dice and cross tab report?

808


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2142


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

747


What is report template in b.o?

741


What are the steps to be taken to schedule the report?

717


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

749


Explain is data mart?

747


how many reports have u created ? explain a few.

1831


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1943