Heading in Work Book: Fiscal week

[Former Member]

Hi all,

Is it possible to show week number in a work book heading. I have a query which is executed weekly basis. It is not possible to use fiscalweek in the drilldown as it is affecting other values. I am using fiscalweek in the selection. Now I know that in Bex it is possible by creating a text variable . But is it possib le to show Fiscal week in then heading of workbook. User are giving fiscalweek in selection of the report.

Regards

Sunny

[Former Member · Accepted solution]

Hi Sunny Kumar,

Use Text variable 'processing by' replacement path & 'reference characteristic' calweek, in the query description.

Regards,

Priya

[Former Member · Accepted solution]

Hi Priya/ Parvinder,

I have created a text variable and used calweek in replacementpath. Although it is appearing in description by executing query in Bex. But in work book it is not appearing any where.

Please suggest

[Former Member · Accepted solution]

Hi Priya/ Parvinder,

I have created a text variable and used calweek in replacementpath. Although it is appearing in description by executing query in Bex. But in work book it is not appearing any where.

Please suggest

[Pravender · Accepted solution]

Are you able to see workbook name (Query name) in the heading?

[Former Member · Accepted solution]

Hi,

If it is not a workbook based on Standard SAP template, include a text element in workbook and check 'Query Description' in its properties.

Regards,

Priya

[Former Member · Accepted solution]

Hi

No I am unable to see. Can you guide me how to getr that name in workbook.Any setting is required

Sunny

[Pravender · Accepted solution]

Refresh your query/report. In Bex analyser, there is one toolbar named BEx design toolbox, If you are not able to see it in analyser, right click on the toolbar space of BEx analyser and click on BEx design toolbox. Here, goto to design mode, by clicking on a symbol like 'A'. after that place the curser where you want to see the Last refreshed value. and click on insert text (T) in BEx toolbox. click on it and check "Query Description" in constant tab. in the general tab you need to assign a dataprovider, for that assign your query name in workbook settings (in Bex design toolbox). also check the "display caption" in general tab.

[Former Member · Accepted solution]

Hi,

If it is not a workbook based on Standard SAP template, include a text element in workbook and check 'Query Description' in its properties.

Regards,

Priya

[Former Member · Accepted solution]

Thanks Priya and Priyadarsha. It solved my problem

Regards

Sunny

[Pravender]

Yes.. If you will create a text element for the selection then you can display it.