I have ItemSales fact table. I have fact dimension Item Sale Transaction Information. Key is EntryNo, it also has attributes DocumentDate, DocumentNo, Description.
The problem is, that while this dimension works fine in browser, it's not possible to add it to excel. Whenever I try to drag and drop it to rows or columns, it tries to execute query, but then it disappears again. If I try to check the checkbox next to
it, it shortly appears checked, but then disappears again. Oh, and this only happens for EntryNo, that is Key attribute. Adding any other attribute works as expected.
Strange thing is, I have another measure group with similar dimension, and it works fine there.
I've even tried recreating the dimension..
View Complete Post