June 11, 2023 at 2:16 am
I have 2 identical fact tables:
Fact 1: linked to datetime dimensnion
Fact 2: is not linked to datetime dimension
I had to do it to disbale datetime filter for particular chart/grid in the dashboard (requirement by business).
I have another grid desigend out of both fact tables, from Fact1 to display data, and from Fact2 to color code meaasures.
When I filter by datetime, its still showing out of range rows, because data from Fact2 is being pulled out as well, but color codings are empty.
Would it be possible to make the cube to follow granularity of Fact1 and Fact2 also follows somehow?
I know its weird question, just being optimistic.
June 11, 2023 at 6:56 pm
are you using Tabular or Multi-dimensional?
in tabular, you don't need a separate date table. Just use ALL() to remove whatever filters you want from the evaluation context.
June 13, 2023 at 4:15 am
It's multidimensional. And for the front end using Devexpress dashboard. All this workarounds are mostly because tool doesn't have option to show/hide nulls by default
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply