Post reply

Problems solving DISTINCT-COUNT SQL-Query in MDX

  • November 15, 2005 at 3:12 am

    #111186

    Hello there,

    my task is to realize an existing reporting-system via OLAP.

    In this case I have the following SQL-query on a table.

    select count (distinct (IDofPatient + GenderOfPatient + Department) as XY

    from table where Date >= ......

    I've read a lot about functions like count, distinctcount, generate, crossjoin...

    All the samples i found don't match these requirements.

    I think its possible to solve this but i have lost overview for that. Could anyone give me a hint for that?

    Thanks in advance. Tobi

  • November 18, 2005 at 8:23 am

    #604654

    If your using AS2000 one option would be to have a seperate cube with the distinct count and then join that with the original with the rest of hte data in a virtual cube.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply