Nzira yekuziva sei Cognos Mishumo ine Yakabatanidzwa SQL

by Sep 7, 2016Cognos Analytics, MotioPI0 mashoko

Mubvunzo wakajairika uyo unoramba uchibvunzwa weiyo MotioPI Rutsigiro Vashandi ndiyo nzira yekuziva IBM Cognos mishumo, mibvunzo, nezvimwe izvo zvinoshandisa mu-mutsara SQL mune zvavanotsanangudza. Nepo mishumo mizhinji ichikurisa pasuru kuti uwane yako yekuchengetera data, zvinokwanisika kuti mishumo inomhanya SQL zvirevo yakanangana ne database, ichipfuura pasuru yako. Ngatitaurei nezve nei zvichikosha kuziva kuti ndeapi mashumo akasimbisa SQL.

 


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.

    1. 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"
    2. Sarudza mafaera kana dhairekitori iwe raunoda kuitisa kutsvaga kwako wosarudza bhatani “>>”.
    3. Pinda " ”(Pasina makotesheni) mundima yekutsvaga.
    4. Dhinda bhatani "Tsvaga".
    5. MotioPI inodzosera mishumo yese ine yakadzamidzirwa SQL kubva mukutsvaga kwako.
    6. Ziva kuti iwe unogona mbeva pamusoro pe snippet kuti uone iwo uzere iwo mavara eSQL yako. 
    7.  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.

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!

goreCognos Analytics
Motio X IBM Cognos Analytics Cloud
Motio, Inc. Inoendesa Chaiyo-Nguva Yekushandura Kudzora kweCognos Analytics Cloud

Motio, Inc. Inoendesa Chaiyo-Nguva Yekushandura Kudzora kweCognos Analytics Cloud

PLANO, Texas - 22 Gunyana 2022 - Motio, Inc., iyo software kambani inokubatsira kuchengetedza yako analytics mukana nekuita bhizinesi rako njere uye analytics software zviri nani, nhasi yazivisa zvese zvayo. MotioCI zvikumbiro zvino zvinotsigira zvizere maCognos...

Read More