Hi,
We have our sales cube in SSAS and I'am trying to set up a role and set permissions on dimensions. To select only data pertaining to one particular sales-rep.. however, when I bring up the data for the dimension, it gives me this error
Error retrieving children: the [sales rep].[sales manager] object was not found. Parameter name: unique name
Now, if I select this dimension under the database dimensions and not under the specific cube dimensions, I see the data.
Thanks,