Dynamic Text Heading

Hi All,

We want to show the dynamic text heading in our Webi reports based on the fiscal period the report is run for. We have MAT, YTD & TM figures in the report so we can not simply use the fiscal period coming from SAP BW as it returns the array of fiscal periods. We have prompts on fiscal period but that is populated with default values in BW so we can't use the prompt values either.

Has anyone worked with dynamic text before? We are using XI 3.1 and BI7.0 version of BW.

Let me know if you need more information to help me with this?

Thanks

SS