Forum Discussion

RickJ's avatar
RickJ
New Contributor
8 months ago

Setting one row in cube view to show prior year using column override

Apologies if this question has been answered elsewhere - I have been searching for a while but didn't find anything that solves my problem. I have a cube view with a single column whose member fil...
Cube View
Parameters
Reports
  • hiren's avatar
    hiren
    8 months ago

    I have not been able to successfully use member expansions in Row/Column overrides.
     
    Instead of having column override you could,

    • Create 12 separate columns (separate column for each month) with member filter as - T#|CVTime|M1,T#|CVTime|M2.....T#|CVTime|M12.
    • Add Row override to each column with member filter - for first month's column, T#PeriodPrior12(|CVTime|M1), for second month's column, T#PeriodPrior12(|CVTime|M2)..... so on..
hiren's avatar
hiren
New Contributor III
8 months ago

I have not been able to successfully use member expansions in Row/Column overrides.
 
Instead of having column override you could,

  • Create 12 separate columns (separate column for each month) with member filter as - T#|CVTime|M1,T#|CVTime|M2.....T#|CVTime|M12.
  • Add Row override to each column with member filter - for first month's column, T#PeriodPrior12(|CVTime|M1), for second month's column, T#PeriodPrior12(|CVTime|M2)..... so on..
  • RickJ's avatar
    RickJ
    New Contributor
    8 months ago

    Thanks, that did it! I used T#[YearPrior1(|CVTime|)]M1 in my row overrides.