{"id":443,"date":"2014-08-03T20:40:24","date_gmt":"2014-08-03T18:40:24","guid":{"rendered":"http:\/\/www.flip-design.de\/?p=443"},"modified":"2014-08-03T20:40:24","modified_gmt":"2014-08-03T18:40:24","slug":"standardfeldsatz-in-powerpivot-und-powerview","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=443","title":{"rendered":"Standardfeldsatz in PowerPivot und PowerView"},"content":{"rendered":"

\"PowerPivot_Logo\"<\/a>Tabellen k\u00f6nnen im PowerPivot Datenmodell so vorbereitet werden, dass man in einem Klick eine vorgefertigte Aufbereitung in PowerView erhalten kann.<\/p>\n

see english version below<\/a><\/p>\n

Als Datengrundlage dient hier eine Abfrage aus der Adventure Works:<\/p>\n

SELECT Production.Product.ProductID, Production.Product.Name ProductName, Production.Product.Color, Production.Product.ListPrice, Production.ProductCategory.Name AS Category, Production.ProductPhoto.ThumbNailPhoto, \r\n                  Production.ProductSubcategory.Name AS Subcategory\r\nFROM     Production.Product INNER JOIN\r\n                  Production.ProductProductPhoto ON Production.Product.ProductID = Production.ProductProductPhoto.ProductID INNER JOIN\r\n                  Production.ProductPhoto ON Production.ProductProductPhoto.ProductPhotoID = Production.ProductPhoto.ProductPhotoID INNER JOIN\r\n                  Production.ProductSubcategory ON Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID INNER JOIN\r\n                  Production.ProductCategory ON Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID<\/pre>\n
Als erstes markiert man in PowerPivot das Feld \u201eThumbNailPhoto\u201c als Bild:
\n\"piv\"<\/a><\/p>\n
Im n\u00e4chsten Schritt werden die Felder konfiguriert, die bei einer Analyse als Standard in der Reihenfolge ausgegeben werden sollen:
\n\"feldsatz\"<\/a><\/p>\n
Nun muss das Tabellenverhalten noch so eingestellt werden, dass bei der Verwendung das Bild automatisch mit verwendet wird:
\n\"tabellenverhalten\"<\/a><\/p>\n
Nun kann in PowerView durch einen Doppelklick auf die Tabelle die Liste erstellt werden. Stellt man nun die Ansicht von der Tabelle auf Karten um, ist die Analyse durch 2 Klicks f\u00fcr den Anwender aufbereitet.
\n\"doubleklick\"<\/a><\/p>\n
\"karte\"<\/a><\/p>\n
Weitere Informationen gibt es hier:<\/p>\n
<\/a>English Version<\/strong><\/em><\/h1>\n
Tables can be prepared in the PowerPivot data model so that you can get a ready-made presentation in Power View in a single click.
\nFollowing Query are used for this example (Adventure Works)<\/p>\n
SELECT Production.Product.ProductID, Production.Product.Name ProductName, Production.Product.Color, Production.Product.ListPrice, Production.ProductCategory.Name AS Category, Production.ProductPhoto.ThumbNailPhoto, \r\n                  Production.ProductSubcategory.Name AS Subcategory\r\nFROM     Production.Product INNER JOIN\r\n                  Production.ProductProductPhoto ON Production.Product.ProductID = Production.ProductProductPhoto.ProductID INNER JOIN\r\n                  Production.ProductPhoto ON Production.ProductProductPhoto.ProductPhotoID = Production.ProductPhoto.ProductPhotoID INNER JOIN\r\n                  Production.ProductSubcategory ON Production.Product.ProductSubcategoryID = Production.ProductSubcategory.ProductSubcategoryID INNER JOIN\r\n                  Production.ProductCategory ON Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID<\/pre>\n
The first thing you marked in PowerPivot the „Thumbnail Photo“ field as an image:
\n\"piv\"<\/a><\/p>\n
In the next step, the fields are configured to be output in an analysis as the standard, in order:
\n\"feldsatz\"<\/a><\/p>\n
Now, the behavior of table must be set so that in use, the image is automatically used with:
\n\"tabellenverhalten\"<\/a><\/p>\n
Now you can create in Power View, double-click the table list. If, now, the view from the table to map to, the analysis is prepared by 2 clicks for the user.
\n\"doubleklick\"<\/a><\/p>\n
\"karte\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Tabellen k\u00f6nnen im PowerPivot Datenmodell so vorbereitet werden, dass man in einem Klick eine vorgefertigte Aufbereitung in PowerView erhalten kann. see english version below Als Datengrundlage dient hier eine Abfrage aus der Adventure Works: SELECT Production.Product.ProductID, Production.Product.Name ProductName, Production.Product.Color, Production.Product.ListPrice, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":270,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[30,41,26,40],"tags":[46,44,47],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/443"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=443"}],"version-history":[{"count":3,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/443\/revisions"}],"predecessor-version":[{"id":451,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/443\/revisions\/451"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/media\/270"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}