I have an issue with getting my dimension set up properly. Basically I have a fact table that holds details on events. Each event can be categorized, but at different levels. I have a category dimension that holds all the categories, subcategories. There are three levels of categories. Some categories have subcategories while others do not.
When I'm browsing the dimension I get drill downs for each item but the drill-downs sometimes end up displaying blank items(blue circle, no text).
So I guess I have a category dimension that is holding categories of different granularity.
I have been playing around with the settings for NULL processing and UnknownMember without really understanding fully how it affects things.
Perhaps someone out there can give me a few tips or advice on the issue.
I'm using SQL Server 2012
Thanks
Yes, this is a ragged hierarchy. The simplest solution is that if a node is null, copy it's parent key / caption down to it.