multiple rate tables in one plan

Summary:

Can we use the multiple rate tables in one plan?

Content (please ensure you mask any confidential information):

We are following the below approach

Rate table1= and for this 2 rate dimensions are there -> dimension1 & dimension2

Rate table2 = and for this we 1 dimension is there -> Dimesion1

When we attach the Rate table1 & Rate Table2 into the plan , it is saying that date should not be overlap.

If we change the date transaction will consider the rate table which falls in right, but here we need to use two rate tables how can we?

Rate table 1 output Should be the input of Rate table2 is this possible?