Re: Fw: [indo-oracle] help : query matrix

Mon, 13 Apr 2009 02:44:55 -0700 

coba baca2x disini mungkin bisa membantu
http://tonyandrews.blogspot.com/2004/10/pivot-queries.html


> Wah...kok tampilannya malah jadi aneh yaa..padahal sudah dibuat table2nya.
> Berikut saya rapihkan kembali sumber data dan hasil yang diinginkan :
>
> Sumber data :
> ---------------------------------------------------------------------
> Company Asal      Company Tujuan    Nilai
> ---------------------------------------------------------------------
> Company A          Company B            1000
> Company A          Company C              100
> Company B          Company A             1000
> Company B          Company C             0
> Company C          Company A             100
> Company C          Company B             0
> ----------------------------------------------------------------------
>
> Hasil yang diinginkan :
> ---------------------------------------------------------------------------------------------------
> Description       Company A          Company
> B          Company C
> ---------------------------------------------------------------------------------------------------
> Company A             
> 0                     
> 1000                       100
> Company B        
> 1000                         
> 0                         0
> Company C          
> 100                        
> 0                         0
> ---------------------------------------------------------------------------------------------------
>
> Regards
>
> IH
>
>
> --- On Mon, 4/13/09, Izzudin Hanafie <[email protected]> wrote:
>
> From: Izzudin Hanafie <[email protected]>
> Subject: [indo-oracle] help : query matrix
> To: [email protected]
> Date: Monday, April 13, 2009, 4:58 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dear Guru’s,
>
>
>
>  
>
>
>
> Saya mempunyai problem membuat query matrix dari data
>
> berikut :
>
>
>
>  
>
>
>
> Company
>
>   Asal
>
>
>
>
>
>   Company
>
>   Tujuan
>
>
>
>
>
>   Nilai
>
>
>
>
>
>
>
>
>
>   Company A
>
>
>
>
>
>   Company B
>
>
>
>
>
>   1000
>
>
>
>
>
>
>
>
>
>   Company A
>
>
>
>
>
>   Company C
>
>
>
>
>
>   100
>
>
>
>
>
>
>
>
>
>   Company B
>
>
>
>
>
>   Company A
>
>
>
>
>
>   1000
>
>
>
>
>
>
>
>
>
>   Company B
>
>
>
>
>
>   Company C
>
>
>
>
>
>   0
>
>
>
>
>
>
>
>
>
>   Company C
>
>
>
>
>
>   Company A
>
>
>
>
>
>   100
>
>
>
>
>
>
>
>
>
>   Company C
>
>
>
>
>
>   Company B
>
>
>
>
>
>   0
>
>
>
>
>
>
>
>                       
>
> Sumber data
>
>
>
>  
>
>
>
> Saat ini untuk mengeluarkan data tersebut dilakukan dengan
>
> melakukan grouping per company lalu dilakukan join, masalahnya yaitu
> terdapat
>
> 46 entitas company untuk membuat tampilan matrix seperti dibawah.
> Sepertinya terlalu
>
> kompleks bila dibuat grouping per company sebanyak 46 buah.
>
>
>
>  
>
>
>
> Description
>
>
>
>
>
>   Company A
>
>
>
>
>
>   Company B
>
>
>
>
>
>   Company C
>
>
>
>
>
>
>
>
>
>   Company A
>
>
>
>
>
>   0
>
>
>
>
>
>   1000
>
>
>
>
>
>   100
>
>
>
>
>
>
>
>
>
>   Company B
>
>
>
>
>
>   1000
>
>
>
>
>
>   0
>
>
>
>
>
>   0
>
>
>
>
>
>
>
>
>
>   Company C
>
>
>
>
>
>   100
>
>
>
>
>
>   0
>
>
>
>
>
>   0
>
>
>
>
>
>
>
>  
>
>
>
>                        Hasil yang diharapkan
>
>
>
>  
>
>
>
> Apakah
>
> ada cara lain untuk membuat query report tersebut yang lebih simple ?.
>
>
>
>  
>
>
>
>  
>
>
>
> Mohon
>
> bantuannya,
>
>
>
> Regards,
>
>
>
>  
>
>
>
> Izzudin
>
> hanafie
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>

Kirim email ke