[Step By Step]SAP Visual Intelligence数据操作、地图信息显示(SAP HANA中提取数据)

港控/mmm° 2022-03-28 07:45 56阅读 0赞

Instruction：

本案例从SAP HANA中提取数据，试图创建数据的地图显示、数据修正

View: [http://www.cnblogs.com/omygod/archive/2013/04/29/3050875.html][http_www.cnblogs.com_omygod_archive_2013_04_29_3050875.html]

1. 从SAP HANA中导入数据并新建文档：

[![image][]][image 1]

选择HANA Offline，从SAP HANA中直接导入数据

[![image][image 2]][image_image 2]

填写SAP HANA的连接信息，并连接

[![image][image 3]][image_image 3]

选择相应视图，并点击Acquire, SAP Visual Intelligence将从SAP HANA中提取数据：

[![image][image 4]][image_image 4]

数据提取完毕之后，则进入如下设计主界面：

[![image][image 5]][image_image 5]

2. 数据修改

选择CITYNAME创建Geographic hierarchy

[![image][image 6]][image_image 6]

设置如下：

[![image][image 7]][image_image 7]

点击OK之后，我们会发现有些城市的名字在系统现有的字典中并不存在，我们休要修正这些城市的名字：Marseilles, Medelin,Pragues

[![image][image 8]][image_image 8]

这三个城市正确的对应名称为：

Marseilles =〉Marseille

Medelin => Medellin

Pragues => Pragues

点击Cancel，我们去修改这些错误的数据。

点中左上角的Data，找到CITYNAME这个字段，在右侧点开Manipulation Tools

[![image][image 9]][image_image 9]

在Manipulation Tools中找到错误的值，并使用Replace功能，然后 Do It,

[![image][image 10]][image_image 10]

在Manipulation Tools中修改之后，数据将会都被修改，修改之后结果如下：

[![image][image 11]][image_image 11]

同样，我们也可以对数据做一些其他操作，比如Trim, Convert等

另外，我们在做地图类报表的时候，可能需要将某个地区和另外一个地区合并，从现在做的这个例子开看，Praque只是Paris的一个区，我们希望在报表的时候，数据都展示在Paris下面，则具体操作如下： 选中Paris和Praque, 选择Group:

[![image][image 12]][image_image 12]

执行Do It，这时我们会发现Paris的出现频率是1939，是开始Paris和Praque的总和

[![image][image 13]][image_image 13]

再次选择CITYNAME创建Geographic hierarchy，这时候我们发现错误的城市信息已经没有，但有些近似名称的城市信息需要选择对应的城市。

[![image][image 14]][image_image 14]

为有歧义的城市指定对应的城市信息如下：

[![image][image 15]][image_image 15]

点击OK

3. 显示地图信息报表

在左上角选择Visualize

[![image][image 16]][image_image 16]

在左侧的Hierarchies 中双击Country

[![image][image 17]][image_image 17]

在Measures中选择NetSales

[![image][image 18]][image_image 18]

报表类型选择地图类型：

[![image][image 19]][image_image 19]

则销售订单的国家分布图显示如下：

[![image][image 20]][image_image 20]

4. 在地图上数据展示的一些操作

地图的放大与缩小

[![image][image 21]][image_image 21]

地图上的Drill Down， 双击国家名称

[![image][image 22]][image_image 22]

地图上的Drill Up

[![image][image 23]][image_image 23]

[http_www.cnblogs.com_omygod_archive_2013_04_29_3050875.html]: http://www.cnblogs.com/omygod/archive/2013/04/29/3050875.html
[image]: /images/20220328/e017d1d7c1ff444f8d10d7251c3a7b23.png
[image 1]: https://images0.cnblogs.com/blog/18408/201305/02113315-2f8e44649cf846cd949708c9c1541fd1.png
[image 2]: https://images0.cnblogs.com/blog/18408/201305/02113318-98ce26fffd5a414fbccc198c1596a8d0.png
[image_image 2]: /images/20220328/afd2a778a82a4438a1e4c397cef7968a.png
[image 3]: https://images0.cnblogs.com/blog/18408/201305/02113320-c4c1a74659564946bf72e24fadc5f03d.png
[image_image 3]: /images/20220328/f159044e6b7b48939670df3a30f297f9.png
[image 4]: https://images0.cnblogs.com/blog/18408/201305/02113321-0bef0817c6394a9d9a5a4edef1a25d5b.png
[image_image 4]: /images/20220328/a33adaf4367d4ed8ab4720b731458d89.png
[image 5]: https://images0.cnblogs.com/blog/18408/201305/02113331-53afb2fddea54b43a7efe20e2b6bf47d.png
[image_image 5]: /images/20220328/372a24f897b14fe5a692e87e61966f2c.png
[image 6]: https://images0.cnblogs.com/blog/18408/201305/02113336-8f2a0127a8bc4ca49afe66d77f57d2cf.png
[image_image 6]: /images/20220328/208994066d7e4a59b0ca95b8ed80b2e7.png
[image 7]: https://images0.cnblogs.com/blog/18408/201305/02113338-0c9c5583da6c455d9c9a896f3dd447eb.png
[image_image 7]: /images/20220328/f1877b64487a4404bbe8c6578839365b.png
[image 8]: https://images0.cnblogs.com/blog/18408/201305/02113340-dfef9ea70efb47aaab3ccceac6b5a5f9.png
[image_image 8]: /images/20220328/a7cba02b036143fdb23ff5dd3bd13ad8.png
[image 9]: https://images0.cnblogs.com/blog/18408/201305/02113351-77b98763e8b846b18e105e064aad28ae.png
[image_image 9]: /images/20220328/4377169d106b4739bb2de95dce666aed.png
[image 10]: https://images0.cnblogs.com/blog/18408/201305/02113356-65f7440936ba435fa56eb7a926e85381.png
[image_image 10]: /images/20220328/6cdef41cba7048aa871391b4c6a381e7.png
[image 11]: https://images0.cnblogs.com/blog/18408/201305/02113403-6da5616244594521aa6cf8da861182c5.png
[image_image 11]: /images/20220328/8cc7df83ef834f61a9bdd1c3d8d1ea59.png
[image 12]: https://images0.cnblogs.com/blog/18408/201305/02113406-0852f16dcfd24562a0b07bd9ef64ef8b.png
[image_image 12]: /images/20220328/ee4fece0f0d84a73ba65da0554573472.png
[image 13]: https://images0.cnblogs.com/blog/18408/201305/02113410-e82a435eb66e44b39eb406dd9a3d0d9f.png
[image_image 13]: /images/20220328/4dadb9ce7b3049bf917a44a426983e3a.png
[image 14]: https://images0.cnblogs.com/blog/18408/201305/02113413-896c02d0ed0b41cbaff21278303ac11e.png
[image_image 14]: /images/20220328/7131676978e3475bbd0713cc8c4e3bc7.png
[image 15]: https://images0.cnblogs.com/blog/18408/201305/02113416-7d6f9416de9a48c98f754f6b0d7d60ae.png
[image_image 15]: /images/20220328/eca537c24d1c45d986ef74d8f7df0f5d.png
[image 16]: https://images0.cnblogs.com/blog/18408/201305/02113418-30619200290a4bc4a8596b378a1029f1.png
[image_image 16]: /images/20220328/72f791e11e81494c808ecf0481e553d0.png
[image 17]: https://images0.cnblogs.com/blog/18408/201305/02113419-faaa04ccaa264df0acb32224a29d75d3.png
[image_image 17]: /images/20220328/01d8070d00024430959c557b237e3067.png
[image 18]: https://images0.cnblogs.com/blog/18408/201305/02113421-4aec0b8e3cd04380a715b49e1e3c542a.png
[image_image 18]: /images/20220328/6b1656f97ee24ca9b2a1b4c8e6b7379a.png
[image 19]: https://images0.cnblogs.com/blog/18408/201305/02113422-e3d6bf3e8b484d6ea2ce8061693c66d7.png
[image_image 19]: /images/20220328/8f0dbc11b1f54bada5e0685530e31306.png
[image 20]: https://images0.cnblogs.com/blog/18408/201305/02113431-458fafec50fc437a809f9ba342c2bf53.png
[image_image 20]: /images/20220328/28a5d56f4ac44d65b855ea68254748f0.png
[image 21]: https://images0.cnblogs.com/blog/18408/201305/02113433-d5a5c5046fb34bbaa25d8bcc6c90fe8e.png
[image_image 21]: /images/20220328/345123ddc479445da377ea2c3d574c88.png
[image 22]: https://images0.cnblogs.com/blog/18408/201305/02113438-174ddafceff94d9585838525a6d504dd.png
[image_image 22]: /images/20220328/4099c67058864395b154d0dcb04498bf.png
[image 23]: https://images0.cnblogs.com/blog/18408/201305/02113443-c0b8b5110d754d6a9ad526858e3e1594.png
[image_image 23]: /images/20220328/a996cd7f23554a9da16b4552c4d48b40.png