Forum Discussion

RickJ's avatar
RickJ
New Contributor
11 months ago
Solved

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
    10 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
10 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
    10 months ago

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