Nei zvichikosha Kuziva Cognos Mishumo ine Yakabatanidzwa SQL
Nekuda kwehunhu hweyakaomeswa kodhi SQL zvirevo, zvinoda kuramba uchiona uye kugadzirisa. Muchokwadi, kana iwe ukaita shanduko mune yako dhatabhesi zvinogona kunge zvisingaite kuti uone kuti ndeapi mashumo ane fungidziro dzakavakirwa mukati mavo-mumutsetse SQL. Kusvika vatadza kumhanya izvo. Nekuda kwekuoma kwazvakaita kuchengetedza mishumo ine SQL yakadzika Uku kutarisa kunogona kutora chimiro chekubvisa iyo yakadzamidzirwa SQL kana kugadzirisa iyo SQL kuti ienderane neshanduko kune yako dura yekuchengetera. Ngationgororei mashandisiro MotioPI kuti ione idzi "dzakasarudzika" mishumo.
Kushandisa sei MotioPI yekutsvaga Cognos Mishumo ine Yakabatanidzwa SQL
The Tsvaga & Tsiva Paneli in MotioPI yakagadzirirwa kutsvaga pamusoro pezvakataurwa mushumo wako, kuona mishumo inoenderana nematanho akaiswa newe, uye kunyangwe kuita shanduko dzakareruka pane seti yeCognos zvinhu. Nhasi tichashandisa chekutsvaga cheKutsvaga & Tsiva kuti tikurumidze kuona mishumo yese inoshandisa yakadzamidzirwa SQL kuitira kuti ugone kusimbisa zvirimo, kuvashandura kuti vashandise iyo modhi, kana kuvabvisa kubva mukugadzira zvachose.
-
- Vhura iyo Tsvaga & Tsiva pani mu MotioPI. Kana zvichidikanwa, chengetedza kutsvaga kwako kuti ungovhara zvikamu zvechitoro chako chemukati, izvo zvinogona kubatsira zvakanyanya kana uchingova nehanya nechikamu chechitoro chako chemukati kana uine hanya nekukurumidza kwekutsvaga kwako MotioPI. Kuti Kupfupike, sarudza bhatani "Narrow"
- Sarudza mafaera kana dhairekitori iwe raunoda kuitisa kutsvaga kwako wosarudza bhatani “>>”.
- Pinda " ”(Pasina makotesheni) mundima yekutsvaga.
- Dhinda bhatani "Tsvaga".
- MotioPI inodzosera mishumo yese ine yakadzamidzirwa SQL kubva mukutsvaga kwako.
- Ziva kuti iwe unogona mbeva pamusoro pe snippet kuti uone iwo uzere iwo mavara eSQL yako.
- Paunenge uchinge wawana yako ese mareport ane yakadzamidzirwa SQL, unogona kuanyora uchishandisa chinhu chekutumira mukati MotioPI (Faira-> Export kuburitsa), vaendese kunzvimbo imwechete uchishandisa MotioPI kuitira kuti ugone kuzviwana mune ramangwana, kana kutomboita shanduko dzakareruka pane iyo spec uchishandisa iyo "Tsiva" chimiro cheKutsvaga & Tsiva Panel.
- Vhura iyo Tsvaga & Tsiva pani mu MotioPI. Kana zvichidikanwa, chengetedza kutsvaga kwako kuti ungovhara zvikamu zvechitoro chako chemukati, izvo zvinogona kubatsira zvakanyanya kana uchingova nehanya nechikamu chechitoro chako chemukati kana uine hanya nekukurumidza kwekutsvaga kwako MotioPI. Kuti Kupfupike, sarudza bhatani "Narrow"
Chiverengwa:
Ndiwo maitiro aunogona kushandisa iyo Tsvaga & Tsiva pani mu MotioPI yekuona mishumo yese ine SQL yakadzamirwa. Unogona kuwana mashoma ekunyepa uchishandisa nzira iyi, asi izvo zvinoitirwa kuti MotioPI haina kupotsa chero mishumo ine yakadzamidzirwa SQL. Iwe unogona zvakare kudzikisa mazwi ako ekutsvaga kuitira kuti iwe ungotsvaga chaiyo chaiyo syntax yemashoko ako eSQL. Kana iwe uine chero mibvunzo nezve mashandisiro ekushandisa iyo Tsvagisa & Tsiva Panel, ingobvunza pazasi mune zvakataurwa, ndinogara ndichifara kugovana chero ruzivo rweCognos randinogona kuva narwo!
