Select same week from two tables

[YJ_SG]

I have two tables with same week but dimension names are not same. (Can not rename to same, because it will cause synthetic problems.)

One Sales_Week, one Supplier_Week. I have to choose 202026 from Sales_Week, then choose 202026 again from Supplier_Week to have a same view. Is there any way to choose once instead of choose twice?

[Vegar · Accepted solution]

I see three possible solutions

1. Make selection in one dimension and apply these selections in an set analysis expression for the other dimension.

Eg. Make selection in sales week and calculate with set on Supplier week. Sum({<SupplierWeek=P(SalesWeek)>}Amount 

2. Create a data Island calendar that is not attached to the data model and do a similar approach as above for calculations.

Sum({<SupplierWeek=P(IslandWeek),SalesWeek=P(IslandWeek)>}Amount

3. Work with onSelection triggers intin the document totto selections in one field when done in another.

[YJ_SG]

Hi  Vegar,

Prefer option 2. It works well for me.

2. Create a data Island calendar that is not attached to the data model and do a similar approach as above for calculations.

Sum({<SupplierWeek=P(IslandWeek),SalesWeek=P(IslandWeek)>}Amount