±äÁ¿ÔöÇ¿£º
QueryÖÐÉèÖÃÁËÓû§³ö¿ÚµÄ±äÁ¿£¬È»ºóÈ¥CMODÖУ¬×ö±äÁ¿ÔöÇ¿¡£ ʾÀý´úÂ볡¾° : ATEST_MON_CEΪÓû§³ö¿Ú±äÁ¿ ÆäÖдæ·ÅÔ·ÝÄê·Ý£¨201011£©ZCALDAYΪÓû§ÊäÈëµÄʱ¼ä±äÁ¿£¨20101101£©£¬½«ZCALDAYÖеÄÄêÔ½ØÈ¡·ÅÈëATEST_MON_CEÖУ¬Ä¿µÄÊÇΪÁËͳ¼ÆijÄêijÔ·ݵÄkey figureÊý¾Ý¡££¨¾ÍÊÇatest_mon_CEÊÇÓû§×Ô¶¨ÒåµÄÓû§³ö¿Ú±äÁ¿£¬Óû§ÊäÈëZCALDAY(20101101),ÐèÒª½ØÈ¡ÄêÔÂ201011µ½ATEST_MON£© £¨¾ÍÊÇ£¬¾ßÌ忴ijÈÕµÄÊý¾Ý£¬¾ÍÐèҪЩ±äÁ¿ÔöÇ¿£¬ÒòΪϵͳÊǽØÈ¡Ç°6λµÄ£¬Ö»ÄÜ¿´Ô·ݣ¬²¢²»ÄÜ¿´¾ßÌåÈÕ×Ó£©£¨»¹ÓоÍÊÇͬ»·±È£¬ºÍÄêÀÛµÄÔöÇ¿£¬Õâ¸öÓõıȽ϶ࡣ±ÈÈçʱ¼äÔ·Ý-1¾ÍÊÇÉϸöÔµģ¬Ò²¾ÍÊÇ»·±È£¬Ê±¼ä-12¾ÍÊÇÈ¥ÄêͬÆڵģ¬¾ÍÊÇͬ±È£¬¶¼ÒªÐ´±äÁ¿ÔöÇ¿£©
field-symbols :
Case i_vnam. When ¡®ATEST_MON_CE¡¯.
If i_step = 2. //ÒòΪi_step=1ʱ²»ÐèÒªÎÒÃÇ×öÈκδ¦ÀíËùÒÔÖ±½ÓÔÚi_step=2ʱ°Ñ //i_step=1ʱ£¬Óû§ÊäÈëµÄ±äÁ¿´ÓÄÚ±íI_T_VAR_RANGEÖнøÐжÁÈ¡
Read table I_T_VAR_RANGE assigning
If sy_subrc = 0.
Clear ls_range. //·ÀÖ¹ls_rangeÖÐÒѾÓи³Öµ£¬½«ÆäÇå¿Õ¡£ Ls_range-sign = ¡®I¡¯. //include Óë exclude
Ls_range-sign =¡¯EQ¡¯.
Ls_range-low =
10.ÔöÇ¿ÏÔöÇ¿³ö¿Ú¡£
´ð£ºÊý¾ÝÔ´ÔöÇ¿£ºRSAP0001 ±¨±í±äÁ¿ÔöÇ¿£ºRSR00001.
11. ÔڽṹÖнøÐÐÔöǿʱ£¬×Ö¶ÎÃüÃûÏÞÖÆÊÇʲô£¿
´ð£ºËùÓÐÔÚ¸½¼Ó½á¹¹ÖеÄÐÂ×ֶαØÐëÒÔZZ¿ªÍ·¡£
Î壮Query±¨±í
1.°ÑBW±¨±í·¢²¼µ½EXCELÉÏ£¬ÓÐÒ»¸ö±äÁ¿ÈÕÀúÄêÔ£¬Ã¿Ìì´ò¿ª´°¿ÚʱѡÔñ±äÁ¿ÖµÊ±¶¼ÊÇ°´Ë³ÐòÅŵģ¬ÒòΪCubeÀïµÄÊý¾Ý¶à½Ï¶àÁË£¬Ã¿´Î¶¼Òª·ºÃ¼¸Ò³£¬ÓÐʲô°ì·¨Èõ¯³ö´°¿ÚµÄÐÅÏ¢Êǵ¹ÐòÅÅÁеģ¿
´ð:·½·¨1.Äã¿ÉÒÔÓÚ±äÁ¿ÊäÈë´°¿Ú£¬Ñ¡Ôñ¡°µ¥Öµ¡±£¬µã»÷¡°ÈÕÀúÄê/Ô¡±ÌõÄ¿£¬¿ÉÒÔÇл» ÅÅÐò·½Ê½(ÉýÐò»ò½µÐò)¡£
·½·¨2.¿ÉÒÔÓá°ÈÕÀúÄꡱ¼Ó¡°ÈÕÀúÔ¡±±äÁ¿Ìæ»»¡°ÈÕÀúÄê/Ô¡±±äÁ¿,ͬʱÉ趨²éѯĬÈÏÖµ£¬ÕâÑù¿ÉÒÔ¼õÉÙÌõÄ¿Êý¡£
2.QueryÖеÄÊý¾ÝÈçºÎ¾ÓÖÐÏÔʾÄØ£¿
´ð:
Ò». Ñ¡ÔñÒªÐ޸ĵÄÇøÓò
¶þ. µã»÷Bex ²Ëµ¥ÖеÄLayout£¨²¼¾Ö£©, Ñ¡Ôñalignment£¨ÅųÉÖ±Ïߣ© Èý. ÉèÖÃHorizontal£¨Ë®Æ½Î»Öã© Ϊcenter
ËÄ. ±£´æWorkbook¼´¿ÉÔÚ query designer ÖÐµÄ query properties£¨µÀ¾ß£©, Display tab ¿ÉÒÔÑ¡Ôñ results position in number format, ¿ÉÊÇÖ»ÓÐ Bottom Left/Right, Top Left/Right. ûÓоÓÖС£
3.ÔÚquery designerÄÚ½¨Á¢calculated key figure£¬ÒòΪÎÒÏëÒªËûµÄ¹«Ê½½á¹¹£¬Î´À´¿ÉÒÔ×Ô¶¯»¯µÄ½«ËùÓÐCKFµÄ¹«Ê½»ã³ö¡£µ«ÔÚmodelingÀïÖ»Óп´µ½Ò»°ãµÄkey figure£¬Ã»ÓÐCKF?
´ð£ºÔÚModeling TreeÏÂÃæµÄBWÒÆËÍ->ÒÆËÍtype->Query->Formula£¨¹«Ê½£¬·½³Ìʽ£©£¬²ã´ÎÊÇÕâ¸ö¹Øϵ£¬¿ÉÒÔ¿´µ½¡£
4.×ö¹ý±¨±íÖеÄcellûÓУ¿
´ð£ºµ¥Ôª¸ñ¡£¿ÉÒÔ²»×ß±¨±íÐÐÁеĻã×Ü£¬¶ÀÁ¢½øÐб¾µ¥Ôª¸ñ¹«Ê½¼ÆËã¡£
5.±¨±í¿ª·¢Öпɹ²Óõijý±äÁ¿Í⣬»¹ÓÐʲô£¿
´ð£º½á¹¹
6.½á¹¹Èç¹ûÔÚÒ»¸ö±¨±íÖÐÖ±½Ó¼ÓÈëÐÞ¸ÄʱÈç¹û²»ÏëÓ°ÏìÆäËûʹÓÃÕâ¸ö½á¹¹µÄ±¨±í£¬ÈçºÎ²Ù×÷£¿
´ð£ºÓÒ»÷£¬É¾³ýÒýÓÃ
7.½âÊÍÒ»ÏÂRKF£¨ÏÞÖÆÐԹؼüÖµ£©£¬CKF£¨¼ÆËãÐԹؼüÖµ£©£¿
´ð£ºRKF£ºÏÞÖÆÐԹؼüÖµ£¬ÓÃÒ»¸ö»ò¶à¸öÌØÕ÷À´ÏÞÖƹؼüÖµµÄÏÔʾÄÚÈÝ¡£
ÀýÈ磺ͬһ¸ö²úÆ·£¬²»Í¬Ê±ÆÚµÄÏúÁ¿£¬¿ÉÒÔ°ÑÏúÁ¿×÷ΪÏÞÖÆ¡£ÏÞÖÆÌõ¼þÊÇʱ¼ä¡£
CKF£º¼ÆËãÐԹؼüÖµ£¬ÓÃÒ»¸ö»ò¶à¸ö¹Ø¼üÖµ¼ÆËã¶øµÃµ½µÄÄÚÈÝ¡£ ÀýÈ磺ÏúÊÛ½ð¶î£¬¾ÍÊǵ¥¼Û*ÊýÁ¿¡£
8.±¨±íÖеÄ×ÔÓÉÌØÐÔ£¿
´ð£ºÔÚ±¨±íĬÈϵÄÇé¿öÏÂÊDz»ÏÔʾµÄ£¬µ«Óû§¿ÉÒÔ×ÔÓÉÍÏק×ÔÓÉÌØÐÔÔÚportalÉÏ·ÖÎöÏÔʾ¡£
9.¼òµ¥½éÉÜһϱ¨±íÖеÄÌõ¼þ£¬ÀýÍ⣬½á¹¹£¿
´ð£ºÌõ¼þÊÇÓÃÀ´×öÏÞÖƵģ¬ÕâÑùÄÜÌáÉý±¨±íµÄ²éѯËٶȡ£
ÀýÍâÊÇÊý¾ÝÔ¤¾¯£¬¾ÍÊDZÈÈç¿â´æÊý¾ÝÓб䶯£¬¾Í»á±ä³ÉºìÉ«Ô¤¾¯¡£
½á¹¹ÊÇ×Ô¼ºÉèÖõģ¬ÉèÖúÃÒ»¸ö½á¹¹²¢±£´æºó£¬ÆäËû±¨±íÒ²¿ÉÒԶԴ˽ṹӦÓá£
10.ÊÇ·ñ×ö¹ýͬ±È£¬»·±È±¨±í£¿
´ð£º×ö¹ý£¬Í¬±È¾ÍÊÇÓëÈ¥ÄêͬÆÚÏà±È£¬»·±È¾ÍÊÇÓëÉϸöÔ£¬Éϸö¼¾¶ÈÏà±È½Ï¡£DSO,CUBE£¬¶¼ÊÇÏàͬµÄ£¬µ«ÊÇÊý¾ÝÊDz»Í¬µÄ£¬ÓÐЩ¹«Ê½ÐèÒªÖØмÆËãһϡ£
Áù£®´¦ÀíÁ´
1.ʲôÊÇÁ÷³ÌÁ´£¿
´ð£ºÁ÷³ÌÁ´ÊÇһϵÁмƻ®ÒªÔÚʼþµÄºǫ́µÈ´ýµÄÁ÷³Ì¡£ÕâЩÁ÷³ÌÖÐÓÐЩ´¥·¢Á˵¥¶ÀµÄʼþ£¬¸Ãʼþ¿ÉÒÔÒÀ´ÎÆô¶¯ÆäËûÁ÷³Ì¡£Á÷³ÌÁ´µÄÿ¸öÁ÷³ÌµÈÓڼƻ®ÓëʼþÏà¹ØµÄ»ù´¡ÏµÍ³ÖÐÒÑÅú×¼µÄ×÷Òµ¡£
Ïȵ½PSA,ÔÙµ½Êä³ö²ã£¬ÔÙÔ¶³Ìµ÷Óá£BYÖ÷ÌâÉÏ´«¡£BYÆóÒµ£¬ÆóÒµÏÂÓÐÐí¶àÖ÷Ìâ¡£
2.Á÷³ÌÁ´--ά»¤£¿
´ð£º
* ͨ¹ýÊÂÎñ´úÂëµ÷ÓÃÁ÷³ÌÁ´Î¬»¤£¨rspc£©
* ÔÚ¹ÜÀí¹¦ÄÜÇøÓò£¬Ñ¡Ôñµ¼º½´°¸ñÖеÄÁ÷³ÌÁ´£¬ÒÔµ÷ÓÃÁ÷³ÌÁ´Î¬»¤
* ÔÚ½¨Ä£¹¦ÄÜÇøÓò£¬Í¨¹ýÑ¡Ôñ¹¤¾ßÀ¸ÉϵÄÁ÷³ÌÁ´Í¼±ê£¨»òÕߴӲ˵¥Ñ¡Ôñ±à¼ ¡ú Á÷³ÌÁ´£©£¬Äú¿ÉÒÔµ÷ÓÃÁ÷³ÌÁ´Î¬»¤¡£
* Ñ¡Ôñ¹¤¾ßÀ¸ÖеÄÁ÷³ÌÁ´Î¬»¤°´Å¥£¬ÒÔ±ã´ÓËùÖ§³ÖÁ÷³ÌµÄά»¤¶Ô»°·ÃÎÊÁ÷³ÌÁ´Î¬»¤
3.´¦ÀíÁ´T-CODE£¿
´ð£ºRSPC
4.ÏîÄ¿ÖÐÔõô½¨´¦ÀíÁ´£¿
´ð£ºÊ×ÏÈ£¬Ö÷Êý¾Ý½¨Ö÷Êý¾ÝµÄÁ´£¬ÒµÎñÊý¾Ý½¨ÒµÎñÊý¾ÝµÄÁ´¡£
Æä´Î£¬Êý¾ÝÔ´µ½PSAÊÇÒ»ÌõÁ´£¬PSAµ½DSOÊÇÒ»ÌõÁ´¡£ ÕâЩÁ´¶¼·Ö¿ª×ö£¬È»ºó¹ÒÔÚÒ»Ìõ´ó´¦ÀíÁ´ÉÏ¡£
Æߣ®È¨ÏÞ
1.ÈçºÎ×ö±¨±íȨÏÞ£¿
´ð£º
Ò»£¬ ·ÖÎöȨÏÞ£¬ ¶þ£¬ ±¨±íȨÏÞ£¬¸ù¾ÝÌØÐÔ£¬ÔÚinfoobjectÀÉèÖóÉÓëȨÏÞÏà¹Ø£¬ÊäÈëÊÂÎñÂëpfcgÅäÖñ¨±í
ȨÏÞ£¬
2.·ÖÎöȨÏÞÊÂÎñÂëÊÇ£¿²¢ÃèÊöһϡ£
´ð£ºRSECADMIN£¬½¨Á¢È¨ÏÞ¶ÔÏ󣬼ÓÈë×öȨÏÞµÄInfoobject£¬ÔÙ¼ÓÈëSAP½¨ÒéµÄÈý¸ö×öȨÏ޵ĶÔÏó£¨0TCAACTVT×ö²Ù×÷µÄÏÞÖÆ£¬Õë¶ÔÐÅÏ¢¶ÔÏó£¬Èçɾ³ý£¬Ö»ÏÔʾ¡£¡£¡££¬0TCAIPROV£¬¶Ô·¶Î§×öÏÞÖÆ£¬0TCAVALID¶Ôʱ¼ä×öÏÞÖÆ£©£¬ÉèÖÃÒª×öȨÏÞµÄÐÅÏ¢¶ÔÏóµÄÖµ£¬È»ºó±£´æ¡£PFCG£¬½øÈë½Çɫά»¤½çÃ棬°Ñ¸Õ²ÅËù×÷µÄȨÏÞ¶ÔÏ󣬷ÖÅäµ½½ÇÉ«ÉÏ£¬ÔٰѽÇÉ«·ÖÅäµ½Óû§¡£
°Ë£®»ù´¡ÖªÊ¶
1.CUBEºÍODS×î´óµÄÇø±ðÊÇ£¿
´ð£º×î´óµÄÇø±ðÊÇCUBEµÄKEYFIGUREÊÇÀۼӵģ¬µ«ÊÇODSÊÇ¿ÉÒÔOVERWRITEµÄ£¬Ò»°ãODSÓÃÀ´·ÅITEM LEVELµÄÊý¾Ý¡£
2.DSO·ÖÀàÓÐÄǼ¸ÖÖ£¿
´ð£º±ê×¼DSO £¬ÓÅ»¯DSO£¬Ö±½ÓдÈëDSO¡£
3.DSO¶ÔÏóµÄ²»Í¬ÀàÐÍ?
´ð£º
Ò».±ê×¼DSO¶ÔÏ󣬾ßÓÐÒÑÖªµÄ±í»î¶¯Êý¾Ý¡¢¸ü¸ÄÈÕÖ¾ºÍ¼¤»î¶ÓÁС£ ¶þ.ÓÅ»¯µÄ¶ÔÏó£¬Õë¶Ô´óÁ¿Êý¾Ý½ö¾ßÓÐÒ»¸ö»î¶¯Êý¾Ý±í¡£
Èý.Ö±½ÓдÈëµÄ¶ÔÏ󣬽ö¾ßÓÐÒ»¸ö¿ÉÓÃÓÚ·ÖÎö³ÌÐò£¨·ÖÎö³ÌÐòÉè¼ÆÆ÷£©µÄ»î¶¯Êý¾Ý±í¡£´ËDSO¶ÔÏóÌæ»»ÔçÆÚ°æ±¾ÖеÄÊÂÎñÐÔ¶ÔÏó¡£
4.ʲôÊǶàÖØÌṩÆ÷£¿
´ð£ºÊÇÒ»ÖÖ£¬Ëü×ÛºÏÁ˶à¸öµÄÊý¾ÝÒÔÓÃÓÚ±¨¸æ¡£¹©Õß±¾Éí²»°üº¬ÈκÎÊý¾Ý¡£Êý¾ÝÓÉËù»ùÓÚµÄÕâЩºÏÔÚÒ»Æð½øÐкϲ¢²Ù×÷¡£