K
K
kidar22014-08-06 09:19:33
SQL
kidar2, 2014-08-06 09:19:33

How to write percentage metric in mdx?

There is such a simple cube:
Dim1: Browser with elements: FF, Chrome, IE, bot
Dim2: Calendar with daily dynamics
Metric - Number of
records the following expression is obtained:

member bla as 100 * aggregate(except([Browser].members, [Browser].[bot]), [Measures].[Number of records])/ [Measures].[Number of records]

    select [Calendar] on columns,
             [Browser] on rows
    where bla

          01-01-2014 02-01-2014
FF 500 600
Chrome 200 300
IE ...
But here we will see not interest at all, but their sum for all days, which is not true. How to make interest?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question