Hi folks,
I need someone to help me about a PL/SQL cross-tab generator construction for data warehouse viewing using the OWAS packages.
Put this HTML code in your web browser and answer the question : can a PL/SQL procedure generate this output, no matter how many dimensions I have in the fact table?
(In this example, D1/D2/D3/D4 are viewing dimensions and [[a,b,c,d]] are combinations of them).
Thanks for any cooperation on this.
Luis Claudio
TRE-GO
<HTML>
<HEAD>
<TITLE>CrossTab challenge</TITLE>
</HEAD>
<BODY>
- Decision Cube -
- value1 (D3) -
- value2 (D3) -
- value1 (D4) -
- value2 (D4) -
- value1 (D4) -
- value2 (D4) -
- value1 (D1) -
- value1 (D2) -
- 1,1,1,1 -
- 1,1,1,2 -
- 1,1,2,1 -
- 1,1,2,2 -
- value2 (D2) -
- 1,2,1,1 -
- 1,2,1,2 -
- 1,2,2,1 -
- 1,2,2,2 -
- value3 (D2) -
- 1,3,1,1 -
- 1,3,1,2 -
- 1,3,2,1 -
- 1,3,2,2 -
- value4 (D2) -
- 1,4,1,1 -
- 1,4,1,2 -
- 1,4,2,1 -
- 1,4,2,2 -
- value2 (D1) -
- value1 (D2) -
- 2,1,1,1 -
- 2,1,1,2 -
- 2,1,2,1 -
- 2,1,2,2 -
- value2 (D2) -
- 2,2,1,1 -
- 2,2,1,2 -
- 2,2,2,1 -
- 2,2,2,2 -
- value3 (D2) -
- 2,3,1,1 -
- 2,3,1,2 -
- 2,3,2,1 -
- 2,3,2,2 -
- value4 (D2) -
- 2,4,1,1 -
- 2,4,1,2 -
- 2,4,2,1 -
- 2,4,2,2 -
- value3 (D1) -
- value1 (D2) -
- 3,1,1,1 -
- 3,1,1,2 -
- 3,1,2,1 -
- 3,1,2,2 -
- value2 (D2) -
- 3,2,1,1 -
- 3,2,1,2 -
- 3,2,2,1 -
- 3,2,2,2 -
- value3 (D2) -
- 3,3,1,1 -
- 3,3,1,2 -
- 3,3,2,1 -
- 3,3,2,2 -
- value4 (D2) -
- 3,4,1,1 -
- 3,4,1,2 -
- 3,4,2,1 -
- 3,4,2,2 -
- value4 (D1) -
- value1 (D2) -
- 4,1,1,1 -
- 4,1,1,2 -
- 4,1,2,1 -
- 4,1,2,2 -
- value2 (D2) -
- 4,2,1,1 -
- 4,2,1,2 -
- 4,2,2,1 -
- 4,2,2,2 -
- value3 (D2) -
- 4,3,1,1 -
- 4,3,1,2 -
- 4,3,2,1 -
- 4,3,2,2 -
- value4 (D2) -
- 4,4,1,1 -
- 4,4,1,2 -
- 4,4,2,1 -
- 4,4,2,2 -
</BODY>
</HTML>
|