SSAS including table key as a browsable attribute.

Mr_Shaw
Mr_Shaw used Ask the Experts™
on
My cube is listing the logical key of a dimension as a browseable attribute.

For example my dimension called POD includes two attributes, ID and POD.

I am not interested in ID when browsing the cube, but ssas has included both.

Here is a screen shot.

I am using SQL 2005 BIDS.
Dimension-Multiple-Attributes-Q1.bmp
Dimension-Multiple-Attributes-Q2.bmp
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Dear Mr_Shaw,

go to your dimension definition,
remove the attribute pod,
set the name column value to pod.

Hope this helps...
Andreas

Author

Commented:
Where do I find the 'dimension definition'.

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial