Problem:
Some fields with the same meaning in the database differ in terms of uppercase and lowercase letters, such as Alice and alice, as shown in the following figure.
When enabling Direct-Connected Data in FineBI and directly connecting to the database to create a dashboard for analysis, you may find that the content displayed on the editing page is inconsistent with that on the preview page. Specifically, it includes the following aspects.
1. In the dashboard editing state, perform filtering for the field by selecting Alice from the drop-down list (excluding alice), as shown in the following figure.
2. In this way, the result of the component on the dashboard editing page is shown as follows.
3. Preview the dashboard, and the result is displayed as follows.
Cause:
In the dashboard editing state, the internal logic of BI is adopted for direct-connected data to distinguish between uppercase and lowercase letters while in the dashboard preview state, it follows the logic of each database instead of that of BI.
1. In the dashboard editing state, the data for the filter component is obtained from the database through the group by statement. If the group by statement in the database is not case-sensitive, Alice and alice will be recognized as the same value, and the one that appears ahead is displayed only. This may explain why only Alice is displayed in the case.
2. After selecting Alice as the filtering condition, the uppercase letters are distinguished from lowercase letters, that is, Alice can only match with Alice, so the filtering result only shows Alice's data.
3. In the dashboard preview state, depending on the nature of the database, if the database is case-insensitive, both Alice and alice can match with Alice, so the filtering result will display data for both Alice and alice.
Solution:
You can modify whether the direct-connected data is case-sensitive or not. You may search for specific modification methods according to the database type.
