Which type of measures can be seen in DYD tables
Which all types of measures (refresh with data enabled, Editable, expression based) can be checked in DYD table.
We have few measures which we have defined with expression using other measures for calculations. But dont find those in DYD table.
As a simple example, Gross Sales = nvl(Adjusted Sales, Shipments History).
We cannot see Gross Sales in DYD table, but Adjusted sales and shipments history can be seen there.
We do have other measures which are making use of complex expressions for calculation and want to build a report with them.
But not able to find those measures in DYD tables.