I am facing an issue with the display of fiscal year variable for composite provider. Below is the detail of the issue.
I have 2 queries: Query 1 and Query 2
Query 1 is built on top of a Multiprovider
Query 2 is built on top of a Composite Provider
Except for the above 2 variation, rest all remains the same.
Both the query uses 0FISCYEAR and the same variable restriction. The display property is set to "Key" for both the queries.
However, when I execute the query,
For Query 1, the variable option for fiscal year is displayed as Key
For Query 2, the variable option for fiscal year is displayed as Text and Key
I want to display only Key. Please let me know how to fix this.