I want to display TextElement in my Query as Fiscal Year Long Text
but it is displaying FiscalYearVariant Text and FiscalYear Key when i check Fiscal Year Text/Variable in filters
My Fiscal Year Varnt Text is APR - MAR
When FiscalYear Variable is 2009
then My Fiscal Year Long Text is APR 2009 - MAR 20010
I want to display this Long Text in this Text Element
but it is displaying as APR - MAR 2009
Even Though I selected Display as NoDIsplay in Business Explorer Tab for 0FISCVARNT.
can any one provide me the solution for this please.