missing pivot table columns

B

bren

When I run this MDX query in the MDX query editor in SQL Server 2005
Management Studio, I get all of the columns and rows for each of the
measures included in the command text.

SELECT {
{ [FiscalPeriodTime].[Year].&[FY2004],
[FiscalPeriodTime].[Year].&[FY2005] } *
{ [FiscalPeriodTime].[DATE].ALLMEMBERS } *
{ [Measures].[Total Cost], [Measures].[Total Eff], [Measures].[Tot
Rev], [Measures].[ELM] }
} ON COLUMNS,
NON EMPTY {
( [VOrg_Div].[Level1].ALLMEMBERS * [VOrg_Div].[Level2].ALLMEMBERS *
[VOrg_Div].[Level3].ALLMEMBERS )
} ON ROWS
FROM [Projects]

When I make this statement the CommantText property of the PivotTable,
only the [Measures].[Tot Rev] column appears in the control display.

I can then drag the missing columns into place, but I'm wondering why
they are missing.

Thanks, Bren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 1
Visualising MDX with colored CM in OWC 7
how to add a total to a pivot table 7
MS Access 2010 pivot table as subreport 0
Filtering a Pivot Table on the client side 10
Avoid expand some nodes but not another ones in Pivot Table. 1
Pivot drill through 0
Totals For An Inside Row Field In a Pivot Table 1

Top