Date binding with two different cubes

Question

I have two cubes

• Computer engineering
• Ecological science.

Both cubes have the same Date dimension .

I have two scorecards, each for computer engineering and ecology, as shown in the following figure. I would like to get the result as shown.

I have a drop-down filter that uses a Date dimension from a computer engineering cube. This filter works great for filtering KPIs in the Scorecard Computer Engineering System since the Date measurement, and the measurements are from the same cube. But it cannot filter KPIs from the cube of environmental science, because the Date dimension in the filter and measures in KPI are two different cubes.

I have tried the following ideas.

• LinkMember. LinkMember MDX , . .
• LookupCube. LookupCube MDX , . Date .
• . , Date . , .

.

, . .

Answer 1

, . .

, :

:

:

, .

, .

, .