1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to create facts using dll scripts

Discussion in 'SQL PL/SQL' started by ThdCo, May 31, 2016.

  1. ThdCo

    ThdCo Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Tunisia
    Hi,
    I want to create a data warehouse using DLL scripts. So, I define the tables dimensions and table facts and I add relationships between them. Then, I define dimensions with their levels, hierarchies and attributes. Now, I'm wondering how to define a fact (I have to define it as a cube or a materialized view). I'm really confused. Please would you please help me?
    N.B: The generated scripts are executed using OWB 11g.
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    In what at you specifically a problem?
     
  3. ThdCo

    ThdCo Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Tunisia
    I don't know how to create a fact on OWB 11g with DDL scripts.
     
    Last edited: May 31, 2016