Why FRS Range Function with Relative Member Offset Not Returning Expected Period Data

Summary:

We are encountering an issue in Financial Reporting Studio (FRS) while using the Range function with the Relative Member function to display Current Year (CY) and Previous Year (PY) accounting period data based on user-selected prompts.

We have defined two prompts:

Start Period: Enter Start AccountingPeriod
End Period: Enter End AccountingPeriod

For Current Year (CY), we are using the Range function with the above prompts.
For Previous Year (PY), we are using the Relative Member function with an offset of -14 on the same accounting period range.

Example:
Start Period: Jan-25
End Period: Mar-25

Expected Result:

CY: Jan-25, Feb-25, Mar-25