Hi ,
We are working on BO on top of BW pilot version and finding different issues with different tools.
1) Used existing BW queries/created universe.When we run the report using Web Intelligence, not able to get the way Hierachies displays in BEx.(Tree like structure).
If we enable drill up and down option, the summary level disappeas only we can see the lower level.Which I think is a useless information to the user as it appears like a flat file data.
We created the report with possible Hierarchies upfront like a canned report, but doesn't give any option to drill up/down further, doesn't allow the user any other activity, other than dragging/dropping some columns.
2) Tried to create the report in Crystal, but because of the page limitations, I cannot get all my columns in the same page( I have 35 columns)
3) To derive the reports in XCelicius, my business partner tells me that they need to create queries on Excel to use that functionality.They are preferring to go with R/3, rather than BW, which will be again significant amount of work.
I wonder if anyone encountered these kind of issues ?
Providing these limitations, I don't see much value of having this tool on top of BW.Any comments?
I agree, it is a great tool on top of relational databases, as we are using this tool on relational databases and didn't find these many issues.
Can someone provide me the list of advantages of having BO on top of BW? I mean what BO can offer when compared to BEx( We only use BEx, no Web)
Thanks
Priya