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
Vote
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.

0 comments

Sign in
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base