The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

JamesRees's avatar
JamesRees
New Contributor III
2 years ago
Solved

Date filter not working on row override in Cube View

Hi - I am having issues with using the PriorPeriod12() in a row override. The following filter is supposed to use the PriorPeriod12() function to return the same month last year (e.g. input of 2023M1...
Cube View
Parameters
Reports
  • db_pdx's avatar
    db_pdx
    2 years ago

    Try: T#[PeriodPrior12(|!Param_Select_Time!|)].  Notice the extract square brackets [ ].

JamesRees's avatar
JamesRees
New Contributor III
2 years ago

Thanks NicolasArgente. Noted on the divide function. Tried both Global time and WF time but with the same issue. It works fine in the Cube View filters... it's just on the overrides that it's providing a problem.

db_pdx's avatar
db_pdx
Valued Contributor
2 years ago

Try: T#[PeriodPrior12(|!Param_Select_Time!|)].  Notice the extract square brackets [ ].

  • JamesRees's avatar
    JamesRees
    New Contributor III
    2 years ago

    Thanks db_pdx  - that solved it.