Caption management

Last modified by mrochelle on 2020/07/30 15:14

Captions allow you to change the displayed text of a dimension.
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

Captions from the same data model

  • The data model contains the id and the caption of the dimension
    • Example : ID Client in the database and its common name

Click on the dimension (ID Client in the example) that must have a caption
In the caption option, choose the column to display
https://lh4.googleusercontent.com/_P3tfMbX7ggK6GNvgr-Q043_q_IlT8G3RkUgW7J6OV7Yj4RRBYKU9-UMSAV0wdIAWQdBBWItd8spLgXYvIsW-SGruVYAjXK91bqA314PGPYnyyISiQw2CvsMC5lRGbcfcZYB9M8_VEI

Caption from external data model

  • “star type” modelisation. The data model contains the id (fact table) and another data model contains the ID and the associated caption

https://lh6.googleusercontent.com/sgSH5VBF4f0-9ee15iq_oE_wbPH2Q0G6JmWAFBm68S_ZwB-wiCfg5is18davV6kNI-x4JzqdgiBdWzjXIfoHYTicV5fzzAsduhpJVyzue9ygvzRiiRy9XJmK8xcSwhqZkFKc_yUl_bM