How can we improve Jedox Software?

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.

3 votes
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Rolands Kluss shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminJedox (Admin, Jedox AG) responded  · 

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.


Sign in
Signed in as (Sign out)

Feedback and Knowledge Base