{"id":1078,"date":"2022-07-05T06:56:00","date_gmt":"2022-07-05T04:56:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1078"},"modified":"2022-10-05T17:06:11","modified_gmt":"2022-10-05T15:06:11","slug":"masquer-organiser-indicateurs-ssas","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/","title":{"rendered":"Masquer et organiser les indicateurs SSAS en MDX"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><em><strong>Comment masquer et organiser les indicateurs d&rsquo;un cube SSAS dans des dossiers en code MDX ?<\/strong><\/em><\/h4>\n\n\n\n<p>Le but est de permettre de regrouper les indicateurs pour les utilisateurs finaux des cubes Analysis Services. En effet, parcourir un cube SSAS depuis Microsoft Excel ou Power BI pour du Reporting Ad-Hoc est tr\u00e8s pratique. Cependant, si la liste des <a href=\"https:\/\/expert-only.com\/ssas\/valeur-mediane-membres-ssas-en-mdx\/\">mesures calcul\u00e9es en MDX<\/a> fait plusieurs dizaines ou centaines d&rsquo;\u00e9l\u00e9ments, il faut les classer. Id\u00e9alement les classer par groupes fonctionnels. Et par sous-groupes organis\u00e9s par l&rsquo;axe temps. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-code-mdx-pour-structurer-les-indicateurs-calcules-ssas-dans-des-dossiers\">Code MDX pour structurer les indicateurs calcul\u00e9s SSAS dans des dossiers<\/h2>\n\n\n\n<p>Premi\u00e8rement, toutes <a href=\"https:\/\/expert-only.com\/power-bi\/total-annee-en-cours-avec-power-bi-ytd\/\">les mesures calcul\u00e9es en YTD<\/a> sont regroup\u00e9es par domaine fonctionnel. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Exemple de structuration des indicateurs SSAS par domaines fonctionnels<\/h3>\n\n\n\n<p>Voici un exemple volontairement simple mais explicite pour classer les indicateurs SSAS, avec un classement dans des dossiers pour les ventes et les stocks: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Ventes<ul><li>Ventes YTD (Year-To-Date)<\/li><li>Ventes QTD (Quarter-To-Date)<\/li><li>Ventes MTD (Month-To-Date)<\/li><li>Ventes LY (Last Year)<\/li><li>Ventes LM (Last Month)<\/li><\/ul><\/li><li>Stock<ul><li>Stock YTD (Year-To-Date)<\/li><li>Stock QTD (Quarter-To-Date)<\/li><li>Stock MTD (Month-To-Date)<\/li><li>Stock LY (Last Year)<\/li><li>Stock LM (Last Month)<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>En effet les donn\u00e9es financi\u00e8res sont souvent associ\u00e9es \u00e0 l&rsquo;ann\u00e9e pass\u00e9e, au trimestre pass\u00e9 et au mois pass\u00e9. Et aux p\u00e9riodes en cours, comme le mois courant, le trimestre courant ou l&rsquo;ann\u00e9e courante.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Propri\u00e9t\u00e9s MDX pour g\u00e9rer le format, la visibilit\u00e9 et les dossiers des indicateurs Analysis Services<\/h3>\n\n\n\n<p>D&rsquo;autre part, il est pr\u00e9f\u00e9rable de classer les <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/analysis-services\/multidimensional-models\/measures-and-measure-groups?view=asallproducts-allversions\" target=\"_blank\" rel=\"noopener noreferrer\">mesures<\/a> de mani\u00e8re fonctionnelle plut\u00f4t que dans des dossiers techniques. Pour une plus grande ergonomie dans le Reporting depuis les cubes, utiliser les propri\u00e9t\u00e9s suivantes :<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>MDX DISPLAY_FOLDER<\/li><li>VISIBLE<\/li><li>FORMAT_STRING<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">3. Exemple de code MDX pour g\u00e9rer les indicateurs calcul\u00e9s<\/h3>\n\n\n\n<p>Troisi\u00e8mement, cet exemple de code MDX cr\u00e9e un indicateur calcul\u00e9 bas\u00e9 sur un groupe de mesures dans notre fichier avec l&rsquo;extension <em>.cube<\/em>. Ce groupe de mesures contient habituellement un ou plusieurs champs issus d&rsquo;une table pr\u00e9c\u00e9demment cr\u00e9\u00e9e dans la Vue de donn\u00e9es nomm\u00e9es <em>Vue_Exemple.dsv<\/em> :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE MEMBER CURRENTCUBE.[Measures].[Domaine - Ventes] AS [Measures].[Montant - Groupe],\nFORMAT_STRING = \"#,##0.00 \u20ac;-#,##0.00 \u20ac\",\nVISIBLE = 1 ,\nDISPLAY_FOLDER = 'Ventes';<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-explication-du-code-mdx-pour-presenter-les-mesures-calculees-dans-un-dossier\">Explication du code MDX pour pr\u00e9senter les mesures calcul\u00e9es dans un dossier<\/h4>\n\n\n\n<p>Finalement, cet exemple de script <strong><a href=\"https:\/\/expert-only.com\/concepts\/definition-mdx-multidimensional-expressions\/\">MDX<\/a><\/strong> permet de facilement masquer et organiser les indicateurs SSAS en dossiers. Explication du code :&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Commencer par cr\u00e9er l\u2019indicateur dans le cube et indiquer le groupe de mesures sur lequel est bas\u00e9 l&rsquo;indicateur SSAS avec la commande <em><strong>MDX CREATE MEMBER &lt;&#8230;&gt; AS<\/strong><\/em>.<\/li><li>Indiquer ensuite le format des donn\u00e9es qui sera s\u00e9par\u00e9 par une virgule tous les 3 chiffres. Ou avec 2 chiffres apr\u00e8s la virgule et en monnaie euros (signe \u20ac) en utilisant la propri\u00e9t\u00e9 <strong><em>FORMAT_STRING<\/em><\/strong>.<\/li><li>R\u00e9gler la propri\u00e9t\u00e9 MDX <strong><em>VISIBLE<\/em><\/strong> \u00e0 1 pour afficher l&rsquo;indicateur aux utilisateurs. A v\u00e9rifier depuis l&rsquo;explorateur et la connexion SSAS depuis Excel ou Power BI par exemple.<\/li><li>Indiquer quel dossier contiendra l&rsquo;indicateur calcul\u00e9 avec la propri\u00e9t\u00e9 <strong><em>DISPLAY_FOLDER<\/em><\/strong>. Dans notre exemple de cube, l&rsquo;indicateur sera visible dans le dossier \u00ab\u00a0Ventes\u00a0\u00bb.<\/li><\/ol>\n\n\n\n<p>Enfin, ces quelques astuces expliquent comment mieux organiser et pr\u00e9senter les indicateurs dans les <a href=\"https:\/\/expert-only.com\/ssas\/cubes-ssas-rolap-molap-holap\/\">cubes OLAP<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"gubE8AZy9s\"><a href=\"https:\/\/expert-only.com\/fr\/ssas\/differences-cubes-rolap-holap-molap\/\">Diff\u00e9rences entre les cubes ROLAP HOLAP et MOLAP<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Diff\u00e9rences entre les cubes ROLAP HOLAP et MOLAP\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssas\/differences-cubes-rolap-holap-molap\/embed\/#?secret=w3llqtevuA#?secret=gubE8AZy9s\" data-secret=\"gubE8AZy9s\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment masquer et organiser les indicateurs d&rsquo;un cube SSAS dans des dossiers en code MDX ? Le but est de permettre de regrouper les indicateurs pour les utilisateurs finaux des cubes Analysis Services. En effet, parcourir un cube SSAS <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\" title=\"Masquer et organiser les indicateurs SSAS en MDX\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10657,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":{"0":"post-1078","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssas"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Masquer et organiser les indicateurs SSAS en MDX - OLAP<\/title>\n<meta name=\"description\" content=\"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Masquer et organiser les indicateurs SSAS en MDX\" \/>\n<meta property=\"og:description\" content=\"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-05T04:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-05T15:06:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Masquer et organiser les indicateurs SSAS en MDX\",\"datePublished\":\"2022-07-05T04:56:00+00:00\",\"dateModified\":\"2022-10-05T15:06:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\"},\"wordCount\":546,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg\",\"articleSection\":[\"SSAS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\",\"name\":\"Masquer et organiser les indicateurs SSAS en MDX - OLAP\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg\",\"datePublished\":\"2022-07-05T04:56:00+00:00\",\"dateModified\":\"2022-10-05T15:06:11+00:00\",\"description\":\"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Masquer et organiser les indicateurs SSAS en MDX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Masquer et organiser les indicateurs SSAS en MDX - OLAP","description":"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/","og_locale":"fr_FR","og_type":"article","og_title":"Masquer et organiser les indicateurs SSAS en MDX","og_description":"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.","og_url":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-05T04:56:00+00:00","article_modified_time":"2022-10-05T15:06:11+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Masquer et organiser les indicateurs SSAS en MDX","datePublished":"2022-07-05T04:56:00+00:00","dateModified":"2022-10-05T15:06:11+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/"},"wordCount":546,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg","articleSection":["SSAS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/","url":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/","name":"Masquer et organiser les indicateurs SSAS en MDX - OLAP","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg","datePublished":"2022-07-05T04:56:00+00:00","dateModified":"2022-10-05T15:06:11+00:00","description":"Masquer et organiser les indicateurs SSAS dans des dossiers avec du code MDX et les options comme DISPLAY_FOLDER et VISIBLE.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-14583399EA5_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssas\/masquer-organiser-indicateurs-ssas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Masquer et organiser les indicateurs SSAS en MDX"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1078"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1078\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10657"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}