Stuck with Data Modeling and synthetic keys issues
Hi i am stucked with a problem where there are two data sources attached sample data in Excel.
Calculation of measures:we need to have 6-dimensions of source A & B named same but 4 measures.sending excel please give best solution to calculate measures have use where exists to filter data and used inline tables for calculation
Your question is not so clear. I suppose you are having multiple problems. Can you try and break them in parts and also explain more about the data in the excel, e.g. what are dimensions and measures of interest.
Cell E22 to E25 and F22 to F25, what are these numbers ? And the conditions for Loss/Gain , how are we using that in the report ?