FilesExpand file tree

 master

/

example_create_dimension.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

34 lines (32 loc) · 1.62 KB

 master

/

example_create_dimension.sql

Copy path

Top

File metadata and controls

• Code
• Blame

34 lines (32 loc) · 1.62 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

-- +----------------------------------------------------------------------------+

-- | Jeffrey M. Hunter |

-- | jhunter@idevelopment.info |

-- | www.idevelopment.info |

-- |----------------------------------------------------------------------------|

-- | Copyright (c) 1998-2015 Jeffrey M. Hunter. All rights reserved. |

-- |----------------------------------------------------------------------------|

-- | DATABASE : Oracle |

-- | FILE : example_create_dimension.sql |

-- | CLASS : Examples |

-- | PURPOSE : Example SQL script to create a dimension object. |

-- | NOTE : As with any code, ensure to test this script in a development |

-- | environment before attempting to run it in production. |

-- +----------------------------------------------------------------------------+

CREATE DIMENSION dim_clothes

LEVEL upc IS retail_tab.upc

LEVEL style IS retail_tab.style

LEVEL class IS retail_tab.class

LEVEL department IS retail_tab.department

LEVEL store IS retail_tab.store

LEVEL region IS retail_tab.region

LEVEL company IS retail_tab.company

HIERARCHY sales_rollup (

upc CHILD OF

style CHILD OF

class CHILD OF

department CHILD OF

store CHILD OF

region CHILD OF

company)

ATTRIBUTE style DETERMINES (color)

ATTRIBUTE upc DETERMINES (item_size);