Skip to main content
J
JacobH
December 19, 2023

How to have two time dimensions in a cube view

  • December 19, 2023
  • 2 replies
  • 0 views

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:

JacobH_0-1703013949433.png

 

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?

2 replies

C
chul
December 19, 2023

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.

N
NicoleBruno
December 26, 2023

Hi JacobH , 

Can you provide the time filters you're using for CY and PY? 

Terms & ConditionsAccessibility statement