none
Empty values on MDX results

    Question

  • i am trying to get the data by simple MDX query like following


    Select [location][city].members on columns, [measure][count] on rows      Note:(query not same but like this sample)

    But the in the results it is giving one blank value along with city value. how to avoid that blank value.


    1.                   80
    2. Delhi          90
    3. bangalore  60
    4. chennai      70

    Here what is the 80 value. its belongs to any city value? please let me know how to avoid those empty box?

    Regards,

    Madhu.


    madhu ml

    Thursday, June 14, 2012 7:32 PM

Answers

All replies