Hi,

I have two separate MDX queries each of which gives me a proper resultset:

Query1:
SELECT NON EMPTY { { { [Claim Type].[Claim Type].&[2] } * {
[Measures].[Number of Lines] } } } ON COLUMNS , NON EMPTY { { { [Provider
Number].[All Provider Number].CHILDREN } * { [Revenue Code].[Revenue
Code].&[310] } * { [Provider Name].[All Provider Name].CHILDREN } } } ON
ROWS FROM [Procedure]

Query2:
SELECT NON EMPTY { { { [Claim Type].[Claim Type].&[2] } * {
[Measures].[Number of Lines] } } } ON COLUMNS , NON EMPTY { { { [Provider
Number].[All Provider Number].CHILDREN } * { [Revenue Code].[Revenue
Code].&[840] } * { [Provider Name].[All Provider Name].CHILDREN } } } ON
ROWS FROM [Procedure]

When I try to combine both these queries as follows, I get a blank
resultset:

SELECT NON EMPTY { { { [Claim Type].[Claim Type].&[2] } * {
[Measures].[Number of Lines] } } } ON COLUMNS , NON EMPTY { { { [Provider
Number].[All Provider Number].CHILDREN } * { [Revenue Code].[Revenue
Code].&[310], [Revenue Code].[Revenue Code].&[840] } * { [Provider
Name].[All Provider Name].CHILDREN } } } ON ROWS FROM [Procedure]

Any idea why this is happening?

Thanks,

Chumma Dede

Anyone have any idea why this is happening?

Thanks!

"Chumma Dede" <deja.removethis (AT) chothu (DOT) mailshell.com> wrote