{"id":498,"date":"2021-05-02T16:27:54","date_gmt":"2021-05-02T14:27:54","guid":{"rendered":"https:\/\/www.goprod.net\/extras\/?p=498"},"modified":"2023-03-09T20:15:17","modified_gmt":"2023-03-09T19:15:17","slug":"dax-tcd-excel","status":"publish","type":"post","link":"https:\/\/www.goprod.net\/extras\/office\/dax-tcd-excel\/","title":{"rendered":"Dax, TCD, Excel"},"content":{"rendered":"

[et_pb_section fb_built=\u00a0\u00bb1″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_row _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_text _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb]<\/p>\n

Mod\u00e9liser \u00e0 l’aide de plusieurs tables<\/h2>\n

Bien souvent, un fichier plat (en deux dimensions) ne suffit pas \u00e0 repr\u00e9senter la r\u00e9alit\u00e9 d’une situation. Un mod\u00e8le en \u00e9toile utilisant plusieurs tableaux devient alors n\u00e9cessaire.<\/p>\n

On parle alors de tables de faits autour desquelles gravitent des tables de dimensions.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=\u00a0\u00bb1_2,1_2″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_column type=\u00a0\u00bb1_2″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_image src=\u00a0\u00bbhttps:\/\/www.goprod.net\/extras\/wp-content\/uploads\/2021\/05\/daxExcel2.png\u00a0\u00bb alt=\u00a0\u00bbmod\u00e8le en \u00e9toile\u00a0\u00bb title_text=\u00a0\u00bbdaxExcel2″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][\/et_pb_image][\/et_pb_column][et_pb_column type=\u00a0\u00bb1_2″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_text _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb]<\/p>\n

sch\u00e9ma classique<\/h2>\n

Les tables de dimensions sont alors reli\u00e9es \u00e0 la table de faits par des relations de un \u00e0 plusieurs sur le principe \u00ab\u00a0un client passe une ou plusieurs commandes\u00a0\u00bb.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_column type=\u00a0\u00bb4_4″ _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb][et_pb_text _builder_version=\u00a0\u00bb4.16″ _module_preset=\u00a0\u00bbdefault\u00a0\u00bb global_colors_info=\u00a0\u00bb{}\u00a0\u00bb theme_builder_area=\u00a0\u00bbpost_content\u00a0\u00bb]<\/p>\n

objectifs<\/h2>\n

En imaginant un cas simple compos\u00e9 d’une table clients et d’une table commandes, comment calculer le montant des remises accord\u00e9es aux clients.<\/p>\n

 <\/p>\n

les \u00e9tapes<\/h2>\n