Left Outer Join Plugin

[andrew]

Hi all,

I've installed the plugin from here:
https://support.sisense.com/kb/en/article/include-all-dimension-values-left-outer-join

This does what I want in that it shows all dimensions including ones with no values. Two issues I have are that it breaks the exports to excel and csv. All values come out as 1000 and not the ons in the pivot. Secondly I'd like to show a 0 in place of a n/a value.

Any ideas?

Thanks,
Andrew

[Anonymous]

Hi Andrew

The outer join plugin has many limitations and should be used with caution. On small result sets < 50k records. It does not support the export to excel / csv plugin. This functionality is definitely being considered  by product. I would urge you to submit a feature request to formalize it into the roadmap.