on 02-22-2010 7:03 PM
Hi friends,
we have in source system (ECC) a table, which includes some texts for every Profit Center for each month
001.2010 PRCTR1 Text1
002.2010 PRCTR1 Text2
001.2010 PRCTR2 Text3
002.2010 PRCTR2 Text4u2026
Text field (Text1, 2, 3u2026) can have approx. 100-120 characters.
They want to show those texts in BW reports according to Profit Center and Period.
But I donu2019t know how to define those fields in BW data model ?
If I define it as an Infoobject then they can have max 60 characters.
How would you define the data model in BW to show the text fields completely?
Cheers.
Hi
An Article in BI expert explainas about Displaying Text Longer Than 60 Characters in Web Queries.
BW users often turn to BW-based Web queries to display document-level details. For example, vendors often access BW reports through the Web and need to view long text stored on purchase orders or delivery documents. However, length limitations on BW InfoObjects restrict how much data users can display in BW Web queries. You can display text greater than 60 characters in BW Web queries by enhancing the context menu of Web queries and using a Business Server Page (BSP) application in the back end.
SAP Web Application Server includes BSP, a page-based programming model with server-side scripting as well as server page technology for developing, designing, and implementing Web applications. Server-side scripting enables direct access to all elements in the application server (such as function modules, database tables, ABAP Objects, and remote function modules).
To display text greater than 60 characters in BW reports, you must enhance the context (right-click) menu on BW Web queries by modifying the Web template to call the BSP application. In turn, the BSP application calls a remote function module in R/3 to retrieve the text and present it in a pop-up window. You must set up a separate BSP application for each field (such as delivery number) for which you want to display the enhanced context menu. Then, all users see the new option in their context menu.
Helpfull Link of BSP
http://help.sap.com/saphelp_nw2004s/helpdata/en/e9/bb153aab4a0c0ee10000000a114084/frameset.htm
Thanks
Suganya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi thanks for your reply.
We have nw2004 in use.
I am not familiar with BSP. I want to learn how to use BSPs in WAD ?
Can you send some links how to paper or step by step documents about BSP Page in WAD ?
I want to see some simple scenarios with BSP in WAD.
I have no access for BI Experts.
Cheers.
Check out following blog series:
/people/sap.user72/blog/2006/05/27/long-texts-in-sap-bw-modeling
/people/sap.user72/blog/2006/06/03/long-texts-in-sap-bw-modeling-150-follow-up
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Another question.
Can i solve it with using Documents.
Can i specify an existing Infoobject (Profit Center) as a document property ? After this will all related Infocubes and queries be affected ??
Or can i simply change an existing Infoobject as a document property. After that shold i make some adjustments in datamodell?
Thanks.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.