ºñÁö´Ï½º ÀÎÅÚ¸®Àü½º ÀÚ½À¼­

ÇÊÅÍ ¼³Á¤

ÀÌ °úÁ¤¿¡¼­´Â OLAP ÀÀ¿ëÇÁ·Î±×·¥¿¡ ·ÎµåµÇ´Â ±¸¼º¿øÀ̳ª µ¥ÀÌÅ͸¦ Á¦ÇÑÇÏ´Â ÇÊÅ͸¦ ¼³Á¤ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, OLAP ¸ðµ¨¿¡ ÇÑ ÇØÀÇ Àüü µ¥ÀÌÅͰ¡ µé¾î ÀÖ´Â °æ¿ì¿¡´Â ÇÊÅ͸¦ ¼³Á¤ÇÏ¿© 2/4 ºÐ±â¿¡ ´ëÇÑ µ¥ÀÌÅ͸¸ ·ÎµåÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÀÌ ¿¹Á¦¿¡¼­ OLAP ÀÀ¿ëÇÁ·Î±×·¥¿¡¼­ ·ÎµåÇÑ µ¥ÀÌÅ͸¦ 1996ºÎÅÍÀÇ µ¥ÀÌÅÍ·Î Á¦ÇÑÇÏ´Â ÇÊÅ͸¦ ÀÛ¼ºÇÕ´Ï´Ù.

  1. Name Filters ÆäÀÌÁö¿¡¼­, Sales96À» Name Çʵ忡 ÀÔ·ÂÇϰí Add to List¸¦ ´©¸£½Ê½Ã¿À. OLAP Metaoutline Filter List Çʵ忡 À̸§ÀÌ Ãß°¡µË´Ï´Ù.
    Name Filters ÆäÀÌÁö
  2. Next¸¦ ´©¸£¸é Assign Member Filters ÆäÀÌÁö°¡ ¿­¸³´Ï´Ù.
  3. Metaoutline Filter List Çʵ忡¼­ Sales96À» ¼±ÅÃÇϽʽÿÀ.
  4. Members Çʵ忡¼­ Year Â÷¿øÀÇ Æ®¸® ºä¸¦ ¿­°í Time, Year °èÃþÀ» ¼±ÅÃÇϽʽÿÀ.
  5. Define Filter¸¦ ´©¸£¸é Filter âÀÌ ¿­¸³´Ï´Ù. ÀÌ Ã¢À» »ç¿ëÇÏ¿© OLAP ÀÀ¿ëÇÁ·Î±×·¥¿¡¼­ ÇÊÅ͸µÀÌ µÉ µ¥ÀÌÅ͸¦ ÁöÁ¤ÇϽʽÿÀ. ÇÑ °¡Áö Á¶°ÇÀ» °®´Â Time Â÷¿øÀÇ ÇÊÅ͸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
  6. ù¹øÂ° Á¶°Ç¿¡ Column ÇʵåÀÇ Year °ªÀ» À¯ÁöÇϽʽÿÀ. Operator ¸ñ·Ï »óÀÚ¿¡¼­, µîÈ£(=)¸¦ ¼±ÅÃÇϽʽÿÀ.
  7. Condition ÇÊµå ¿À¸¥ÂÊÀÇ ¹öưÀ» ´©¸£¸é Select Values from Time, Year âÀÌ ³ªÅ¸³³´Ï´Ù.
  8. ¸ñ·Ï¿¡¼­ 1996À» ¼±ÅÃÇϰí OK¸¦ ´­·¯ Filters âÀ¸·Î ¸®ÅÏÇϽʽÿÀ.
  9. Filters â¿¡¼­ Add¸¦ ´©¸£½Ê½Ã¿À. ±×·¯¸é ÇÊÅͰ¡ Filters Çʵ忡 ³ªÅ¸³³´Ï´Ù. ¿øÇϸé Filters Çʵ忡¼­ ÇÊÅ͸¦ Á÷Á¢ ÆíÁýÇÒ ¼ö ÀÖÀ¸³ª, Áö±ÝÀº ¼öÇàÇÏÁö ¸¶½Ê½Ã¿À.
  10. Verify¸¦ ´©¸£¸é ÇÊÅÍ ±¸¹®ÀÌ ¿Ã¹Ù¸¥Áö È®ÀÎÇÒ ¼ö ÀÖÀ¸¸ç, OK¸¦ ´©¸£¸é Filters âÀÌ ´ÝÈü´Ï´Ù. Assign Member Filters ÆäÀÌÁö´Â ´ÙÀ½°ú °°½À´Ï´Ù.
    Name Filters ÆäÀÌÁö

ÇÊÅÍ °ËÅä

ÀÌ ¿¹Á¦¿¡¼­, Â÷¿ø ±¸¼º¿ø¿¡¼­ ÇÊÅ͸¦ ¼³Á¤ÇÏ´Â ¹æ¹ýÀ» Á¶»çÇϸç ÀÛ¼ºÇÑ ÇÊÅ͸¦ °ËÅäÇÕ´Ï´Ù.


Áö±Ý±îÁöÀÇ ³»¿ë

ÀÌ °úÁ¤¿¡¼­ OLAP ÀÀ¿ëÇÁ·Î±×·¥À¸·Î ·ÎµåÇÑ µ¥ÀÌÅ͸¦ 1996ºÎÅÍÀÇ µ¥ÀÌÅÍ·Î Á¦ÇÑÇÏ´Â ÇÊÅ͸¦ ¼³Á¤Çß½À´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ ]