I have a Timesheet cube and I am reporting against it in Reporting
Services.

I have a parameter called FromParam in the report and I want to use the
following
MDX Query for the parameter:

select {[Period].[Period].Members} on rows , {} on columns from
Timesheet

All I want is a list of periods on rows I do not want anything on
columns please help me when I run this query I get a message:

Unable to display opened cellset. Cells cannot be created for this
cellset because one of the axes contains no positions.

All I want is a one axis query.

Thanks
Karen

select {[Period].[Period].Members} on axis(0)
from [Timesheet]

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote