Question:
I am trying to display the query name using a standard web template. I would like to have one template and have the ability to display the name from the query.
I also am trying to get the query name to show on the selection screen. I know it is not a good practice to remove the wording "Ad Hoc Reporting" from the selection screen. I would instead like to leave that and include a title using java code to display the query title on that page. Has anyone tried either of these?
Answer:
Hi Steveblack,
Query name in a standard template is no problem. U can use a text element and add REPTXTLG on the "List of text elements" property.
or just add this in the code in the body where you want it, U only need to change the Data provider to the name you use:
<!-- Query description--->
<title>
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="GET_ITEM"/>
<param name="NAME" value="TITLE"/>
<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_TEXT_ELEMENTS"/>
<param name="DATA_PROVIDER" value="DP"/>
<param name="GENERATE_CAPTION" value=""/>
<param name="ELEMENT_TYPE_1" value="COMMON"/>
<param name="ELEMENT_NAME_1" value="REPTXTLG"/>
<param name="ONLY_VALUES" value="X"/>
<param name="ELEMENT_NAME" value="REPTXTLG"/>
ITEM: TITLE
</object>
I am also interrested in replacing "ad Hoc" with the query description in the variable screen title but I do not know where the title on a variable selection screen is generated from. PLease let me know if you (or any other?) find a way to do it.
Cheers,
Skibum
_________________
You work only to get money for skiing!
Answer:
Thank you.
Once this code was applied it still did not work, but...
Under the "List of Text Elements" I used an "element type" of general text. This did not work. When I changed it to an element type of "Filter Value" it worked.
I have seen the query name added to the selection screen along with the wording "Ad Hoc", but the person did not supply the code and wanted to charge for this information. If I figure it out I will post it as a reply.
Answer:
Hi again,
saw this thread on SDN: https://www.sdn.sap.com/irj/sdn/forum?forumID=134
Question:
Hi,
Most of our BW reports use one Web Template. When the variable screen pops up, the header shows "Variables for Ad Hoc Report" instead of the name of the report that were are executing from the role folder.
Does anybody know how can I get the title of the report to show instead of "Variables for Ad Hoc Report"?
Thanks for your help!
Helena
Answer from SAP Employee Heike Guder:
Hi Helena,
sorry, but this is only possible with modification in class cl_rsr_www_variable_screen method FILL_OPEN_FORM(no customizing for this)
Heike
--------------
If you are really into it you might want to start diggin in that class and if do - please let us know the result of it.
Cheers,
Skibum