1
Vote

pc dim doesn't show

description

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.

comments

furmangg wrote Aug 29, 2013 at 7: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.

https://bidshelper.codeplex.com/wikipage?title=Parent-Child%20Dimension%20Naturalizer&referringTitle=Documentation

roguefem wrote Aug 29, 2013 at 9: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.