pc dim doesn't show


I'm using the user interface, but my dimension doesn't appear in the dropdown. Does anybody know why that might happen? I'm not sophisticated enough to run otherwise.


furmangg wrote Aug 29, 2013 at 8:02 PM

In case this helps you, the Parent-Child Dimension Naturalizer is also built into BIDS Helper. You might try it and see if it allows you to naturalize your dimension. If the menu option doesn't show up, it may not be a parent-child dimension.


roguefem wrote Aug 29, 2013 at 10:47 PM

Thank you. My dimension is in the Parent-Child format, but it won't import into SSAS because there are many duplicate members. So the dimension naturalizer took won't work for me.