I have a cube with dimension 0MATERIAL. I have a query which refers to this cube. When i display my ratio and it's added as an navigational attribute, it shows me UNASSIGNED, even when i display with key and text. If I check the table of the data master of 0MATERIAL has all the materials i'm trying to display. The texts of all materials are loaded too.
Any idea why i'm having this problem.
Points for helpful answers.