Forum Discussion
Visualizing hierarchical data
Hello. I have some problems visualizing data in a hierarchical format. I have tried to show the data in the tables below. Process Hierarchies Process Name Level 0 Level 1 Level 2 Level 3 ...
Check your data model and try to get rid of Cross filters going in Both directions. Also, try replacing "null" or blanks with something meaningful like "not applicable" or "n/a".
Hi MNedix. Thanks for your reply. There is no cross filtering. The relationship is a simple one to many from the hierarchy dimension to the fact table.
Regarding the blanks: I have found that the blanks actually show the value that I want to be shown at the level above it. This leads me to the think that I need to change some things in the underlying sql, but not sure exactly