O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing members and member counts

It's important to understand the structure of the data in the cubes such as those in RDBMS tables. You can easily access the data from BI Administration Tool.

How to do it...

When you right-click on the cube, you'll see View Members. A new window pops up that will display the number of members. Also you're going to see the distinct values. This result set is accessed from the multidimensional source.

How to do it...

How it works...

BI Server generates an MDX query so that it displays the number of attribute values. MDX and SQL languages are used to query databases. SQL statements are used to construct a relational view. MDX generates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required