why you create universe and creating reports based on that?
why dont we go for crystel reports and generate reports
directly?tell me the advantages?please answer to this question.
Answers were Sorted based on User's Feedback
Answer / manish
The biggest difference is that Crystal reports are used
for "canned" reporting while BO is used for adhoc
reporting.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / anil kuamr
Here you go.
The main purpose of the universe is, it acts as an
interface between database and BO. So a non technical guy
can also create a report using the universe by drag/drop
the objects.
Once the universe had built, you no need to again create
queries in Crystal reports also, you can simply use the
universe as source, it will save time.
If the universe is not satisfying your report requirements
then you need to go for other sources.
Hope your doubt is clear.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sourabh gosain
The main reason behind this is > REQUIREMENT OF REPORTS
POST COMPLETEION OF REPORT DEVELOPMENT PROJECT.
If business needs only a few reports based on their
requirement, and they don’t have any requirement of reports
post project. They can opt for crystal reports.
But if business is in need of future reports also, universe
comes into play. Where you have user friendly objects. All
you need is just to drag and drop them to create new report
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vidhya
Main difference is ROLAP (Relational OLAP) supported by BO
and not by Crystal Reports. ROLAP meaning is you can try to
generate the universe using SQL's from several data sources
(whatever you call like SQL Server,ORACLE etc;).In Crystal
Reports if you try to add more that one datasource that's
it!! the verify database option will be disabled(which
means it does not support)
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / sourabh gosain
Crystal Reports can not be edited by Users like we can edit
webi reports as par user requirement.
Crystal reports are created where there is no further
report development requirement. That means after completion
of a report development project , if a new report to be
developed one must have to have knowledge of data base/SQL.
Where as after creating universe we can make as many
reports we want after a small training session.
Crystal Reports can not be used to analyze the data using
drill down feature.
Crystal reports does not have feature of taking SNAPSHOT of
data after drill down on a particular dimension.
Crystal Reports can’t have more than one report in it. Like
in BO reports we can insert a report just like adding
worksheets in Excel workbook.
But still crystal reports have greater flexibility in terms
of Report Format, data exporting, Formulas, Section Expert,
Paging Formulas, Group Expert, Record Selection Expert,
Group Selection Expert etc……….
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / simha
actually source of the crystal report is Businessview. so u
must create universe. then after based on the Businessview u
generate the reports. otherwise to generate reports is not
possible by using crystal report suite. u want ro generate
the reports without the unverse to take personal
datafiles.crystal report separate installation is there.
TXT,PDF,.. type of reports work in Crystal reports separate
installation.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / prasanna
iam sorry i really did not understand what u mean to say?
my question is main difference to choose business objects
reporting tool?bez crystel also an reporting tool using
which i can create various reports directly from database
.so what is the main advantage of using b.o.?
| Is This Answer Correct ? | 0 Yes | 1 No |
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
when to go for alias and when to go for contexts
How to link one location universe to other location universe
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?
WHAT IS ROW LEVEL SECURITY IN BO?
What is the difference b/w breaks and sections
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
What is difference between webi and infoview?
1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
HOw do u migrate from old version to the new version?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?