Kutheni kubalulekile ukuba uchonge iiNgxelo zeCognos nge-SQL efakwe
Ngenxa yobume beengxelo ze-SQL ezinekhowudi enzima, zifuna ukonganyelwa okuqhubekayo kunye nokugcinwa. Ngapha koko, ukuba wenza utshintsho kwindawo yogcino lwedatha kunokuba yinto engenakwenzeka ukufumanisa ukuba zeziphi iingxelo ezinengcinga eyakhelwe ngaphakathi kwi-SQL yabo. Kude kusilele ukubaleka oko kukuthi. Ngenxa yokuba kunzima kangakanani ukugcina iingxelo nge-SQL efakelweyo, kubalulekile ukuba uchonge ukuze ubanike ingqalelo eyongezelelweyo abayifunayo. Oluqwalaselo lunokuthatha uhlobo lokususa i-SQL efakwe ngaphakathi okanye ukuvuselelwa kwe-SQL ukuze ihambelane notshintsho kwindawo yokugcina idatha. Makhe sihlolisise indlela yokusebenzisa MotioPI ukuchonga ezi ngxelo “zikhethekileyo”.
Kusetyenziswa kwanjani MotioI-PI yokufumana iiNgxelo zeCognos nge-SQL efakiwe
The Khangela kwaye ubeke endaweni yePhaneli in MotioPI yenzelwe ukukhangela ngaphezulu kwengxelo yengxelo yakho, ichonge iingxelo ezilinganisa iikhrayitheriya ezibekwe nguwe, kwaye zenze notshintsho olulula kwiseti yezinto zeCognos. Namhlanje siza kusebenzisa indawo yokukhangela yokuKhangela kunye nokuTshintsha endaweni yokuchonga ngokukhawuleza zonke iingxelo ezisebenzisa i-SQL efakwe ngaphakathi ukuze uqinisekise imixholo yazo, uziguqulele ekusebenziseni imodeli, okanye uzisuse kwimveliso zizonke.
-
- Vula uPhendlo kunye nokuTshintsha ipaneli kwi MotioPI. Ukuba kukho imfuneko, nciphisa uphendlo lwakho ukugquma kuphela kumacandelo evenkile yakho yomxholo, enokuthi ibe luncedo ngakumbi ukuba unomdla kuphela kwicandelwana levenkile yakho yomxholo okanye ukhathazekile ngesantya sophando lwakho MotioPI. Ukumxinwa, khetha iqhosha "Limxinwa"
- Khetha iifayile okanye incwadi eneenkcukacha ofuna ukuyikhangela uze ukhethe iqhosha u ">>".
- Ngena ”(Ngaphandle kwezicatshulwa) kwicandelo lokukhangela.
- Cinezela iqhosha elithi "Khangela".
- MotioI-PI iya kubuyisa zonke iingxelo eziqulethe i-SQL efakiwe kukhangelo lwakho.
- Qaphela ukuba ungayenza imouse ngaphezulu kwesiqwengana ukubona isicatshulwa esipheleleyo se-SQL yakho.
- Nje ukuba ufumanise zonke iingxelo zakho nge-SQL efakelweyo, ungazibhala phantsi usebenzisa inqaku lokuthumela kwelinye ilizwe ngaphakathi MotioPI (Ifayile-> Ukuthumela ngaphandle), zihambise kwindawo enye usebenzisa MotioI-PI ukuze ukwazi ukuyifumana ngokulula kwixa elizayo, okanye wenze uguquko olulula kwi-spec usebenzisa i "Buyisela" inqaku lePhendla kunye nokuTshintsha iPhaneli.
UKUQINISWA:
Yindlela onokusebenzisa ngayo ukuKhangela kunye nokuTshintsha indawo yepaneli kwi MotioI-PI yokuchonga zonke iingxelo nge-SQL efakiwe. Unokufumana iipositi ezimbalwa zobuxoki usebenzisa le ndlela, kodwa oko kwenziwa ukuze MotioI-PI ayiphosi naziphi na iingxelo nge-SQL efakelweyo. Unokuwanciphisa amagama akho ophando ukuze ukhangele kuphela is syntax ngqo yeengxelo zakho ze-SQL. Ukuba unayo nayiphi na imibuzo malunga nokuba ungayisebenzisa njani ngokuKhangela kunye nokuBeka iPhaneli, vele ubuze apha ngezantsi kwizimvo, ndihlala ndonwabile ukwaba naluphi na ulwazi lweCognos endinokuba nalo!