SAP Crystal report vs SAP web intelligence

building reports webintelligence
1

Hi,
I just started learning SAP web intelligence today! So please bear with me if I am asking naive questions
This is the project that I have:
I have different analyst that each build different parts of an app.

  1. On one page/tap, I want them to select their name from a drop down menu ( data is pulled in from a table that has the analysts’ name)
  2. Now that they have selected their names, they can figure out how many active tickets they have ( throught the tickets they realize what parts of the app, they need to create), or how many tickets they have been working on since a particular date, and … for this part I have to write down some sql inner or keft joins…

Now, my questiodns are that based on this scenario, what’s the efficient tool to use? 1, SAP crystal report or SAP web inteligence
2, how can I have sql joins like inner join or left outer join in SAP web inteligence?

Appreciate your time,

Ninadeveloper (BOB member since 2019-03-27)

2

I would use Webi for that. Crystal`s use case is for highly formatted distributed reporting (i.e. invoices, bills, contracts etc) whereas webi is more ad-hoc, visual and interactive. All you want to do there can be achieved with Webi.

In terms of the joins, all that is done at Universe level. Or, if you wanted to write the SQL by hand a webi report can use freehand SQL (personally don`t recommend it).

ABILtd :uk: (BOB member since 2006-02-08)

3

I have written SQL to avoid creating a universe for a one off report.

kevlray :us: (BOB member since 2010-06-23)

4

I agree with ABILtd - definitely Webi.

If you’re going to write more reports against the same database, I’d certainly consider building a universe too.