Discussion :

[Sieldev]

Salut,

Dans une requête MDX généree par le query designer de SSRS, je souhaiterai ajouter un filtre sur la colonne [Code Langue]. Cependant vu mon peu de connaissance en MDX je ne sais pas ou le placer.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
 SELECT { } ON COLUMNS, { ([Lexicon].[Account Code].[Account Code].ALLMEMBERS * [Lexicon].[Agent].[Agent].ALLMEMBERS * [Lexicon].[Agent Code].[Agent Code].ALLMEMBERS * [Lexicon].[Agent First Name].[Agent First Name].ALLMEMBERS * [Lexicon].[Agent Last Name].[Agent Last Name].ALLMEMBERS * [Lexicon].[Agent Title].[Agent Title].ALLMEMBERS * [Lexicon].[Asset].[Asset].ALLMEMBERS * [Lexicon].[Card].[Card].ALLMEMBERS * [Lexicon].[Card Code].[Card Code].ALLMEMBERS * [Lexicon].[Case].[Case].ALLMEMBERS * [Lexicon].[Case Lock].[Case Lock].ALLMEMBERS * [Lexicon].[Case Number].[Case Number].ALLMEMBERS * [Lexicon].[Category].[Category].ALLMEMBERS * [Lexicon].[Comments].[Comments].ALLMEMBERS * [Lexicon].[Component].[Component].ALLMEMBERS * [Lexicon].[Configuration].[Configuration].ALLMEMBERS * [Lexicon].[Configuration Code].[Configuration Code].ALLMEMBERS * [Lexicon].[Contact].[Contact].ALLMEMBERS * [Lexicon].[Contact Account Code].[Contact Account Code].ALLMEMBERS * [Lexicon].[Contact Closure].[Contact Closure].ALLMEMBERS * [Lexicon].[Contact Code].[Contact Code].ALLMEMBERS * [Lexicon].[Contact First Name].[Contact First Name].ALLMEMBERS * [Lexicon].[Contact Follow-up].[Contact Follow-up].ALLMEMBERS * [Lexicon].[Due Date].[Due Date].ALLMEMBERS * [Lexicon].[Contact Last Name].[Contact Last Name].ALLMEMBERS * [Lexicon].[Contact Title].[Contact Title].ALLMEMBERS * [Lexicon].[Contract].[Contract].ALLMEMBERS * [Lexicon].[Email Type].[Email Type].ALLMEMBERS * [Lexicon].[Environment].[Environment].ALLMEMBERS * [Lexicon].[Freeze].[Freeze].ALLMEMBERS * [Lexicon].[Freeze Date].[Freeze Date].ALLMEMBERS * [Lexicon].[General Interest].[General Interest].ALLMEMBERS * [Lexicon].[Interlocutor].[Interlocutor].ALLMEMBERS * [Lexicon].[Item].[Item].ALLMEMBERS * [Lexicon].[Item Version].[Item Version].ALLMEMBERS * [Lexicon].[Keyword].[Keyword].ALLMEMBERS * [Lexicon].[Question].[Question].ALLMEMBERS * [Lexicon].[Link File].[Link File].ALLMEMBERS * [Lexicon].[Origin].[Origin].ALLMEMBERS * [Lexicon].[Overdue].[Overdue].ALLMEMBERS * [Lexicon].[Parent Case].[Parent Case].ALLMEMBERS * [Lexicon].[Question Date].[Question Date].ALLMEMBERS * [Lexicon].[Queue].[Queue].ALLMEMBERS * [Lexicon].[Recipient].[Recipient].ALLMEMBERS * [Lexicon].[Recipients Emails].[Recipients Emails].ALLMEMBERS * [Lexicon].[Reporting].[Reporting].ALLMEMBERS * [Lexicon].[Response].[Response].ALLMEMBERS * [Lexicon].[Response Date].[Response Date].ALLMEMBERS * [Lexicon].[Service Option].[Service Option].ALLMEMBERS * [Lexicon].[Sub-contractor].[Sub-contractor].ALLMEMBERS * [Lexicon].[Severity].[Severity].ALLMEMBERS * [Lexicon].[Severity Duration Type].[Severity Duration Type].ALLMEMBERS * [Lexicon].[Status].[Status].ALLMEMBERS * [Lexicon].[Status Type].[Status Type].ALLMEMBERS * [Lexicon].[Sub-contractor Code].[Sub-contractor Code].ALLMEMBERS * [Lexicon].[Supplier].[Supplier].ALLMEMBERS * [Lexicon].[Team].[Team].ALLMEMBERS * [Lexicon].[Team Code].[Team Code].ALLMEMBERS * [Lexicon].[Time Billed].[Time Billed].ALLMEMBERS * [Lexicon].[Time Spent].[Time Spent].ALLMEMBERS * [Lexicon].[Transfer Date].[Transfer Date].ALLMEMBERS * [Lexicon].[Transfered Team Code].[Transfered Team Code].ALLMEMBERS * [Lexicon].[Type].[Type].ALLMEMBERS * [Lexicon].[Warning-zone].[Warning-zone].ALLMEMBERS * [Lexicon].[Within-deadline].[Within-deadline].ALLMEMBERS * [Lexicon].[Culture].[Culture].ALLMEMBERS * [Lexicon].[Code Langue].[Code Langue].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [NeocaseDW] CELL PROPERTIES VALUE
 
FILTER( 
 
[Lexicon].[Code Langue].[Code Langue]
 
, [Lexicon].[Code Langue].[Code Langue] = 1)

[Sieldev]

Je n'ai pas trouvé en ajoutant directement le code, j'ai donc appliqué un filtre dans le DataSet dans l'onglet "Filters".

[Sieldev]

J'ai lancé le Profiler pour capter la requête MDX afin de voir ou il plaçait la clause FILTER mais il ne le fait pas.
Les paramétres sont envoyés dans un schéma XML de cette manière:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
<Parameters xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis">
        <Parameter>
          <Name>[Neo_p_codelangue]</Name>
          <Value xsi:type="xsd:string">2</Value>
        </Parameter>
      </Parameters>