help needed on OLAP cubes

Question

Hi,

While processing an SSAS cube, the query that I got from processing window like "under SQL queries 1" is producing resultset, but when the processing is done and the measures are pulled into the brower, the values do not show up.

What could be the reason???

Answer 1

Most likely, you have a default member set on some dimension that's filtering out results. Ensure that all of your dimensions are at the "All" level, and that your measure is additive in some way.