Subset data filter based on multiple cubes
Example: you have two cubes - one with P&L data based on year/month (two separate dimensions), other one with P&L data based on rolling month (rolling from previous month)
The report needs to show P&L from current month + rolling column (which starts from previous month). It would be super useful to configure data filter to show Cost Points where are values in both cubes.
Since version 7.0, PALO.SUBSET formula supports specifying multiple DFILTER expressions. the formula has to be edited manually – the Subset Editor doesn’t support multiple DFILTER expressions. Please check the description in the Jedox Knowldge Base to see if this is sufficient for your requirement.