Empty Cells -
07-10-2003
, 10:56 AM
I have a query that is returning empty cells and I cannot figure out
why. Could someone look at my query and let me know why I am
displaying empty cells? Thank you in advance.
SELECT
{ NonEmptyCrossjoin ( { [Time].[All Time].[2003],
[Time].[All Time].[2003].Children },
{ [Measures].[Budget] } ) } ON COLUMNS,
{ NonEmptyCrossjoin ( { Crossjoin ( { DrillDownLevel ( {
[RptStrc].[All RptStrc].[Field Ops],
DrillDownLevel ( { [RptStrc].[All RptStrc].[Field Ops] } ) } ) },
{ [Account].&[30000],
[Account].&[40100],
[Account].&[40101],
[Account].&[40102],
[Account].&[40103],
[Account].&[30],
[Account].&[50],
[Account].[(All)].Members } ) } ) } ON ROWS
FROM
[Contribution] |