Home » RDBMS Server » Server Administration » PL/SQL cross-tab challenge
PL/SQL cross-tab challenge [message #370339] Mon, 30 August 1999 18:26 Go to next message
Luis Claudio
Messages: 5
Registered: July 1999
Junior Member
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>
Re: PL/SQL cross-tab challenge [message #370341 is a reply to message #370339] Tue, 31 August 1999 05:26 Go to previous messageGo to next message
Lars O Sjöström
Messages: 25
Registered: May 1999
Junior Member
I believe that there are som new features for Oracle 8i that supports this. A CUBE-keyword to the existing GROUP-keyword.

I think that does what you want, but I am not sure.
Re: PL/SQL cross-tab challenge [message #370342 is a reply to message #370339] Tue, 31 August 1999 07:07 Go to previous message
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
In principle you should be able to do this, after all - HTML is only text, so you can output what you like.

In practice, to make it generally applicable, you'll have to figure out how such a procedure could be invoked (where will it get its information from?) and what rules will it apply to decide what becomes a column and what becomes a row. The code will be pretty fiendish too!

In short, can PL/SQL generate this output? - Yes. Would I like to write it? - No!

Previous Topic: Re: hiding the character
Next Topic: Date bug in oracle?
Goto Forum:
  


Current Time: Sat Oct 24 04:52:22 CDT 2020