This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push: new 134c079a4d [doc](bi)document for finebi (#754) 134c079a4d is described below commit 134c079a4dcb95be080de9fe0325bc5009e6fe41 Author: wyx123654 <45102878+wyx123...@users.noreply.github.com> AuthorDate: Thu Jun 20 00:06:23 2024 +0800 [doc](bi)document for finebi (#754) --- docs/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ .../current/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ .../version-2.0/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ .../version-2.1/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ sidebars.json | 1 + static/images/bi-finebi-en-1.png | Bin 0 -> 40381 bytes static/images/bi-finebi-en-10.png | Bin 0 -> 371697 bytes static/images/bi-finebi-en-2.png | Bin 0 -> 129351 bytes static/images/bi-finebi-en-3.png | Bin 0 -> 332026 bytes static/images/bi-finebi-en-4.png | Bin 0 -> 107812 bytes static/images/bi-finebi-en-5.png | Bin 0 -> 140411 bytes static/images/bi-finebi-en-6.png | Bin 0 -> 19935 bytes static/images/bi-finebi-en-7.png | Bin 0 -> 82668 bytes static/images/bi-finebi-en-8.png | Bin 0 -> 72256 bytes static/images/bi-finebi-en-9.png | Bin 0 -> 227298 bytes versioned_docs/version-2.0/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ versioned_docs/version-2.1/ecosystem/bi/finebi.md | 95 +++++++++++++++++++++ versioned_sidebars/version-2.0-sidebars.json | 1 + versioned_sidebars/version-2.1-sidebars.json | 1 + 19 files changed, 573 insertions(+) diff --git a/docs/ecosystem/bi/finebi.md b/docs/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..a3ae30309a --- /dev/null +++ b/docs/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI Introduction + +As a business intelligence product, FineBI has a system architecture of data processing, real-time analysis, multidimensional analysis Dashboard and other functions. FineBI supports rich data source connection and analysis and management of tables with multiple views. FineBI can successfully support the modeling and visualization of internal and external data of Apache Doris. + +## Precondition + +Install FineBI 5.0 or later, Download link: https://www.finebi.com/ + +## Login and Connection + +1. Create account and log in FineBI + +  + +2. Select the Built-in database, If you need to select an external database configuration, the documentation is available:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + It is recommended to select the built-in database as the information repository of FineBI. The database type selected here is not the target database for querying and analyzing data, but the database for storing and maintaining FineBI model, dashboard and other information. FineBI needs to add, delete, modify and check it. + ::: + +  + +3. Click the Management System button and select the database connection management in Data Connections to create a new database connection. + +  + +4. On the new database connection page, select MySQL database + +  + +5. Fill in the link information of the Doris database + + - Parameters are described as follows: + + - Username:The username for logging into Doris。 + + - Password:Password of the current user。 + + - Host:IP address of the FE host in the Doris cluster。 + + - Port:FE query port of the Doris cluster。 + + - Coding:Encoding format of the Doris cluster。 + + - Name Database:Target database in Doris cluster。 + +  + +6. Click the test link. Connection succeeded is displayed when the connection information is correct + +  + +## Create model + +1. In the "Public Data" section, click to create a new dataset. Then click the database table + +  + +2. You need to import tables in the existing database connection + +  + +3. You need to refresh each imported table after importing the table. You can analyze the table in the topic only after refreshing the table + +  + +4. Add the imported public data to the edited topic, and then conduct compass analysis and configuration according to business logic. + +  \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/finebi.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..6061152e48 --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI 介绍 + +FineBI 是一款商业智能产品,其具有数据处理、即时分析、多维度分析Dashboard 等多种功能系统架构,FineBI支持丰富的数据源连接、多种视图对表的分析管理。FineBI 可以顺利支持Apache Doris 的内部数据和外部数据的建模与可视化处理。 + +## 前置条件 + +安装FineBI 5.0及以上版本,下载链接:https://www.finebi.com/ + +## 登录与连接 + +1. 创建登录的账户,并使用该账户登录FineBI + +  + +2. 这里选择内置数据库,若需要选择外部数据库配置文档可参考:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + 这里建议选择内置数据库作为帆软BI 的信息存储库,这里选择的数据库类型不是查询分析数据的目标库,而是存储维护帆软BI 模型、仪表盘等信息的数据库,帆软需要对其进行增删改查的操作。 + ::: + +  + +3. 点击管理系统按钮之后选择数据连接中的数据库连接,进而创建一个新的数据库连接 + +  + +4. 在新数据库连接选择界面选择MySQL + +  + +5. 填写Doris数据库的相关连接信息 + + - 参数说明如下: + + - Username:用于登录 Doris 集群的用户名,如 admin。 + + - Password:用于登录 Doris 集群的用户密码。 + + - Host:Doris 集群的 FE 主机 IP 地址。 + + - Port:Doris 集群的 FE 查询端口,如 9030。 + + - Coding:Doris 集群中的编码格式。 + + - Name Database:Doris 集群中的目标数据库。 + +  + +6. 点击测试链接。如果输入的连接信息正确则会弹出连接成功 + +  + +## 创建数据模型 + +1. 在公共数据中点击创建一个新的数据集,添加Doris 数据集时可点击数据库表 + +  + +2. 选择已有数据库连接下需要导入的表 + +  + +3. 导入表后需要对每个导入的表进行刷新,只有刷新后才可以在主题中对该表进行数据分析 + +  + +4. 在编辑的主题中添加导入的公共数据,然后即可按照业务逻辑进行罗盘分析与配置。 + +  \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/finebi.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..6061152e48 --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI 介绍 + +FineBI 是一款商业智能产品,其具有数据处理、即时分析、多维度分析Dashboard 等多种功能系统架构,FineBI支持丰富的数据源连接、多种视图对表的分析管理。FineBI 可以顺利支持Apache Doris 的内部数据和外部数据的建模与可视化处理。 + +## 前置条件 + +安装FineBI 5.0及以上版本,下载链接:https://www.finebi.com/ + +## 登录与连接 + +1. 创建登录的账户,并使用该账户登录FineBI + +  + +2. 这里选择内置数据库,若需要选择外部数据库配置文档可参考:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + 这里建议选择内置数据库作为帆软BI 的信息存储库,这里选择的数据库类型不是查询分析数据的目标库,而是存储维护帆软BI 模型、仪表盘等信息的数据库,帆软需要对其进行增删改查的操作。 + ::: + +  + +3. 点击管理系统按钮之后选择数据连接中的数据库连接,进而创建一个新的数据库连接 + +  + +4. 在新数据库连接选择界面选择MySQL + +  + +5. 填写Doris数据库的相关连接信息 + + - 参数说明如下: + + - Username:用于登录 Doris 集群的用户名,如 admin。 + + - Password:用于登录 Doris 集群的用户密码。 + + - Host:Doris 集群的 FE 主机 IP 地址。 + + - Port:Doris 集群的 FE 查询端口,如 9030。 + + - Coding:Doris 集群中的编码格式。 + + - Name Database:Doris 集群中的目标数据库。 + +  + +6. 点击测试链接。如果输入的连接信息正确则会弹出连接成功 + +  + +## 创建数据模型 + +1. 在公共数据中点击创建一个新的数据集,添加Doris 数据集时可点击数据库表 + +  + +2. 选择已有数据库连接下需要导入的表 + +  + +3. 导入表后需要对每个导入的表进行刷新,只有刷新后才可以在主题中对该表进行数据分析 + +  + +4. 在编辑的主题中添加导入的公共数据,然后即可按照业务逻辑进行罗盘分析与配置。 + +  \ No newline at end of file diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/finebi.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..75ca850032 --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI 介绍 + +FineBI 是一款商业智能产品,其具有数据处理、即时分析、多维度分析Dashboard 等多种功能系统架构,FineBI支持丰富的数据源连接、多种视图对表的分析管理。FineBI 可以顺利支持Apache Doris 的内部数据和外部数据的建模与可视化处理。 + +## 前置条件 + +安装FineBI 5.0及以上版本,下载链接:https://www.finebi.com/ + +## 登录与连接 + +1. 创建登录的账户,并使用该账户登录FineBI + +  + +2. 这里选择内置数据库,若需要选择外部数据库配置文档可参考:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + 这里建议选择内置数据库作为帆软BI 的信息存储库,这里选择的数据库类型不是查询分析数据的目标库,而是存储维护帆软BI 模型、仪表盘等信息的数据库,帆软需要对其进行增删改查的操作。 + ::: + +  + +3. 点击管理系统按钮之后选择数据连接中的数据库连接,进而创建一个新的数据库连接 + +  + +4. 在新数据库连接选择界面选择MySQL + +  + +5. 填写Doris数据库的相关连接信息 + + - 参数说明如下: + + - Username:用于登录 Doris 集群的用户名,如 admin。 + + - Password:用于登录 Doris 集群的用户密码。 + + - Host:Doris 集群的 FE 主机 IP 地址。 + + - Port:Doris 集群的 FE 查询端口,如 9030。 + + - Coding:Doris 集群中的编码格式。 + + - Name Database:Doris 集群中的目标数据库。 + +  + +6. 点击测试链接。如果输入的连接信息正确则会弹出连接成功 + +  + +## 创建数据模型 + +1. 在公共数据中点击创建一个新的数据集,添加Doris 数据集时可点击数据库表 + +  + +2. 选择已有数据库连接下需要导入的表 + +  + +3. 导入表后需要对每个导入的表进行刷新,只有刷新后才可以在主题中对该表进行数据分析 + +  + +4. 在编辑的主题中添加导入的公共数据,然后即可按照业务逻辑进行罗盘分析与配置。 + +  \ No newline at end of file diff --git a/sidebars.json b/sidebars.json index 434154e468..ba37daf356 100644 --- a/sidebars.json +++ b/sidebars.json @@ -520,6 +520,7 @@ "ecosystem/bi/apache-superset", "ecosystem/bi/dbeaver", "ecosystem/bi/datagrip", + "ecosystem/bi/finebi", "ecosystem/bi/powerbi" ] } diff --git a/static/images/bi-finebi-en-1.png b/static/images/bi-finebi-en-1.png new file mode 100644 index 0000000000..55d5687302 Binary files /dev/null and b/static/images/bi-finebi-en-1.png differ diff --git a/static/images/bi-finebi-en-10.png b/static/images/bi-finebi-en-10.png new file mode 100644 index 0000000000..a96a947d6e Binary files /dev/null and b/static/images/bi-finebi-en-10.png differ diff --git a/static/images/bi-finebi-en-2.png b/static/images/bi-finebi-en-2.png new file mode 100644 index 0000000000..35d809e967 Binary files /dev/null and b/static/images/bi-finebi-en-2.png differ diff --git a/static/images/bi-finebi-en-3.png b/static/images/bi-finebi-en-3.png new file mode 100644 index 0000000000..9811a48bf2 Binary files /dev/null and b/static/images/bi-finebi-en-3.png differ diff --git a/static/images/bi-finebi-en-4.png b/static/images/bi-finebi-en-4.png new file mode 100644 index 0000000000..0f1cf24600 Binary files /dev/null and b/static/images/bi-finebi-en-4.png differ diff --git a/static/images/bi-finebi-en-5.png b/static/images/bi-finebi-en-5.png new file mode 100644 index 0000000000..5f4aad141e Binary files /dev/null and b/static/images/bi-finebi-en-5.png differ diff --git a/static/images/bi-finebi-en-6.png b/static/images/bi-finebi-en-6.png new file mode 100644 index 0000000000..d9c2271571 Binary files /dev/null and b/static/images/bi-finebi-en-6.png differ diff --git a/static/images/bi-finebi-en-7.png b/static/images/bi-finebi-en-7.png new file mode 100644 index 0000000000..6bcab9cced Binary files /dev/null and b/static/images/bi-finebi-en-7.png differ diff --git a/static/images/bi-finebi-en-8.png b/static/images/bi-finebi-en-8.png new file mode 100644 index 0000000000..2f54b8576a Binary files /dev/null and b/static/images/bi-finebi-en-8.png differ diff --git a/static/images/bi-finebi-en-9.png b/static/images/bi-finebi-en-9.png new file mode 100644 index 0000000000..0f69b72a87 Binary files /dev/null and b/static/images/bi-finebi-en-9.png differ diff --git a/versioned_docs/version-2.0/ecosystem/bi/finebi.md b/versioned_docs/version-2.0/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..a3ae30309a --- /dev/null +++ b/versioned_docs/version-2.0/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI Introduction + +As a business intelligence product, FineBI has a system architecture of data processing, real-time analysis, multidimensional analysis Dashboard and other functions. FineBI supports rich data source connection and analysis and management of tables with multiple views. FineBI can successfully support the modeling and visualization of internal and external data of Apache Doris. + +## Precondition + +Install FineBI 5.0 or later, Download link: https://www.finebi.com/ + +## Login and Connection + +1. Create account and log in FineBI + +  + +2. Select the Built-in database, If you need to select an external database configuration, the documentation is available:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + It is recommended to select the built-in database as the information repository of FineBI. The database type selected here is not the target database for querying and analyzing data, but the database for storing and maintaining FineBI model, dashboard and other information. FineBI needs to add, delete, modify and check it. + ::: + +  + +3. Click the Management System button and select the database connection management in Data Connections to create a new database connection. + +  + +4. On the new database connection page, select MySQL database + +  + +5. Fill in the link information of the Doris database + + - Parameters are described as follows: + + - Username:The username for logging into Doris。 + + - Password:Password of the current user。 + + - Host:IP address of the FE host in the Doris cluster。 + + - Port:FE query port of the Doris cluster。 + + - Coding:Encoding format of the Doris cluster。 + + - Name Database:Target database in Doris cluster。 + +  + +6. Click the test link. Connection succeeded is displayed when the connection information is correct + +  + +## Create model + +1. In the "Public Data" section, click to create a new dataset. Then click the database table + +  + +2. You need to import tables in the existing database connection + +  + +3. You need to refresh each imported table after importing the table. You can analyze the table in the topic only after refreshing the table + +  + +4. Add the imported public data to the edited topic, and then conduct compass analysis and configuration according to business logic. + +  \ No newline at end of file diff --git a/versioned_docs/version-2.1/ecosystem/bi/finebi.md b/versioned_docs/version-2.1/ecosystem/bi/finebi.md new file mode 100644 index 0000000000..a3ae30309a --- /dev/null +++ b/versioned_docs/version-2.1/ecosystem/bi/finebi.md @@ -0,0 +1,95 @@ +--- +{ + "title": "FineBI", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +## FineBI Introduction + +As a business intelligence product, FineBI has a system architecture of data processing, real-time analysis, multidimensional analysis Dashboard and other functions. FineBI supports rich data source connection and analysis and management of tables with multiple views. FineBI can successfully support the modeling and visualization of internal and external data of Apache Doris. + +## Precondition + +Install FineBI 5.0 or later, Download link: https://www.finebi.com/ + +## Login and Connection + +1. Create account and log in FineBI + +  + +2. Select the Built-in database, If you need to select an external database configuration, the documentation is available:https://help.fanruan.com/finebi/doc-view-437.html + + :::info Note + It is recommended to select the built-in database as the information repository of FineBI. The database type selected here is not the target database for querying and analyzing data, but the database for storing and maintaining FineBI model, dashboard and other information. FineBI needs to add, delete, modify and check it. + ::: + +  + +3. Click the Management System button and select the database connection management in Data Connections to create a new database connection. + +  + +4. On the new database connection page, select MySQL database + +  + +5. Fill in the link information of the Doris database + + - Parameters are described as follows: + + - Username:The username for logging into Doris。 + + - Password:Password of the current user。 + + - Host:IP address of the FE host in the Doris cluster。 + + - Port:FE query port of the Doris cluster。 + + - Coding:Encoding format of the Doris cluster。 + + - Name Database:Target database in Doris cluster。 + +  + +6. Click the test link. Connection succeeded is displayed when the connection information is correct + +  + +## Create model + +1. In the "Public Data" section, click to create a new dataset. Then click the database table + +  + +2. You need to import tables in the existing database connection + +  + +3. You need to refresh each imported table after importing the table. You can analyze the table in the topic only after refreshing the table + +  + +4. Add the imported public data to the edited topic, and then conduct compass analysis and configuration according to business logic. + +  \ No newline at end of file diff --git a/versioned_sidebars/version-2.0-sidebars.json b/versioned_sidebars/version-2.0-sidebars.json index 9d53532a37..cc467cd085 100644 --- a/versioned_sidebars/version-2.0-sidebars.json +++ b/versioned_sidebars/version-2.0-sidebars.json @@ -496,6 +496,7 @@ "ecosystem/bi/apache-superset", "ecosystem/bi/dbeaver", "ecosystem/bi/datagrip", + "ecosystem/bi/finebi", "ecosystem/bi/powerbi" ] } diff --git a/versioned_sidebars/version-2.1-sidebars.json b/versioned_sidebars/version-2.1-sidebars.json index 10319028ff..2a6d9b98bb 100644 --- a/versioned_sidebars/version-2.1-sidebars.json +++ b/versioned_sidebars/version-2.1-sidebars.json @@ -509,6 +509,7 @@ "ecosystem/bi/apache-superset", "ecosystem/bi/dbeaver", "ecosystem/bi/datagrip", + "ecosystem/bi/finebi", "ecosystem/bi/powerbi" ] } --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org