{"id":38563,"date":"2022-08-27T20:37:43","date_gmt":"2022-08-27T18:37:43","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/microsoft-power-bi-reporting-sa-podacima-iz-sap-bw\/"},"modified":"2022-08-27T20:37:46","modified_gmt":"2022-08-27T18:37:46","slug":"microsoft-power-bi-reporting-sa-podacima-iz-sap-bw","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/hr\/microsoft-power-bi-reporting-sa-podacima-iz-sap-bw\/","title":{"rendered":"Microsoft Power BI Reporting sa podacima iz SAP BW"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Kao SelfService Reporting Tool, Microsoft Power BI nudi mnoge korisne zna\u010dajke za brzo i jednostavno stvaranje grafi\u010dkih procjena i nadzornih plo\u010da.<\/span><\/p>\r\n

Integracija u paket Office 365 tako\u0111er rezultira fleksibilnim mogu\u0107nostima primjene. <\/span><\/p>\r\n

Power BI podr\u017eava niz razli\u010ditih izvora podataka. Posebno za tvrtke koje koriste SAP BW, veza ovoga je u prvom planu. <\/span><\/p>\r\n

Ovaj post na blogu bavi se razli\u010ditim opcijama povezivanja SAP BW s Microsoft Power BI.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Arhitektura Power BI - pregled<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tPower BI pru\u017ea dva razli\u010dita puta povezivanja za pristup SAP BW \/ SAP HANA sustavima. U prvoj varijanti izvorni podaci relevantni za izvje\u0161\u0107a u potpunosti se uvoze u Power BI. Drugi izravno pristupa izvornom sustavu; podaci izvje\u0161\u0107a se stoga ponovno izvla\u010de tijekom izvo\u0111enja.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Blog2\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

U oba slu\u010daja, takozvani skup podataka nastaje kada se izvje\u0161\u0107e kreira i u\u010dita na Power BI poslu\u017eitelj. <\/span><\/p>\r\n

U slu\u010daju rje\u0161enja uvoza, temeljni podaci uklju\u010deni su u skup podataka. U slu\u010daju izravnog pristupa podacima, s druge strane, sadr\u017eani su samo metapodaci, kao \u0161to su informacije o povezivanju, za uspostavljanje veze s odgovaraju\u0107im SAP BW \/ SAP HANA. Donja slika shematski prikazuje dvije vrste povezivanja. <\/span><\/p>\r\n

Iako se zahtjevi za izvje\u0161\u0107e mogu poslu\u017eiti izravno iz skupa podataka s varijantom uvoza, oni se proslje\u0111uju temeljnom SAP sustavu s “izravnim pristupom”; rezultat izvje\u0161\u0107a se tako izravno hrani trenutnim podacima.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\tS arhitektonskog gledi\u0161ta, pru\u017eanje podataka u Power BI-ju kada se koristi izravni pristup (putem Direct Query) temelji se na sljede\u0107em principu:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t