| Oracle9i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 |
|
Making Queries Using Source Methods, 2 of 8
You can create a new Source from an existing Source by selecting only certain values of the base Source. Typically, you use one of the following methods to select based on the values of the base values:
Source.select(BooleanSource), Source.selectValue(Source)Source.selectValues(Source)Source.selectValues(Source[])BooleanSource.selectValue(boolean)BooleanSource.selectValues(boolean[])NumberSource.selectValue(double)NumberSource.selectValue(int)NumberSource.selectValue(float)NumberSource.selectValue(short)NumberSource.selectValues(double[])NumberSource.selectValues(float[])NumberSource.selectValues(int[])NumberSource.selectValues(short[])StringSource.selectValue(String)StringSource.selectValues(String[])You can also select values using the join method using the syntax shown below.
Source Source::join (Source joined, Source comparison, Source.COMPARISON_RULE_SELECT, boolean visible);
Assume that you have a primary Source objects named timesDim that you created from an MdmDimension object named mdmTimesDim and whose values are the calendar values. To select only the those values for 1996, you can issue the code shown in Example 6-1
Source timesSel = timesDim.selectValue("1996");
|
![]() Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|