Mdx Query Problem

Question

Hi I m working on mdx query ,and i thought i solved a problem but.... I ve created a calculated member

iif(
  isleaf([DimensionArtikujDG].[DimensionArtikujDG].CurrentMember),
         ([Measures].[Sasia])*(1/[Measures].[Koeficienti]),
        Sum(
          Descendants(
            [DimensionArtikujDG].DimensionArtikujDG].CurrentMember,,LEAVES),
            ([Measures].[Sasia])*(1/[Measures].[Koeficienti])
        )
)

When [DimensionArtikujDG].[DimensionArtikujDG] is inside the pivot table it works fine. When i take this dimension at the reports filter area and filter two or three elements the total in report area does not change. It remains the total without the filters being applied. Don t know if i explained it correctly. Would apprceiate any kind of help

score 1 · Answer 1 · answered May 21 '11 at 08:43

The issue is the value of your currentMember when evaluating the expression. A way to understand what is going on is changing your expression to :

[DimensionArtikujDG].[DimensionArtikujDG].CurrentMember.name

As you're using a set in your slicer (aka WHERE) currentMember is not well defined (in icCube we throw an error). Maybe the server you're using is taking the defaultmember (likely [All]).

Solution: this will depend on the Olap Server you're using. As a hint look how to define a special rollup for your dimension.

Mdx Query Problem

1 Answers1