OBIEE 11g Dimension Browse

Posted on January 4, 2011 by Paul McGarrick
Filed Under 11g Repository, LTS, OBIEE 11g

Those of us who have used OBIEE 10g for some time and made the change to 11g will have noticed some subtle differences within the Administration tool. Sometimes these are not well documented, for example, the new “Dimension Browse” checkbox within the logical table source (LTS) dialog.

My understanding is that you should use this when you want to specify that your LTS can be used in queries which don’t include a Fact column. That is queries which hit only your dimension table.

The main use for this would be if you had a number of LTS making up a single logical table and you wanted to specify a particular one as containing the ‘master’, or more complete, data set.

In case you’re interested, this option is synonymous with the isDimOnly tag as generated in the repository definition XML.

Comments

2 Responses to “OBIEE 11g Dimension Browse”

  1. Anil on November 18th, 2011 2:07 pm

    nice explanation

  2. OBIEE 11g Dimension Browse Revisited | obieefans.com on January 25th, 2012 7:44 pm

    [...] blogged before about the Dimension Browse feature in the OBIEE Admin Tool. For the uninitiated, there is a [...]

Leave a Reply