Monday, February 20, 2012

MDX Parameter query

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
Karenselect {[Period].[Period].Members} on axis(0)
from [Timesheet]
"KarenM" <karenmiddleol@.yahoo.com> wrote in message
news:1158930431.269312.221390@.e3g2000cwe.googlegroups.com...
>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
>

No comments:

Post a Comment