How to build queries on custom measures
Summary:
I need to build queries to create reports those search for custom measures data
I could create data set to search for dynamic tables (Query 1) and measures (Query 2) but I couldn't figured out how to relate dynamic tables and measures and get results like this:
Content (required):
I need to create a report with the following information:
1 - Item
2 - Organization
3 - Customer
4 - Demand Class
5 - Custom Measure 1
6 - Custom Measure 2
n - Custom Measure n
n+1 - Date
Entity_Id = 135
dynamic Table = MSC_DATA_44102_DYD
Custom Measure 1 measure_300000004338693
Custom Measure 2 measure_300000004338566
** I already followed some steps to get this information