Append two results in MDX

I have a requirement where I need to display the total count of the population by Gender and Race (both dimensions) in one report. The layout will look something similar to …

Count1

Count2

…

Male

Female

American Indian or Alaska Native

Asian or Pacific Islander

Black, non-Hispanic

Hispanic

White, non-Hispanic

In simple SQL terms this can be achieved by UNION ALL clause,

Select Gender, Count1, Count2…From Table1 Group by Gender

UNION ALL

Select Race, Count1, Count2…From Table1 Group by Race

How can I get similar results in MDX or Reporting Service?

Thanks

In MDX you cannot mix different members in one column, so you would have to end up at a set that looked like the following:

Count1

Count2

…

Male - All Races

Female - All Races

All Genders - American Indian or Alaska Native

All Genders -Asian or Pacific Islander

All Genders -Black, non-Hispanic

All Genders - Hispanic

All Genders - White, non-Hispanic

Which you would do with a query like:

SELECT {Measures.Count1, Measures.Count2} ON COLUMNS

{

[Gender].[Gender].[Gender].Members * {[Race].[Race].[All] }

,{[Gender].[Gender].[All]} * [Race].[Race].[Race].Members

} ON ROWS

FROM [Cube]

append items to a dataset

Hi,
I have a dataset, which is used for a listbox to display items. I
need to append new static items to the ones returned by the dataset, without
making any changes to the original db. Can anyone help'
ThanksHi!
Not sure if this is exactly what you want, but if you edit the dataset
and then select the fields tab, you can add fields on that screen. For
'type' select calculated.
Bob
"Loui Mercieca" <loui@.gfi.com> wrote in message
news:eqgmsQymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a dataset, which is used for a listbox to display items. I
> need to append new static items to the ones returned by the dataset,
without
> making any changes to the original db. Can anyone help'
> Thanks
>|||Note: Right clicking in Report Designer's Fields Window will expose adding,
editing, or deleting fields.
You can combine static text with data returned from a query in a textbox by
using an expression:
="Some static text" & Fields!<FieldName>.Value
This notion can be extended to handle situations where the static text needs
to be applied dynamically.
Assume that field in the example is an integer:
=iif(Fields!<FieldName>.Value < 100, "The target was missed: " &
Fields!<FieldName>.Value, "The target was exceed: " &
Fields!<FieldName>.Value)
Please see using expression in SQL Server 2000 Reporting Services BOL.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob Hug" <JediMasterHug@._Remove_bobhug.com> wrote in message
news:%23308m6zmEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi!
> Not sure if this is exactly what you want, but if you edit the dataset
> and then select the fields tab, you can add fields on that screen. For
> 'type' select calculated.
> Bob
> "Loui Mercieca" <loui@.gfi.com> wrote in message
> news:eqgmsQymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > I have a dataset, which is used for a listbox to display items.
I
> > need to append new static items to the ones returned by the dataset,
> without
> > making any changes to the original db. Can anyone help'
> >
> > Thanks
> >
> >
>

API for notificationEnumeration in notification

hi all
i have found for function as function:SubscriptionEnumeration in API of notification service, i want display myAlert(notifications) in(for example: one day).
the Function SubscriptionEnumerationdisplay Subscription of (subscriberId,subscriptionType,nsApplication)
it can be made this ?

thanks
HungN

i don't think SQL notification services isn't support for this? isn't it? any advice?