I have a MDX query that queries a cube to retrieve the years available.

now, i want to add an "All Years" to my combo. how can i do that?

i'm making my report with report designer.

Besides the obvious solution by adding an all-level to your
time-dimension in your cube, you could do something like this:

(I don't know your actual query, but you hopefully get the idea)

With member [Time].[All Years] as 'Sum([Time].[Year].members)'
Select
{[Measures].members } on columns,
{[Time].[All Years], [Time].[year].members} on rows
From [Your Cube]

(You could substitute the "[Time].[All], [Time].[year].members"
expression by "AddCalculatedMembers([Time].[year].members)")

This obviously requires that your enter / modify the MDX-query by hand,
and that should be possible (if not mandatory ?) in the report designer,
as far as I know.

Regards
Dan Reving

Durval Mateus wrote:

Hi Dan,

Thanks for the reply. it helped.

My problem is i'm new on this, and the MDX thing...

Regards,
Durval Mateus

"Dan Reving" wrote:

/************************************************** *****
assumes you have a [Time] dimension
you'll get [All Time] member at top of your list, with the remaining [Time]
members filling out the rest of your list
************************************************** *****/
with
member [Time].[All Time] as '[Time].[All Time]'
member [Measures].[TimeCurrentMemberName] as '[Time].CurrentMember.Name'
select
{
[Measures].[TimeCurrentMemberName]
} on columns,
{
([Time].[All Time]*[Time])
} on rows
From YourCube

"Durval Mateus" wrote:

hi,

thanks for the reply, i have now what i want.

Regards,
Duval Mateus

"mike" wrote: