®y¼Ð¶b¯Á¤Þ¼ÐÅÒ (¹Ïªí±M®a)
[®y¼Ð¶b] ¯Á¤Þ¼ÐÅÒ¥iÅý±z³]©w¨C¤@ӹϪí®y¼Ð¶bªº¤º®e¡A[®y¼Ð¶b] ¯Á¤Þ¼ÐÅÒ·|®Ú¾Ú«Ø¥ß¹ÏªíªºÃþ«¬¦ÓÅܧó¡C
¦pªGn [¹Ïªí±M®a] ¨Ï¥Î [®y¼Ð¶b] ©M [¿ï¶µ] ¯Á¤Þ¼ÐÅÒ¤Wªº¹w³]¿ï¶µ¡A½Ð¿ï¨ú [Ãþ«¬] ¯Á¤Þ¼ÐÅÒ¤Wªº [¦Û°Ê³]©w¹Ïªí¿ï¶µ]¡C
Åã¥Ü®æ½u
¨Ï¥Î®æ½u¥i¦b¹Ïªí¤¤¥[¤J½u±ø¡A¨Ò¦p¡A¨Ï¥Îªø±ø¹Ï®É¡A¥i¬°¨C¤@Ó««ª½®y¼ÐÈ¥[¤J¤ô¥½u¡C
- ¥Dn
- ¨Ï¥Î [¥Dn] ®Ö¨ú¤è¶ô¨Ó¨M©w¬O§_nÅã¥Ü¹Ïªí®y¼Ð¶bªº¥Dn¾É½u¡Aµø¥¿¦b«Ø¥ßªº¹ÏªíÃþ«¬¦Ó©w¡A¦b [¸s²Õ]¡B[¼Æ¦C]¡B[¸ê®Æ] ©M/©Î [¸ê®Æ 2] µ¥®y¼Ð¶b¥i¯à·|¦³ [¥Dn] ®Ö¨ú¤è¶ô¡C
- ¿ï¨ú [¥Dn] ®Ö¨ú¤è¶ô¨ÓÅã¥Ü¬Û¹ï®y¼Ð¶bªº¾É½u
- ²M°£ [¥Dn] ®Ö¨ú¤è¶ô¨ÓÁôÂì۹ï®y¼Ð¶bªº¾É½u
- ¦¸n
- ¨Ï¥Î [¦¸n] ®Ö¨ú¤è¶ô¨Ó¨M©w¬O§_nÅã¥Ü¹Ïªí®y¼Ð¶bªº¦¸n¾É½u¡Aµø¥¿¦b«Ø¥ßªº¹ÏªíÃþ«¬¦Ó©w¡A¦b [¸s²Õ]¡B[¼Æ¦C]¡B[¸ê®Æ] ©M/©Î [¸ê®Æ 2] µ¥®y¼Ð¶b¥i¯à·|¦³ [¦¸n] ®Ö¨ú¤è¶ô¡C
- ¿ï¨ú [¦¸n] ®Ö¨ú¤è¶ô¨ÓÅã¥Ü¬Û¹ï®y¼Ð¶bªº¾É½u
- ²M°£ [¦¸n] ®Ö¨ú¤è¶ô¨ÓÁôÂì۹ï®y¼Ð¶bªº¾É½u
¸ê®ÆÈ
- ¦Û°Ê½Õ¾ã¤j¤p
- ¿ï¨ú [¦Û°Ê½Õ¾ã¤j¤p] ®Ö¨ú¤è¶ô®É¡A·|½Õ¾ã¼ÐÅҼƥءA¥H½T«O [¸ê®Æ] ®y¼Ð¶bªºÅã¥Ü«Ü²M·¡¡C
- ¦Û°Ê½d³ò
- ¿ï¨ú [¦Û°Ê½d³ò] ®Ö¨ú¤è¶ô®É¡A·|±N¹ïÀ³®y¼Ð¶bªº¸ê®ÆÈ«ü¬£¬°¹w³]½d³ò¡C
- ³Ì¤pÈ
- ¨Ï¥Î [³Ì¤pÈ] ¤å¦r¤è¶ô¡A¬°¹ïÀ³ [¸ê®Æ] ®y¼Ð¶b¤Wªº¸ê®ÆÈ¿é¤J½d³ò³Ì¤pÈ¡A[¸ê®Æ] ®y¼Ð¶b¦³ [³Ì¤pÈ] ¤å¦r¤è¶ô¡A[¸ê®Æ 2] ®y¼Ð¶b¤]¥i¯à¦³ [³Ì¤pÈ] ¤å¦r¤è¶ô¡C¥u¦³·í¹Ïªí¬O¥æ¤eªí©Î OLAP ¹Ïªí®É¡A¤~·|±Ò°Ê²Ä¤GÓ [³Ì¤pÈ] ¤å¦r¤è¶ô¡C
¦pªG¿ï¨ú¬Û¹ïªº [¦Û°Ê½d³ò] ®Ö¨ú¤è¶ô¡A[³Ì¤pÈ] ¤å¦r¤è¶ô°±¥Î¡C
ª`·N ³oÓª©¥»ªº Crystal Reports ¤£¤ä´© OLAP ®æ½uª«¥ó¡C
- ³Ì¤jÈ
- ¨Ï¥Î [³Ì¤jÈ] ¤å¦r¤è¶ô¡A¬°¹ïÀ³ [¸ê®Æ] ®y¼Ð¶b¤Wªº¸ê®ÆÈ¿é¤J½d³ò³Ì¤jÈ¡A[¸ê®Æ] ®y¼Ð¶b¦³ [³Ì¤jÈ] ¤å¦r¤è¶ô¡A[¸ê®Æ 2] ®y¼Ð¶b¤]¥i¯à¦³ [³Ì¤jÈ] ¤å¦r¤è¶ô¡C¥u¦³·í¹Ïªí¬O¥æ¤eªí©Î OLAP ¹Ïªí®É¡A¤~·|±Ò°Ê²Ä¤GÓ [³Ì¤jÈ] ¤å¦r¤è¶ô¡C
¦pªG¿ï¨ú¬Û¹ïªº [¦Û°Ê½d³ò] ®Ö¨ú¤è¶ô¡A[³Ì¤jÈ] ¤å¦r¤è¶ô°±¥Î¡C
- ¼Æ¦r®æ¦¡
- ¨Ï¥Î [¼Æ¦r®æ¦¡] ²M³æ¡A¬°¹ïÀ³ [¸ê®Æ] ®y¼Ð¶b¤Wªº¸ê®ÆÈ¿ï¨ú¼Æ¦r®æ¦¡¡A[¸ê®Æ] ®y¼Ð¶b (Y) ¦³ [¼Æ¦r®æ¦¡] ²M³æ¡A[¸ê®Æ 2] ®y¼Ð¶b¤]¥i¯à¦³¤@¥÷²M³æ¡C¥u¦³·í¹Ïªí¬O¥æ¤eªí©Î OLAP ¹Ïªí®É¡A¤~·|±Ò°Ê²Ä¤GÓ [¼Æ¦r®æ¦¡] ²M³æ¡C
¦pªG¿ï¨ú¹ïÀ³ªº [¦Û°Ê½d³ò] ®Ö¨ú¤è¶ô¡A[¼Æ¦r®æ¦¡] ²M³æ°±¥Î¡C
°Ï°ì¼Æ¥Ø
- ¦Û°Ê
- ¦pªG¿ï¨ú [¦Û°Ê] ¿ï¶µ¡Aµ{¦¡·|¦Û°Ê³]©w¹ïÀ³ [¸ê®Æ] ®y¼Ð¶bªº°Ï°ì¼Æ¥Ø¡C[¸ê®Æ] ®y¼Ð¶b¦³ [¦Û°Ê] ¿ï¶µ¡A[¸ê®Æ 2] ®y¼Ð¶b¤]¥i¯à¦³ [¦Û°Ê] ¿ï¶µ¡C¥u¦³·í¹Ïªí¬O¥æ¤eªí©Î OLAP ¹Ïªí®É¡A¤~·|±Ò°Ê²Ä¤GÓ [¦Û°Ê] ¿ï¶µ¡C
ª`·N ³oÓª©¥»ªº Crystal Reports ¤£¤ä´© OLAP ®æ½uª«¥ó¡C
- ¤â°Ê
- ¨Ï¥Î [¤â°Ê] ¿ï¶µ¡A¥H¤â°Ê¤è¦¡³]©w¹ïÀ³ [¸ê®Æ] ®y¼Ð¶bªº°Ï°ì¼Æ¥Ø¡C[¸ê®Æ] ®y¼Ð¶b¦³ [¤â°Ê] ¿ï¶µ¡A[¸ê®Æ 2] ®y¼Ð¶b¤]¥i¯à¦³ [¤â°Ê] ¿ï¶µ¡C¥u¦³·í¹Ïªí¬O¥æ¤eªí©Î OLAP ¹Ïªí®É¡A¤~·|±Ò°Ê²Ä¤GÓ [¤â°Ê] ¿ï¶µ¡C
·í±z«ö¤@¤U [¤â°Ê] ¿ï¶µ«ö¶s®É¡A·|±Ò°Ê¬Û¾Fªº¤å¦r¤è¶ô¡C½Ð¨Ï¥Î¤å¦r¤è¶ô¨Ó¿é¤J¤À¹j¼Æ¥Ø¡C
½Ð°Ñ¾\
¿ï¶µ¯Á¤Þ¼ÐÅÒ (¹Ïªí±M®a) | ¤å¦r¼ÐÅÒ (¹Ïªí±M®a) | ¹Ïªí±M®a