I have a cube with multiple fact tables. I am trying to browse and see
details with a dimension from my first Fact table as columns and another
dimension from my second Fact table as rows. How do I do this?

For example, I have 2 Fact tables, Fact_A & Fact_B.
I have a shared dimension DIM_main_ID (The column ‘main_ID’ is existing in
all Fact tables)
I have 3 DIMs associated with Fact_A (DIM_A1, DIM_A2, DIM_main_ID) & 3 DIMs
associated with Fact_B (DIM_B1, DIM_B2, DIM_main_ID)

I need to cross pivot these 2 fact tables, in the following way.

I have to select DIM_A1 as COLUMN & select DIM_B1 as ROW. In order to get
the correct value at the “details” area, which count should be dragged on the
Details area? Fact_A count or Fact_B count or Both? What I need is the
intersection of these two FACT tables for the given Dimensions, based on
‘main_ID’

Please help.