Comparing variables with different time dimensions

[#1]

Hello!

I am having problems with comparing variables that have different time dimensions.

I am trying to divide the sum of one variable X with the sum of another Y over time. But one of them have X.year and the other one have Y.year so I can not use the same time variable since they are not both connected to it.

Please help me out

/Johan

[#2]

Hi Johan,

Can you provide more details about the issue.

Regards

Rajesh

[Miguel_Angel_Baeyens]

Hello Johan,

I would recommend you to create a Master Calendar so you will have all your dates in the same dimension, an easier to query.

There are a lot of posts in the forum about how to get it done, but you can use this post and this wiki.

Regards.