SSAS Filters - Greyed Out - Excel

All replies

• 

  

  1

  Sign in to vote

  That approach won't work.

  It can be corrected in the design of the cube though, If you build it into a hierarchy on the Dimension.

  Hierarchy:

  City Hierarchy

  --Country - USA

  ----City New York

  ---- City Los Angeles

  ---- City Washington

  --Country - South Africa

  ---- City Durban

  ---- City Cape Town

  ---- City Johannesburg

  If you combine the country and city filters into 1 on the dimension through a Hierarchy, you could achieve something similar ie expand Country - South Africa and below that you will see only South African cities.

  Monday, July 08, 2013 7:25 PM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  Thanks for the reply. what if the values are not related and we cannot put it in hieararchy?

  Example:

  

  Monday, July 08, 2013 7:35 PM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  I'm not quite sure that I understand, but I don't think you can get it right without doing some sort of vba code in the background on excel. I'm not too sure if its worth the effort though.

  • Proposed as answer by Elvis LongMicrosoft contingent staff, Moderator Monday, July 15, 2013 9:00 AM
  • Marked as answer by Elvis LongMicrosoft contingent staff, Moderator Friday, July 19, 2013 10:12 AM

  Monday, July 08, 2013 7:59 PM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  Hi SSISQ,

  I agree with Duane's option. Furthermore, it seems your issue is more related to Excel functionality. So, you can try to post your question in Excel IT Pro Discussions forum: 
  http://social.technet.microsoft.com/Forums/office/en-US/home?filter=alltypes&sort=lastpostdesc&brandIgnore=true

  Best Regards,
  Bin Long

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked as answer by Elvis LongMicrosoft contingent staff, Moderator Friday, July 19, 2013 10:12 AM

  Monday, July 15, 2013 9:00 AM

  Reply

  |

  Quote

  Moderator