Show Hidden Objects in the Calculations tab

Here’s a new button I’ve just noticed in the toolbar on the Calculations tab in BIDS 2008: Show Hidden Objects. Quite often when you’re writing MDX you want to reference hierarchies that are hidden to the end user, and in BIDS 2005 you had to unhide them to be able to see them (and so find out their unique name) in the metadata pane, which was a pain; now in BIDS 2008 you just need to click the new ‘Show Hidden Objects’ button to be able to see them. For some bizarre reason it doesn’t seem to allow me to see hidden sets or calculated members though – why?


2 responses

  1. …and in MDX Studio hidden objects are always shown, but with grayed out colors. I cannot imagine when you won\’t want to see hidden objects in the calculation tab.

  2. Pingback: The Show Hidden Cubes SSAS Connection String Property – Chris Webb's BI Blog

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: