Package oracle.olapi.data.cursor

Examples of oracle.olapi.data.cursor.ValueCursor

76
77
78
79
80
81
82
83
84
85
86
    {
      // The Creating a Cursor example.
      creatingACursor(querySource);

      // The Getting a Single Value from a ValueCursor example.
      ValueCursor prodValues = gettingASingleValue(mdmProdHier);

      // The Getting All of the Values from a ValueCursor example.
      getAllValues(prodValues);

      // The Getting ValueCursor Objects from a CompoundCursor example.
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
                 dp.createCursorManagerSpecification(prodSource);
    SpecifiedCursorManager cursorMngr =
                 dp.createCursorManager(cursorMngrSpec);
    // Because the Source has no outputs, the Cursor for it
    // is a ValueCursor.
    ValueCursor prodValues = (ValueCursor) cursorMngr.createCursor();
    // Set the position to the fifth element of the ValueCursor.
    prodValues.setPosition(5);

    // Product values are strings. Get the String value at the
    // current position.
    String value = prodValues.getCurrentString();

    // Do something with the value, such as display it.
    println(value);
    // Close the SpecifiedCursorManager.
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
                   dp.createCursorManager(cursorMngrSpec);
    CompoundCursor unitsForSelCursor =
                   (CompoundCursor) cursorMngr.createCursor();

    // Get the base ValueCursor.
    ValueCursor specifiedUnitsVals = unitsForSelCursor.getValueCursor();

    // Get the outputs.
    List outputs = unitsForSelCursor.getOutputs();
    ValueCursor chanSelVals = (ValueCursor) outputs.get(0);
    ValueCursor timeSelVals = (ValueCursor) outputs.get(1);
    ValueCursor custSelVals = (ValueCursor) outputs.get(2);
    ValueCursor prodSelVals = (ValueCursor) outputs.get(3);

    // You can now get the values from the ValueCursor objects.
    // When you have finished using the Cursor objects, close the
    // SpecifiedCursorManager.
    int i = 1;
    do
    {
      println(i + ": " +
              chanSelVals.getCurrentString() + ", " +
              timeSelVals.getCurrentString() + ", " +
              custSelVals.getCurrentString() + ", " +
              prodSelVals.getCurrentString() + ", " +
              specifiedUnitsVals.getCurrentValue());
      i++;
    }
    while(unitsForSelCursor.next());
View Full Code Here
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
    CompoundCursor rootCursor = (CompoundCursor) cursorMngr.createCursor();

    // Get the outputs and the ValueCursor.
    List outputs = rootCursor.getOutputs();
    // The first output has the values of timeSel, the slower varying output.
    ValueCursor rowCursor = (ValueCursor) outputs.get(0);
    // The second output has the faster varying values of prodSel.
    ValueCursor columnCursor = (ValueCursor) outputs.get(1);
    // The base ValueCursor has the values from unitPrice.
    ValueCursor unitPriceValues = rootCursor.getValueCursor();

    // Display the values as a crosstab.
    println("\t        PRODUCT_AW");
    println("\t-----------------------");
    print("Month");
    do
    {
      String value = ((ValueCursor) columnCursor).getCurrentString();
      print("\t" + getContext().getLocalValue(value) + "  ");
    }
    while (columnCursor.next());
    println("\n-----\t-------\t-------\t-------");

    // Reset the column Cursor to its first element.
    columnCursor.setPosition(1);

    do
    {
      // Print the row dimension values.
      String value = ((ValueCursor) rowCursor).getCurrentString();
      print(getContext().getLocalValue(value) + "\t");
      // Loop over columns.
      do
      {
        // Print the data value.
        print(unitPriceValues.getCurrentValue() + "\t");
      }
      while (columnCursor.next());

      println();
View Full Code Here
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
    // Create the CursorManager and the Cursor.
    SpecifiedCursorManager cursorMngr = dp.createCursorManager(cursorMngrSpec);
    CompoundCursor rootCursor = (CompoundCursor) cursorMngr.createCursor();

    // Get the child Cursor objects.
    ValueCursor baseValCursor = rootCursor.getValueCursor();
    List outputs = rootCursor.getOutputs();
    ValueCursor chanSelVals = (ValueCursor) outputs.get(0);
    ValueCursor timeSelVals = (ValueCursor) outputs.get(1);
    ValueCursor custSelVals = (ValueCursor) outputs.get(2);
    ValueCursor prodSelVals = (ValueCursor) outputs.get(3);
   
    // Set the position of the root CompoundCursor.
    rootCursor.setPosition(15);

    // Get the values at the current position and determine the span
    // of the values of the time and product outputs.
    print(chanSelVals.getCurrentValue() + ", ");
    print(timeSelVals.getCurrentValue() + ", ");
    print(custSelVals.getCurrentValue() + ", ");
    print(prodSelVals.getCurrentValue() + ", ");
    print(baseValCursor.getCurrentValue());
    println();

    // Determine the span of the values of the two fastest varying outputs.
    long span;
    span = ((prodSelVals.getParentEnd() - prodSelVals.getParentStart()) +1);
    println("The span of " + prodSelVals.getCurrentValue() +
            " at the current position is " + span + ".");
    span = ((timeSelVals.getParentEnd() - timeSelVals.getParentStart()) +1);
    println("The span of " + timeSelVals.getCurrentValue() +
            " at the current position is " + span + ".");
View Full Code Here
677
678
679
680
681
682
683
684
685
686
687
  {
        CursorManagerSpecification cursorMngrSpec =
                dp.createCursorManagerSpecification(source);
        SpecifiedCursorManager cursorManager =
                dp.createCursorManager(cursorMngrSpec);
        ValueCursor valueCursor = (ValueCursor) cursorManager.createCursor();
       
        cpw.printTopBottomResult(valueCursor);
       
        // Close the CursorManager.
        cursorManager.close();
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
      }
   
      tp.commitCurrentTransaction();
           
      CursorManager cmngr = dp.createCursorManager(shortDescrForMember);
      ValueCursor valCursor = (ValueCursor) cmngr.createCursor();
           
      String shortDescrForMemberVal = valCursor.getCurrentString();
           
      if(firsttime)
      {
        shortDescrForMemberVals.append(shortDescrForMemberVal);
        firsttime = false;
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
    do
      {
      if(rootCursor instanceof CompoundCursor){
        CompoundCursor compoundCursor = (CompoundCursor)rootCursor;
        LazyDynaBean ldb = null;
        ValueCursor valueCursor = compoundCursor.getValueCursor();
        if (valueCursor.hasCurrentValue()) {
          ldb = new LazyDynaBean();
          ldb.set("text", valueCursor.getCurrentValue());
        }
        
        List<Cursor> oList = compoundCursor.getOutputs();
        for(int i=0;i<oList.size();i++){
          Cursor cursor = oList.get(i);
          if(cursor instanceof ValueCursor){
            valueCursor = (ValueCursor)cursor;
            if(valueCursor.hasCurrentValue()){
              ldb.set("id", valueCursor.getCurrentValue());
              result.add(ldb);
            }
          }
        }
      }
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
    do
      {
      if(rootCursor instanceof CompoundCursor){
        CompoundCursor compoundcursor = (CompoundCursor)rootCursor;
        LazyDynaBean ldb = null;
        ValueCursor valueCursor = compoundcursor.getValueCursor();
        if (valueCursor.hasCurrentValue()) {
          ldb = new LazyDynaBean();
          ldb.set("value", valueCursor.getCurrentValue());
          ldb.set("valueID", measureName);
        }else{
          ldb = new LazyDynaBean();
          ldb.set("value", 0);
          ldb.set("valueID", measureName);
//          continue;
        }
        
        List<Cursor> oList = compoundcursor.getOutputs();
        if(oList!=null&&dimNames!=null&&oList.size()==dimNames.size()){
          for(int i=0;i<oList.size();i++){
            Cursor cursor = oList.get(i);
            if(cursor instanceof CompoundCursor){
              CompoundCursor compoundCursor = (CompoundCursor)cursor;
              setBeanAttribute(ldb,dimNames.get(i),compoundCursor);
            }
          }
        }
        result.add(ldb);
      }else if(rootCursor instanceof ValueCursor){
        ValueCursor valueCursor = (ValueCursor)rootCursor;
        System.out.println(valueCursor);
      }
     
      }
      while(rootCursor.next());
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
  private static void setBeanAttribute(LazyDynaBean bean,String name,CompoundCursor compoundCursor){
    if(bean==null||compoundCursor==null){
      return;
    }
//    List<Cursor> outputs = compoundCursor.getOutputs();
    ValueCursor value = compoundCursor.getValueCursor();
    if(value.hasCurrentValue()){
      bean.set(name, value.getCurrentValue());
      List<Cursor> outputs = compoundCursor.getOutputs();
      if(outputs!=null&&outputs.size()==1){
        Cursor output = outputs.get(0);
        if(output instanceof ValueCursor){
          ValueCursor outputValue = (ValueCursor)output;
          bean.set(name+"ID", outputValue.getCurrentString());
        }
      }
    }else{
      List<Cursor> outputs = compoundCursor.getOutputs();
      if(outputs!=null&&outputs.size()==1){
        Cursor output = outputs.get(0);
        if(output instanceof ValueCursor){
          ValueCursor outputValue = (ValueCursor)output;
          String outString = outputValue.getCurrentString();
          Log.error(outString+" has no short description");
          if(outString.indexOf("::") > 0)
                {
                    int index = outString.lastIndexOf("::");
                    outString = outString.substring((index + 2),
                        outString.length());
                }
          bean.set(name, outString);
          bean.set(name+"ID", outputValue.getCurrentString());
        }
      }
    }
  }
View Full Code Here
TOP

Related Classes of oracle.olapi.data.cursor.ValueCursor

  • com.narirelays.ems.olap.context.Context10g
  • com.narirelays.ems.olap.context.CursorPrintWriter
  • com.narirelays.ems.olap.OlapService
  • com.narirelays.ems.olap.sample.chapter10.SingleSelectionTemplate
  • com.narirelays.ems.olap.sample.chapter8.CursorConceptsExamples
  • com.narirelays.ems.olap.sample.chapter9.RetrievingQueryResults
  • com.narirelays.ems.olap.sample.Context10g
  • com.narirelays.ems.olap.sample.CursorPrintWriter
  • com.narirelays.ems.olap.test.RetrievingQueryResults_EMS
  • com.narirelays.ems.olap.test.RetrievingQueryResults_GLOBALAW
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.