MicroStrategy v7.2.2
Report requires "Preserve lookup table elements joined to final pass result table based on template attributes w/filter" checked. Not sure if this is an impact, but due to having a report totals metric repeated across all rows, I also have the "Downward Outer Join Option" set to "Preserve all the rows for metrics higher than template level with report filter"
When filtering and drilling across or down, report needs to show only rows with fact table entries for those attributes selected by the user.
So far, I have not been successful...report still continues outer join into drilled results, resulting in all rows from all lookup tables returned.
Is this going to require a customized drill map or have I missed something ?
Best regards,
dmcmunn
Report requires "Preserve lookup table elements joined to final pass result table based on template attributes w/filter" checked. Not sure if this is an impact, but due to having a report totals metric repeated across all rows, I also have the "Downward Outer Join Option" set to "Preserve all the rows for metrics higher than template level with report filter"
When filtering and drilling across or down, report needs to show only rows with fact table entries for those attributes selected by the user.
So far, I have not been successful...report still continues outer join into drilled results, resulting in all rows from all lookup tables returned.
Is this going to require a customized drill map or have I missed something ?
Best regards,
dmcmunn