Jun 26, 2012 -- 12:33PM, orthous wrote:

Jun 26, 2012 -- 11:20AM, gianfrancofiorentini wrote:

Actually, when you create a Webi report on a datasource based on a BICS connection, all measures in report show #TOREFRESH before any data update, because a BICS connection sets any measure with "Database Delegated" as default setting.

Does the new Feature Pack improve or change this feature?

If not, is this improvement planned in the future?

 

Gianfrancofiorentini: Have you tried removing the Scope of Analysis in the Web Intelligence query?  If this does not work, then I think development is looking to solve this in future releases.  I don’t work for SAP so would not be able to tell you when.  Check this out à scn.sap.com/thread/1338289  [Thank you for your question - Gabe]

Hello,

this is not related to the scope of analysis, this is related to the fact that key figures are configured as database delegated.

With Feature Pack 03 all key figures that are configured as a SUM for the aggregation in SAP BW are also treated as a normal SUM in Web Intelligence

regards

Ingo Hilgefort, SAP

Jun 26, 2012 -- 1:29PM, orthous wrote:

Jun 26, 2012 -- 1:21PM, BasiaBuczkiewicz wrote:

Thanks for your questions, all. We are looking to upgraded from 3.1 to 4.0 Q1-2013. We have just gone live with a the 1st of 4 key locations SAP implementation. We are NOT a BW shop except for the BPC module. SAP ECC 6 is the version we deployed. To close gaps in the ECC reporting, we are considering building reports on BPC and ECC for the finance team. However I am hearing the end result is not as easy as it is portrayed and we may want to warehouse the data into our TeraData environment first since the custom ECC solutions are not delivering what is needed. WebI is our leading strategy yet if I put the reports on ECC directly or on BPC directly, I would not be able to enable power users.

a) With 4.0 Can I deploy WebI on ECC? BPC/BW? (Pros/Cons?)

b) Or is Crystal a better option? Would you please provide your insights on pros/cons? 

c)  Are the perfomance issues for either/both a risk?

d) If we go the Universe route for Crystal, are there any limitations? 

BasiaBuczkiewicz;

a) With 4.0 Can I deploy WebI on ECC? BPC/BW? (Pros/Cons?)

Webi on ECC no. I would deploy BW and then Universe to feed Webi.  Pros: your BI environment is separate from your transactional systems and allows for greater flexibility.

b) Or is Crystal a better option? Would you please provide your insights on pros/cons?

Crystal Reports could be embedded into a custom solution, the issue is that BI4 SDK does not contain all components from previous versions, so you may run into limitations there.

c)  Are the perfomance issues for either/both a risk?

Yes, unfortunately.  The BW/Universe/Webi in BI4.0 would give you the best “overall” end-user experience…. IMHO ;-)

d) If we go the Universe route for Crystal, are there any limitations?

Limitations yes, but it depends on your user requirements… please refer to this podcast on differences between CR and Webi tools.

dslayer.net/dslayer/view/95-sap-crystal-...

Enjoy!

[Thank you for your question - Gabe]

HI,

a) With 4.0 Can I deploy WebI on ECC? BPC/BW? (Pros/Cons?)

With BI4 Feature Pack 03 or Service Pack 04 you are able to create a Universe on top of BW and also on top of ERP and it also allows you to combine those two sources.

b) Or is Crystal a better option? Would you please provide your insights on pros/cons? 

By using the Universe layer you have the option to use it with Web Intelligence, Crystal Reports for Enterprise, and Dashboards, and Explorer.

c)  Are the perfomance issues for either/both a risk?

You are reporting on top of your OLTP environment so you always want to keep an eye on the performance.

d) If we go the Universe route for Crystal, are there any limitations?

Right now the supported data sources in the Universes for SAP ERP are InfoSets, ABAP Functions, ABAP Queries.