Forum Discussion

JacobH's avatar
JacobH
New Contributor II
2 years ago

How to have two time dimensions in a cube view

Hi all -

This is probably pretty basic, but I keep getting stumped.

Ultimately I have two monthly metrics I want to look at for each month for current year and prior year. I can get the current year rows set and working, but for some reason for the prior year rows, it shows me the full year data instead of the periodic, even when the cell POV shows "periodic" it fails to grab the month with the year.

set up like this:

 

The months are tied to the columns and the year is tied to the row. Any idea why my PY rows cannot recognize the month while the current year can?

Cube View
Reports
  • chul's avatar
    chul
    Contributor III
    2 years ago

    Hi Jacob, As you've pointed out, year is in the rows and months in the columns but those are one dimension in OS. You could probably accomplish what you're trying to do by keeping only the metric in the rows and using column overrides in your last two rows for the time dimension.