Skip to main content

Home/ Groups/ BI-TAGS
cezarovidiu

binami - 0 views

cezarovidiu

Unified Modeling Language (UML) - 0 views

shared by cezarovidiu on 14 Nov 14 - Cached
cezarovidiu

Oracle APEX Interactive report based on PLSQL function | Oracle Application Express - 0 views

  • Unfortunately Oracle have failed to allow the report to be based on a PLSQL function returning the query.
  • Step1.Create a collection based on a query. The code for this should be placed in a before header process APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY(p_collection_name => ‘IR_TEST’,p_query => function_returning_query );
  • Step 2.Create an interactive report querying a collection. Select *From apex_collectionsWhere collection_name = ‘IR_TEST’;
cezarovidiu

Creating Palo OLAP cubes and dimensions with Talend - 0 views

  • Creating Palo OLAP cubes and dimensions with Talend
  • Step 1: Create a Palo database with Talend tPaloDatabase
  • Step 2: Add Palo dimensions with tPaloDimension
  • ...3 more annotations...
  • Step 3: Create a Measures dimension
  • OLAP Measures in Palo are defined in a single dimension, with element values as measure names. For example to add a "PiceList" and "Quantity" measure we'll create a dimension named "Measures" with two numeric elements: "PriceList" and "Quantity".
  • Step 4: Create Palo OLAP Cubes with Talend tPaloCube
« First ‹ Previous 81 - 100 Next › Last »
Showing 20 items per page