Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

SAP BW MDX Query

Udzielono odpowiedzi
Zamów wersję demonstracyjną
  • Edytowano

Hello All

We have an MDX query which shows only the text column and no key. But the same query when executed in Analysis for Office and RSRT in BW works fine. So would like to know if there should be any settings performed to run the MDX query to display the Key and TEXT.

Also i see two options to execute the MDX query interfacing like flattening or Multidimensional, gives the same. in the first column as Text. also we have the duplicate values above the marked in yellow are one set and below are another.. where it shows repeated.

Thanks

0

Komentarze

Komentarze: 1

Data Głosy
  • Oficjalny komentarz
    Brett Harper

    I'm not sure exactly what is wrong from what you show, but some general information that might help:

    Given a standard MDX query defining your axes (rows, columns) and measures (used to compute value of the cell at the intersection of the coordinates of these dimension members.

    In a Flattened output each row is a unique permutation of the dimensions specified for the columns, so it is expected that repeated values might come out if those values don't depend on the member values.  For example, AC_CATEG=ACTUAL, CONSUNIT=1000 calculates the same as AC_CATEG=ACTUAL, CONSUNIT=""

    Key vs. Text: By default, most MDX implementations return the key of a dimension member. To get the descriptive text, you'll usually need to explicitly request it. This often involves functions like MEMBER_CAPTION, MEMBER_NAME, or properties like [Dimension].[Hierarchy].[Member].Properties("Caption"). The exact syntax depends on your BW version and the specific dimension.

    SELECT 
        {[Measures].[Sales Amount]} ON COLUMNS,
        {
            MEMBER_CAPTION([Customers].[Customer].[Customer1]), // Get text for Customer1
            [Customers].[Customer].[Customer2].Properties("Caption") // Another way to get text
        } ON ROWS
    FROM [Your Cube]

    Mapping: When the processing of the output of RSR_MDX_GET_FLAT_DATA happens, it should use the information from RSR_MDX_GET_AXIS_INFO to correctly interpret the data. If an axis element was defined in your MDX to return text (using MEMBER_CAPTION or similar), the corresponding data in RSR_MDX_GET_FLAT_DATA will contain that text. Otherwise, it will be the key.

Zaloguj się, aby dodać komentarz.