Wiki source code of Gestion des légendes
Last modified by Aurelie Bertrand on 2020/10/16 19:20
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | Captions allow you to change the displayed text of a dimension. | ||
| 2 | Ie : If you have a client_id and client_name dimensions, you can choose to display the client_name when you use the client_id in a graph | ||
| 3 | |||
| 4 | = Captions from the same data model = | ||
| 5 | |||
| 6 | * The data model contains the id and the caption of the dimension | ||
| 7 | ** Example : ID Client in the database and its common name | ||
| 8 | |||
| 9 | Click on the dimension (ID Client in the example) that must have a caption | ||
| 10 | In the caption option, choose the column to display | ||
| 11 | [[image:https://lh4.googleusercontent.com/_P3tfMbX7ggK6GNvgr-Q043_q_IlT8G3RkUgW7J6OV7Yj4RRBYKU9-UMSAV0wdIAWQdBBWItd8spLgXYvIsW-SGruVYAjXK91bqA314PGPYnyyISiQw2CvsMC5lRGbcfcZYB9M8_VEI||height="214" width="498"]] | ||
| 12 | |||
| 13 | = Caption from external data model = | ||
| 14 | |||
| 15 | * “star type” modelisation. The data model contains the id (fact table) and another data model contains the ID and the associated caption | ||
| 16 | |||
| 17 | [[image:https://lh6.googleusercontent.com/sgSH5VBF4f0-9ee15iq_oE_wbPH2Q0G6JmWAFBm68S_ZwB-wiCfg5is18davV6kNI-x4JzqdgiBdWzjXIfoHYTicV5fzzAsduhpJVyzue9ygvzRiiRy9XJmK8xcSwhqZkFKc_yUl_bM||height="251px;" width="758px;"]] | ||
| 18 | |||
| 19 | == Example : import an external dimension == | ||
| 20 | |||
| 21 | Let's considerate two data models from two data sources : | ||
| 22 | |||
| 23 | - the first is a data model representing a fact table : //**historic_of_flux**// | ||
| 24 | [[image:1602867763968-485.png]] | ||
| 25 | |||
| 26 | - the second is a data model representing a dimension table : //**HR Final**// | ||
| 27 | [[image:1602867838412-173.png]] | ||
| 28 | |||
| 29 | This example will show how to import an external dimension related to the "Transmitter" dimension of the first data model. | ||
| 30 | |||
| 31 | 1. In the first data source model, select the dimension on which it is necesary to add an external dimension. | ||
| 32 | [[image:1602867977561-122.png]] | ||
| 33 | 1. ((( | ||
| 34 | On the "**Properties**" section, click on "**Advanced...**" | ||
| 35 | [[image:1602868130812-162.png]] | ||
| 36 | ))) | ||
| 37 | 1. ((( | ||
| 38 | On the pop-up window, check the first box "**Import external dimension from another data source**". | ||
| 39 | [[image:1602868310600-875.png]] | ||
| 40 | ))) | ||
| 41 | 1. ((( | ||
| 42 | In the "**External Dimension Selecteion**" section, click on **Select** | ||
| 43 | ))) | ||
| 44 | 1. ((( | ||
| 45 | Choose the appropriate data source containing the external dimenion | ||
| 46 | [[image:1602868437687-139.png]] | ||
| 47 | ))) | ||
| 48 | 1. ((( | ||
| 49 | Then choose the external dimension : here, we have to choose the dimension corresponding to the initial dimension. The name of the dimension can vary, but members should be the same. | ||
| 50 | [[image:1602868654368-304.png]] | ||
| 51 | ))) | ||
| 52 | 1. ((( | ||
| 53 | We can now validate the operation by clicking on OK | ||
| 54 | A pop-up message inform that this operation will override all settings currently applied to this dimension. | ||
| 55 | ))) | ||
| 56 | 1. ((( | ||
| 57 | Then, on the first data source model, we can retrieve the hierarchies corresponding to the external dimension on the dimension. Of course, we could use these hierarchies in the charts that we will configurate in DigDash. | ||
| 58 | [[image:1602868835712-701.png]] | ||
| 59 | ))) |