Hi,
I have two fact tables and three dimensions
Fact A Table
ColorKey
DateKey
LocationKey
coalesce(FactaColor,AnotherColumnFromFactATable) as Color
Sales
Fact B Table
ColorKey
DateKey
LocationKey
Sales
Amt
Dimensions
Dim_Color
Dim_Date
Dim_location
I have special requirement, where In Pivot Table chart, I need to use attribute/column from fact table A (here color column), but in the same chart, I need to bring measures from Fact A and Fact B.
I have created link table for Fact A and Fact B with three dimensions with common key column, I can create Pivot chart with multiple measure from A and B table, if I Choose Dimension column from Actual Dimensions table, but for my new requirment, I had to choose column Colour from Fact A Dimension instead of DIM_Colour.
I am looking to achieve something like
Sum({<FactA.ColourColoum.Fieldvalues = DimensionTable.ColourColum.FieldValue , Location= {'UK'}>}Sales)
This (FactA.ColourColoum) column is chosen in Pivot-chart Dimension
I am not sure whether is it possible or not. Could any have ideas, could you please share thoughts about it.
Many Thanks
