Solution : https://service.sap.com/sap/support/notes/1156101 (Connexion à SAP Service Marketplace requise)
Résumé :
L'exécution d'une requête MDX peut entraîner des résultats incorrects, différents de ceux des requêtes BI similaires. Les termes pertinents incluent MDX, OLAP et XML pour l'analyse. Les problèmes sont liés à des défauts de l'interface MDX, détaillés dans la section "Related Notes" qui recense les corrections nécessaires. Il est conseillé aux utilisateurs de vérifier ces notes et de les appliquer si nécessaire. Il est préférable d'importer un Pack de Support récent plutôt que des corrections individuelles, garantissant ainsi une solution complète aux problèmes décrits.
Mots Clés :
recent support package, mdx statement delivers, incorrect data reason, incorrect data, selection delivers, mdx interface, incorrect result, symptom executing, related notes, notes mentioned
Notes associées :
| 1592764 | MDX: Precision when displaying formatted value |
| 1590976 | MDX: Incorrect data for IIF |
| 1588887 | MDX:Incorr data if 'Use Sel. of Structure Elements" inactive |
| 1576958 | MDX: Empty cells for BW queries w/characteristic structures |
| 1574984 | MDX: Too many characteristic structure elements are read |
| 1572964 | MDX: Data incorrect for calculated member/calculated measure |
| 1551587 | MDX: SUBSELECT and external hierarchies |
| 1529720 | MDX: No data for calculated member and metadata reference |
| 1524724 | MDX: BAPI GET_MEMBERS, duplicate display of Self member |
| 1520064 | MDX: Incorrect data for calculated measures with AVG or IIF |
| 1514733 | MDX: Flattening: Header text is missing for default measure |
| 1510967 | MDX: Set with numerous Members: Missing data |
| 1509860 | MDX: Follow-on note to Note 1499233 - bXML flattening |
| 1506320 | MDX: Empty cell rowset when default measures are used |
| 1505033 | MDX: Generate: Not enough data |
| 1499233 | MDX:bXML flattening, unbalanced hierarchy, empty columns |
| 1494861 | MDX: Restricting to # does not work for NUMC |
| 1485648 | MDX: bXML flattening and hierarchies and displaced columns |
| 1478973 | MDX: Missing data for calculated member |
| 1464823 | MDX: Too much data if SUBSELECTs are used |
| 1461146 | MDX: Incorrect data when the query result is very large |
| 1459126 | MDX: Incorrect values for COUNT( |
| 1458159 | MDX: Blank cells when using calculated members |
| 1457856 | MDX: Missing values for calculated members |
| 1455729 | MDX: No data for StrToMember( |
| 1453365 | MDX: Missing values for structure elements & DefaultMember |
| 1446750 | OLE DB for OLAP: Restriction on MEMBER_CAPTION and [ALL] |
| 1443383 | MDX: No data for calculated members |
| 1438935 | MDX: No data during LastPeriods( |
| 1435844 | MDX:Wrong no. decimal places for basXML flattening interface |
| 1435289 | MDX: Sorting incorrect for Hierarchize( |
| 1435193 | MDX: Incorrect data due to optimized IIF statement |
| 1432162 | MDX: Flattening problems when using hierarchies |
| 1430003 | MDX: Incorrect data with Filter() w/ more than one dimension |
| 1420169 | MDX: bXML flattening: Subsequent note |
| 1415622 | MDX: Empty cells in calculated measure and structure |
| 1412732 | MDX: Ascendants function does not return member |
| 1407607 | MDX: IS operator does not recognize equality |
| 1405993 | MDX: Error: Invalid MDX command with CURRENTMEMBER |
| 1404328 | MDX: bXML flattening and PROPERTIES: Columns overwritten |
| 1402674 | MDX: Descendants delivers incorrect results for NON EMPTY |
| 1399686 | MDX: bXML flattening returns incorrect column values |
| 1399684 | MDX: Flattening returns incorrectly formatted data |
| 1390065 | MDX: Accelerating bXML |
| 1366257 | MDX: Incorrect display of unit for division |
| 1364717 | MDX: No data for NON EMPTY in combination with NULL in CM |
| 1358989 | MDX: bXML-WebI: No cell data when no DIM is in the drilldown |
| 1349701 | MDX: Missing values for structures and calculated measures |
| 1348567 | MDX: Duplicate tuple for Crossjoin() and Descendants() |
| 1338332 | MDX: Fixed filter and dynamic selection of point nodes |
| 1298204 | MDX: DESCENDANTS w/LEAVES incorrect data + COVARIANCE + rank |
| 1285802 | MDX: Empty cells for function COUNT( |
| 1278268 | No data in transient InfoProvider (Classic InfoSet) |
| 1277006 | MDX: Empty cells with NON EMPTY and calculated members |
| 1270884 | OLE DB for OLAP: No properties for long dimension names |
| 1270817 | MDX:Incorrect data w/ AddCalculatedMembers,StripCalc.Members |
| 1270138 | MDX: Incorrect data for very large no. of calculated members |
| 1265072 | MDX: No data in a very specific situation |
| 1257723 | OLE DB for OLAP: Short length specified for MEMBER_CAPTION |
| 1254300 | MDX: No values for property DESCRIPTION |
| 1254205 | OLE DB for OLAP: Data type for properties |
| 1254063 | OLE DB for OLAP: Field MES_AGGREGATOR is blank |
| 1251504 | MDX: Blank cells when using calculated members |
| 1250186 | OLE DB for OLAP: Short length spec. for compounded members |
| 1247514 | MDX: Level too high for descendants() and ancestor() |
| 1236483 | MDX: No values for property CUBE_NAME |
| 1232528 | MDX: Calculated measure constant returns empty cell |
| 1229379 | OLE DB for OLAP: Initial fields for calculated key figures |
| 1225230 | OLE DB for OLAP: Incorrect value for field DIM_CARDINALITY |
| 1223370 | MDX: Empty cells during NON EMPTY and |
| 1168013 | MDX: Not enough data for GENERATE and NON EMPTY |
| 1166733 | MDX: Handling interval limits in the MDX |
| 1165156 | MDX: Results dependent on application server for intervals |
| 1162797 | MDX: Incorrect member for |
| 1157404 | MDX: Missing data for calculated members |
| 1156176 | MDX: Missing data for |
| 1156035 | MDX: NON EMPTY data set does not deliver results |
| 1153780 | MDX: Empty cells despite existing key figure values |
| 1137528 | MDX: Data missing, NON EMPTY and calculated member |
| 1127468 | MDX: Missing values in numerical value functions |
| 1094236 | MDX: Missing values due to use of calculated members |
| 838800 | Composite SAP Note for consulting notes about MDX/OLAP BAPIs |