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)

4402


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

679


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

691


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!!!

1851


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2062






hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1695


Is there any other repository domains rather than universe, security, document?

699


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

696


Which versions are used in the bo dashboard work?

680


How were the reports scheduled and how to resolve unexecuted documents?

2320


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

722


How many universes can be created in a project?

677


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

650


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?

645


What is difference between custom hierarchy and report based hierarchy?

640