Forum Discussion

zach_myt's avatar
zach_myt
Data Pipeline
01-04-2024
Solved

Dimension filter on id not working correctly

I have a dashboard with a dimension filter. The dimension filter table is a list of organizations and the products associated with those organizations. I have a widget displaying organization and pro...
dashboards & reporting
data models
  • zach_myt's avatar
    zach_myt
    01-16-2024

    This was due to the dimension table not containing all values from the fact table. Our dimension table only list active data but the fact table also includes data that was active once but is now inactive. For now, my solution was to use widget level filtering. I believe in the future we will look to add the inactive data with another column to identify if the data is active or not.

david-h's avatar
david-h
Cloud Apps
01-13-2024
Copy Link

Hi Zach,

Your question can not be answered without having more context, especially data model and specific dashboard widgets related to your filters.

It reads like an issue called "random query path". Are you familiar with this concept ? Is you data model a pure star schema with only one fact table in the center of the model or a data model with several fact tables and dimension tables ? If this is the latest, are you following the best practise rules ? Basically:

  • link all dim to all facts,
  • masking the join fields from the fact table
  • always filter from dimensions and never use calculation from dimension (ex. : counting products from product id in the dim table instead of using one of the fact)

If you are using the JAQLine plugin ? It can translate a widget query into a visual diagram explaining the precise tables and joins involved in the query.

Let me know if this helps.

Best, David.